Analytics Engineer

Benchmark Utility Services; Virginia; On-site; USD 100,000 - 130,000; Full time

Job summary

Benchmark Utility Services is seeking an Analytics Engineer to build semantic models, reports, and data preparation pipelines for client environments. You will transform curated client data into reliable models and practical solutions, while supporting governance across systems.

You will manage small client projects from scope to delivery, implement solutions using Power Apps, SharePoint, Dataverse, and other tools, and ensure data quality and reproducibility in production environments.

Qualifications

• Bachelor's degree in Information Systems, Computer Science, Data Analytics, or related field, or equivalent practical experience.
• 3-5 years of experience (internships and projects included) in BI, data, or solution development.
• 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.
• Hands-on experience with Microsoft Fabric (Lakehouse, notebooks, Dataflows Gen2, pipelines), Azure, or comparable cloud data platforms preferred.
• Experience with Power Apps/Power Automate/SharePoint/Dataverse, REST APIs, and JSON preferred.
• Construction/engineering background preferred; exposure to ERP, HR/payroll systems (e.g., Spectrum, HCSS, ADP).
• Consulting or client-facing experience preferred.

Responsibilities

• Builds and maintains semantic models for client projects.
• Develops reports and dashboards for project management, operations, and safety audiences.
• Designs clear visuals that require minimal training.
• Maintains models in source control with naming and documentation.
• Submits model changes for Director review before production release.
• Builds gold-layer tables for reporting using Python notebooks and Dataflows Gen2.
• Leads data cleanup and standardization initiatives with data owners.
• Performs data quality checks and reconciliation across client source systems.
• Monitors refresh reliability and documents fixes.
• Owns a queue of small client projects from scoping through delivery.
• Automates recurring manual processes and builds API integrations.
• Documents design rationale and support requirements for each solution.

Skills

Strong debugging skills

Clear written & verbal communication

Organized & self-directed

Ability to learn new tools quickly

Consulting or client-facing experience

Education

Bachelor's degree in Information Systems, Computer Science, Data Analytics, or related field

Tools

Power BI

SQL

Python

Microsoft Fabric

Azure

REST APIs

JSON

Job description

The Analytics Engineer builds and supports the reporting, data preparation, and business solutions layer of the technology environments NextEra delivers to its clients. This 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 client stakeholders across project management, operations, safety, HR/payroll, and accounting. The work is primarily technical, with some direct support for client users.

Business Intelligence & Semantic Modeling

• Builds and maintains semantic models (dimensional design, DAX measures, configuration tables) on curated lakehouse data
• Develops reports and dashboards for client project management, operations, and safety audiences
• Designs clear, action-oriented visuals that users can interpret without training
• Maintains models in source control with consistent naming and documentation
• Submits model changes for Director review before production release

Data Preparation & Quality

• Builds gold-layer tables for reporting using Python notebooks and Dataflows Gen2, following the set standards
• Helps lead data cleanup and standardization initiatives, including defining standards, resolving discrepancies across systems, and working with business data owners to drive corrections at the source
• Performs data quality checks and reconciliation across client source systems (e.g., ERP, HR/payroll, field systems)
• Monitors refresh reliability, troubleshoots failures, and documents fixes
• Supports bronze and silver pipeline work as assigned

Small Projects & Solution Delivery

• Owns an assigned queue of small client projects from scoping through delivery
• Recommends and implements solutions that fit each business need, using the appropriate platform (e.g., Power Apps, SharePoint, Dataverse, Power Automate, other low-code tools, or custom code)
• Automates recurring manual processes
• Builds API integrations with client and partner platforms as assigned, under the Director's design and standards
• Documents each solution's design, rationale, and support requirements
• Keeps project status current in the team's project tracking system

Documentation & Governance

• Documents data flows, table definitions, business rules, and refresh schedules
• Follows development/production environment, naming, and change-control standards
• Maintains separation of client data, environments, and access
• Supports role-based access on datasets and reports as directed

User Support

• Serves as first point of contact for client report, data, and solution questions
• Triages and resolves user issues, and escalates platform-level issues
• Gathers requirements and feedback from client stakeholders
• Creates short guides and training materials for end users
• Supports the VP of Technology Innovation's user adoption and change management efforts for delivered solutions

AI & Emerging Technology

• Stays current on data, BI, and AI capabilities and recommends tools that improve client solutions
• Supports AI pilot use cases identified by the Director and the VP of Technology Innovation, grounded in business process improvements

• Bachelor's degree in Information Systems, Computer Science, Data Analytics, or a related field, or equivalent practical experience
• 3-5 years of experience (internships and projects included) in BI, data, or solution development
• 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
• Hands-on experience with Microsoft Fabric (Lakehouse, notebooks, Dataflows Gen2, pipelines), Azure, or comparable cloud data platforms preferred
• Experience with low-code and workflow platforms (e.g., Power Apps, Power Automate, SharePoint, Dataverse), REST APIs, and JSON preferred
• Construction, engineering, or similarly complex industry background preferred, including exposure to construction ERP, HR, or payroll systems (e.g., Spectrum, HCSS, ADP)
• Consulting or client-facing experience preferred
• Ability to learn new tools quickly and select the right one for the problem
• Strong debugging skills and the ability to work independently
• Clear written and verbal communication; able to work effectively with non-technical users and business data owners
• Organized and self-directed, able to manage multiple concurrent requests and drive work to completion

Benchmark Utility Services offers competitive compensation, comprehensive benefits and a dynamic work environment that values excellence, teamwork, and professional growth.

Equal Opportunity Employer.