Responsibilities
- Develop and manage advanced Power BI dashboards for project controls, including cost, schedule, risk, change management, and resource tracking.
- Create and maintain data models, ETL processes, and Power Query transformations to ensure reliable and automated data pipelines.
- Collaborate with Project Managers, Cost Controllers, Planners, and Senior Management to understand reporting requirements and translate them into technical solutions.
- Drive KPI-based performance reporting, including traffic-light-based status (SPI, CPI, EVM metrics, milestone tracking, etc.).
- Integrate and analyze data from project management systems such as Primavera (P6), Oracle Unifier, Deltek, or ACC Build.
- Develop predictive analytics models for forecasting project cost overruns, delays, and risk exposure.
- Implement role-level security and dynamic reporting for different business units, divisions, or clients.
- Ensure data governance, standardization, and reporting accuracy across multiple large-scale construction projects.
- Train and mentor project teams on effective use of Power BI reports and project analytics dashboards.
Technical Skills
- Expert-level proficiency in Power BI (DAX, Power Query, Data Modeling, Visualization).
- Strong knowledge of SQL, Power Automate, and data integration from multiple systems.
- Solid understanding of project controls frameworks: Earned Value Management (EVM), SPI, CPI, Cost Performance, S-Curves, Forecasting.
- Familiarity with construction project systems: Primavera P6, Oracle Unifier, PMWeb, Aconex, Deltek Vision/Costpoint.
- Ability to manage large datasets from multiple sources efficiently.
- Knowledge of data governance, data quality assurance, and best practices in reporting.
Project Controls Domain Expertise
- Deep understanding of construction project lifecycles: design, procurement, construction, commissioning.
- Strong grasp of contract types (EPC, Lump Sum Turnkey, Design-Build, FIDIC).
- Experience working with cost, schedule, risk, and change management data.
Analytical & Communication Skills
- Ability to translate complex datasets into simple, actionable management insights.
- Strong business acumen to advise leadership based on data trends and project health.
- Excellent verbal and written communication skills.
- Ability to work across multicultural, multidisciplinary teams in a fast-paced environment.
Preferred Qualifications
- Bachelor's or master's degree in engineering, Construction Management, Project Management, Computer Science, or related fields.
- Minimum 8+ years of experience in engineering or construction companies.
- Relevant certifications are a plus:
- Microsoft Certified: Power BI Data Analyst Associate (PL-300)
- Project Management Professional (PMP) or PMI-SP/PMI-RMP is a strong advantage.
- Primavera P6 Certification (optional but advantageous).
Key Attributes We Look For
- Proactive mindset focused on accuracy, efficiency, and timely delivery.
- Strong problem-solving and critical thinking ability.
- Self-driven and capable of working independently.
- Passion for digital transformation and continuous improvement in project controls.
