Analytics Engineer

Benchmark Utility Services

. Build and maintain semantic models, including dimensional designs, DAX measures, and configuration tables, on curated lakehouse data .

Posted 11/7/2026full-timeDulles • Virginia • United StatesMid-LevelSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in building and maintaining semantic models, developing reports and dashboards, and implementing solutions using Power BI, SQL, and Python. Proficient in data quality checks, automation of processes, and client project management.

Highest-signal resume keywords

Power BIDAXSQLPythonData Analytics

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Dimensional ModelingETL/ELT ConceptsData Quality ChecksDataflows Gen2API IntegrationsData CleanupData StandardizationReporting TablesBusiness IntelligenceRelational Data Modeling

Soft Skills

Clear CommunicationOrganizedSelf-DirectedProblem-SolvingClient-Facing Experience

Tools & Technologies

Microsoft FabricPower AppsPower AutomateSharePointDataverseAzureREST APIsJSONLakehouseNotebooks

Industry Keywords

ConstructionEngineeringERP SystemsHR SystemsPayroll Systems

Tech Stack

Tools & technologies

AzureCloudERPETLPythonSQL

About the role

Key responsibilities & impact

Build and maintain semantic models, including dimensional designs, DAX measures, and configuration tables, on curated lakehouse data
Develop reports and dashboards for client project management, operations, and safety audiences
Design clear, action-oriented visuals
Maintain models in source control with consistent naming and documentation
Submit model changes for Director review before production release
Build gold-layer reporting tables using Python notebooks and Dataflows Gen2
Lead data cleanup and standardization initiatives and drive corrections at the source
Perform data quality checks and reconciliation across client source systems
Monitor refresh reliability, troubleshoot failures, and document fixes
Support bronze and silver pipeline work
Own assigned small client projects from scoping through delivery
Recommend and implement solutions using Power Apps, SharePoint, Dataverse, Power Automate, low-code tools, or custom code
Automate recurring manual processes
Build API integrations with client and partner platforms under the Director's design and standards
Document solution designs, rationale, and support requirements
Maintain project status in the team's project tracking system
Document data flows, table definitions, business rules, and refresh schedules
Follow development/production environment, naming, and change-control standards
Maintain separation of client data, environments, and access
Support role-based access on datasets and reports
Serve as 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
Create guides and training materials for end users
Support user adoption and change management efforts
Stay current on data, BI, and AI capabilities and recommend tools for client solutions
Support AI pilot use cases focused on business process improvements

Requirements

What you’ll need

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

Comp & perks

Competitive compensation
Comprehensive benefits
Dynamic work environment
Professional growth opportunities