Analytics Engineer

Benchmark Utility Services•Dulles, VA

About The Position

The Analytics Engineer builds and supports reporting, data preparation, and business solutions for technology environments NextEra delivers to its clients. The role turns curated client data into reliable semantic models, reports, and practical solutions while supporting data cleanup, standardization, and governance across client systems. Reporting to the Director of Technology Architecture, this position owns a queue of small client projects and partners with stakeholders in project management, operations, safety, HR/payroll, and accounting. The work is primarily technical, with some direct support for client users. The position develops semantic models and reports, prepares and validates reporting data, and delivers small client solutions using suitable platforms and tools. It documents data flows and solutions, follows environment and change-control standards, supports users, and contributes to adoption efforts. It also stays current on data, business intelligence, and AI capabilities and supports selected AI pilot use cases.

Requirements

Bachelor's degree in Information Systems, Computer Science, Data Analytics, or a related field, or equivalent practical experience.
3–5 years of experience in BI, data, or solution development; internships and projects are included.
Working knowledge of Power BI, including DAX, Power Query, and dimensional modeling.
Working knowledge of SQL and Python.
Understanding of ETL/ELT concepts and relational data modeling, with experience profiling, cleaning, and standardizing data.
Clear written and verbal communication skills, including the ability to work effectively with non-technical users and business data owners.
Organized and self-directed, with the ability to manage multiple concurrent requests and drive work to completion.

Nice To Haves

Hands-on experience with Microsoft Fabric (Lakehouse, notebooks, Dataflows Gen2, pipelines), Azure, or comparable cloud data platforms.
Experience with low-code and workflow platforms such as Power Apps, Power Automate, SharePoint, and Dataverse, as well as REST APIs and JSON.
Construction, engineering, or similarly complex industry background, including exposure to construction ERP, HR, or payroll systems such as Spectrum, HCSS, or ADP.
Consulting or client-facing experience.
Ability to learn new tools quickly and select the right tool for the problem.
Strong debugging skills and the ability to work independently.

Responsibilities

Build and maintain semantic models on curated lakehouse data, including dimensional designs, DAX measures, and configuration tables.
Develop reports and dashboards for client project management, operations, and safety audiences, with clear, action-oriented visuals.
Maintain models in source control using consistent naming and documentation, and submit model changes for Director review before production release.
Build gold-layer reporting tables using Python notebooks and Dataflows Gen2 in accordance with established standards.
Help lead data cleanup and standardization initiatives by defining standards, resolving discrepancies across systems, and working with business data owners to correct data at its source.
Perform data quality checks and reconciliation across client source systems, such as ERP, HR/payroll, and field systems.
Monitor refresh reliability, troubleshoot failures, document fixes, and support bronze and silver pipeline work as assigned.
Own an assigned queue of small client projects from scoping through delivery.
Recommend and implement solutions suited to business needs using platforms such as Power Apps, SharePoint, Dataverse, Power Automate, other low-code tools, or custom code.
Automate recurring manual processes.
Build API integrations with client and partner platforms as assigned, following the Director's design and standards.
Document solution design, rationale, and support requirements, and keep project status current in the team's project tracking system.
Document data flows, table definitions, business rules, and refresh schedules.
Follow development and production environment, naming, and change-control standards; maintain separation of client data, environments, and access.
Support role-based access on datasets and reports as directed.
Serve as the first point of contact for client questions about reports, data, and solutions; triage and resolve user issues and escalate platform-level issues.
Gather requirements and feedback from client stakeholders.
Create short guides and training materials for end users.
Support the VP of Technology Innovation's user adoption and change management efforts for delivered solutions.
Stay current on data, BI, and AI capabilities and recommend tools that improve client solutions.
Support AI pilot use cases identified by the Director and the VP of Technology Innovation, grounded in business process improvements.