About the Role The
Project Controls Analyst • Data & Business Intelligence manages monthly project controls audits across all construction projects and supports the transition to a fully automated audit process. This role applies strong data-modeling, analytical, 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 closely with IT, Project Controls, and project teams to define reporting needs, improve data access and reliability, and increase visibility into project performance. A willingness to collaborate with IT and develop additional technical capabilities, including ETL knowledge, is essential to success in this role.
Essential Functions - 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, 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.
Basic Qualifications - 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 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.
Preferred Qualifications - Construction industry experience, including familiarity with project cost, forecast, change, contract, schedule, or financial data.
- Project controls, project accounting, project finance, audit, compliance, or operational reporting experience.
- 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, including working knowledge of SQL or database structures. Candidates who are willing to develop these capabilities through collaboration with IT and vendor resources will also be considered.
- Ability to transform business requirements into clear, concise, and 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.
Compensation - This position offers a base salary range of $100,000 - $120,000 annually, based on skills and experience.
Benefits - Group health & welfare benefits including options for medical, dental and vision
- 100% Company Paid Benefits: Employee Life Insurance & Accidental Death & Dismemberment (AD&D), Spouse and Dependent Life & AD&D, Short Term Disability (STD), Long Term Disability (LTD), Employee Assistance Program and Health Advocate
- Voluntary benefits at discounted group rates for accidents, critical illness, and hospital indemnity
- Flexible Time Off Program (includes vacation and personal time)
- Paid Sick and Safe Leave
- Paid Parental Leave Program
- 10 Paid Holidays
- 401(k) Plan (company matching contributions up to 4%).
- Employee Referral Program
