Analytics Engineer

Benchmark Utility Services•Dulles, VA

About The Position

The Analytics Engineer builds and supports the reporting, data preparation, and business solutions layer of technology environments delivered to 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, the position owns a queue of small client projects and works with stakeholders across project management, operations, safety, HR/payroll, and accounting. The work is primarily technical, with some direct user support. The role develops and maintains semantic models and reports, prepares and validates reporting data, and delivers small client solutions from scoping through implementation. It also documents data flows and solutions, follows environment and change-control standards, supports user access and adoption, and contributes to assigned 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.
Ability to learn new tools quickly and select the right tool for the problem.
Strong debugging skills and ability to work independently.
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, or Dataverse; 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.

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 visuals users can interpret without training.
Maintain models in source control with consistent naming and documentation, and submit model changes to the Director for review before production release.
Build gold-layer reporting tables using Python notebooks and Dataflows Gen2, following 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, and document fixes; 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 appropriate platforms, including 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 each solution’s 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 report, data, and solution questions; triage and resolve user issues and escalate platform-level issues.
Gather requirements and feedback from client stakeholders and 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.