Project Controls Data Analyst III
On-siteBirmingham, Alabama, United States
Job Summary
Independently produce complex analytics and reporting across dashboards, BI, progress, performance, risk, and change management. Build enterprise-grade Power BI reports and robust DAX/Power Query models; validate row-level security and refresh reliability. Own the monthly earned-value calculation and variance analysis for assigned projects; prepare root-cause and corrective-action narrative. Lead risk-register maintenance and support quantitative (Monte Carlo) risk inputs; monitor contingency drawdown and flag acceleration. Administer the PCO/PDN log and change reporting for assigned projects; classify changes and produce the change order report. Own delivery of assigned sections of the monthly project controls package end to end, including quality assurance before publication. Reconcile published outputs to JDE within tolerance; investigate and resolve non-routine discrepancies. Translate stakeholder requirements into governed dashboard and report specifications. Provide technical guidance and informal mentoring to junior analysts; review their work for accuracy. Contribute to KPI Dictionary maintenance by proposing and documenting metric definitions and thresholds.
Required Qualifications
- Bachelor's degree in Engineering, Construction Management, Computer Science, Information Systems, Business Analytics, or a related field
- 5-8 years of progressive experience in BI/data analytics or project controls on capital projects
- Demonstrated independent ownership of production reporting or EVM on EPC/construction projects
- Experience across multiple project controls domains (BI, EVM, risk, or change)
- Microsoft Power BI - advanced: composite models, incremental refresh, deployment basics, performance tuning
- DAX - advanced: iterator functions, context transition, time intelligence
- Power Query / M - advanced: parameterized queries and transformation pipelines
- SQL - intermediate to advanced: views, query optimization for validation
- EcoSys - advanced: EVM metric calculation, EAC/ETC methodology
- Oracle Primavera P6 - advanced: progress, resource, and baseline data integration
- JD Edwards (JDE) - strong understanding of cost, WBS, commitments, and actuals
- Microsoft Excel - expert: EVM models, variance and sensitivity analysis
- Working knowledge of AACE EVM standards and QPSG KPI governance
- Power Query, Python, and Databricks - experience with: applies for data transformation, analysis, and reporting
Desired Qualifications
- Microsoft PL-300 certification preferred
- AACE (CCP/CEP) or PMI (PMI-SP/PMP) certification a plus
- Experience on power generation, oil & gas, or heavy industrial EPC projects preferred
- AACE (CCP, CEP, CCEP) or PMI (PMI-SP, PMP) certification
- Exposure to Monte Carlo tools (@Risk, Crystal Ball, Primavera Risk Analysis)
- Experience with Azure Data Services / Microsoft Fabric for enterprise analytics
- Experience on SC/CC power generation EPC projects (CTG, HRSG, STG, ACC, GSU)
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.