Data & BI Analyst for Project Controls & Automation

MWH Constructors, Inc.; Broomfield (CO); On-site; USD 100,000 - 120,000; Full time

Benefits offered by this job

Base salary $100k-$120k

Health benefits

Life insurance

AD&D coverage

STD/LTD

401(k) match

Paid holidays

Paid parental leave

Flexible PTO

Employee referral program

Job summary

MWH Constructors, Inc. is seeking a Project Controls Analyst - Data & BI to manage monthly project controls audits across all active construction projects and to help transition to an automated audit process.

You will build scalable reports and dashboards from CMiC, Power BI, and a centralized reporting database. The role requires strong data modeling, ETL knowledge, and collaboration with IT and project teams to improve data access, reliability, and visibility into performance.

Qualifications

• Bachelor’s degree in data analytics, information systems, computer science, business, construction management, engineering, finance, or a related field.
• Experience in data analysis, business intelligence, dashboard development, and modeling data to support reporting and business decisions.
• Strong Microsoft Power BI skills, including data modeling, Power Query, dashboard design, and report publishing.
• Ability to understand source data, define relationships and business rules, and structure data into reliable models that support audit and reporting needs.
• Demonstrated willingness and ability to collaborate closely with IT, system administrators, vendors, and business stakeholders to develop and support reporting solutions.
• Strong analytical, problem-solving, quality-control, documentation, and communication skills, with the ability to clearly explain business needs and intended outcomes.

Responsibilities

• Manage the monthly project controls audit cycle for all active construction projects.
• Develop automated audit reports, data models, workflows, and dashboards using CMiC and Microsoft Power BI.
• Lead the conversion of manual audit activities into a reliable, repeatable, and fully automated process in collaboration with IT and internal or external technical resources.
• Model, reconcile, and analyze large datasets to identify trends, anomalies, control gaps, recurring findings, and data-quality issues.
• Partner closely with IT to define data-access needs, reporting requirements, business rules, and desired end states for solutions using CMiC and the centralized enterprise reporting database.
• Translate audit and project controls needs into clear, concise, and actionable requests, including data definitions, calculations, technical specifications, and visualization requirements.
• Validate report outputs against source systems and business rules; troubleshoot issues collaboratively with IT and system administrators.
• Work with project teams to resolve discrepancies, strengthen compliance, document reporting logic, and communicate actionable insights.

Skills

Power BI

Data modeling

SQL

ETL

Data analysis

Collaboration

Communication

Education

Bachelor's degree in relevant field

Tools

CMiC

Job description

MWH Constructors, Inc. is seeking a Project Controls Analyst - Data & BI to manage monthly project controls audits across all active construction projects and to help transition to an automated audit process.

You will build scalable reports and dashboards from CMiC, Power BI, and a centralized reporting database. The role requires strong data modeling, ETL knowledge, and collaboration with IT and project teams to improve data access, reliability, and visibility into performance.