Project Controls Analyst � Data & Business Intelligence

MWH • Broomfield, CO

9d • Onsite

About The Position

The Project Controls Analyst – Data & Business Intelligence manages monthly project controls audits across all active construction projects and supports the transition to a fully automated audit process. The role uses data modeling, analytics, and business intelligence skills to organize information from CMiC, Microsoft Power BI, and the company’s centralized reporting database into accurate, scalable reports and dashboards. The analyst works with IT, Project Controls, and project teams to define reporting needs, improve data access and reliability, and increase visibility into project performance. Collaboration with IT and willingness to develop additional technical capabilities, including ETL knowledge, are important to success.

MWH is a water and wastewater treatment-focused general contractor and a heavy civil construction project delivery company. It provides integrated design and construction services for water and wastewater treatment infrastructure, facilities, infrastructure improvements and expansions, and capital construction projects.

Requirements

• Bachelor’s degree in data analytics, information systems, computer science, business, construction management, engineering, finance, or a related field; equivalent relevant experience may be considered.
• Experience in data analysis, business intelligence, dashboard development, and data modeling for 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 models for audit and reporting needs.
• Demonstrated ability and willingness to collaborate with IT, system administrators, vendors, and business stakeholders on reporting solutions.
• Strong analytical, problem-solving, quality-control, documentation, and communication skills, including the ability to explain business needs and intended outcomes clearly.
• Willingness to collaborate with IT and develop additional technical capabilities, including ETL knowledge.

Nice To Haves

• Construction industry experience, including familiarity with project cost, forecast, change, contract, schedule, or financial data.
• Experience in project controls, project accounting, project finance, audit, compliance, or operational reporting.
• Experience with CMiC or a comparable construction ERP and a centralized data warehouse or reporting database.
• Experience extracting, transforming, loading, validating, or reconciling data from relational databases and enterprise systems; working knowledge of SQL or database structures.
• Ability to develop ETL and related technical capabilities through collaboration with IT and vendor resources.
• Ability to translate business requirements into concise, actionable requests for IT with well-defined goals, business rules, and desired end states.
• Familiarity with data governance, role-based access, security, testing, deployment, and workflow automation.

Responsibilities

• Manage the monthly project controls audit cycle for all active construction projects, including data validation, exception review, follow-up, and leadership reporting.
• Develop and maintain 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, 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 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 actionable requests, including data definitions, calculations, technical specifications, and visualization requirements.
• Validate report outputs against source systems and business rules, and troubleshoot issues with IT and system administrators.
• Work with project teams to resolve discrepancies, strengthen compliance, document reporting logic, and communicate actionable insights.

Benefits

• Group health and welfare benefits, including medical, dental, and vision options.
• Company-paid employee life insurance and accidental death and dismemberment insurance, spouse and dependent life and AD&D, short-term disability, long-term disability, Employee Assistance Program, and Health Advocate.
• Voluntary benefits at discounted group rates for accidents, critical illness, and hospital indemnity.
• Flexible Time Off Program, including vacation and personal time.
• Paid Sick and Safe Leave.
• Paid Parental Leave Program.
• 10 paid holidays.
• 401(k) plan with company matching contributions up to 4%.
• Employee Referral Program.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level