Analytics Engineer

Benchmark Utility Services; Dulles Town Center (VA); Presencial; USD 90.000 - 120.000; Tempo integral

Resumo da vaga

Benchmark Utility Services is seeking an Analytics Engineer to build and support reporting, data prep, and semantic models across client systems. You will turn curated client data into reliable dashboards and practical solutions, collaborating with stakeholders in project mgmt, operations, HR/payroll, and accounting.

You will own a queue of small client projects, design visuals, ensure data quality, and implement low-code or custom solutions.

Qualificações

• 3–5 years of experience in BI, data, or solution development.
• Power BI with DAX and Power Query.
• SQL and Python proficiency.
• ETL/ELT concepts and data profiling, cleaning.
• Experience with Microsoft Fabric or Azure or similar cloud platforms.
• Exposure to low-code/workflow platforms (Power Apps, Power Automate, SharePoint, Dataverse).
• Consulting or client-facing experience.
• Strong written and verbal communication; able to work with non-technical users.

Responsabilidades

• Build semantic models and reports for client projects.
• Develop dashboards for project management, operations, and safety audiences.
• Design visuals that are easy to interpret without training.
• Maintain models with source control and documentation.
• Own small client project queues from scoping to delivery.
• Implement solutions using Power Apps, SharePoint, Dataverse, or custom code.
• Automate recurring processes and build API integrations.

Conhecimentos

Power BI

SQL

Python

DAX

Formação

Bachelors or equivalent

Ferramentas

Microsoft Fabric

Azure

SharePoint

Dataverse

Descrição da vaga

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

Requirements

• 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

Benefits

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

Equal Opportunity Employer.