Project Controls Data Analyst III
Birmingham, MI - USA
Job Summary
Quanta Power Solutions brings together the industry-leading capabilities and resources of Quantas operating companies to deliver complete EPC solutions. Our integrated approach spans power generation battery energy storage renewables transmission substation and underground infrastructure from concept to commissioning we execute complex power infrastructure projects with the speed certainty and operational excellence our customers depend on.
At Quanta Power Solutions we are driven by a culture of safety integrity and disciplined execution and were building a team that shares that commitment.
Quanta Power Solutions is seeking an experienced Project Controls Data Analyst III to support project controls through advanced data analytics business intelligence and performance reporting. This role develops dashboards analyzes cost and schedule performance supports risk and change management reporting and delivers actionable insights for large-scale EPC projects.
Working closely with project managers finance and project controls teams the Data Analyst III ensures data integrity improves reporting processes and helps drive informed business decisions across the project lifecycle while providing technical guidance to junior analysts.
- 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 (PM Finance Controls leadership) into governed dashboard and report specifications
- Provide technical guidance and informal mentoring to DA 1 and DA 2 staff; review their work for accuracy
- Contribute to KPI Dictionary maintenance by proposing and documenting metric definitions and thresholds
Education
- Bachelors degree in Engineering Construction Management Computer Science Information Systems Business Analytics or a related field
- Microsoft PL-300 certification preferred; AACE (CCP/CEP) or PMI (PMI-SP/PMP) certification a plus
Experience
- 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) preferred
- Experience on power generation oil & gas or heavy industrial EPC projects preferred
Technical Skills
- 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
Preferred Qualifications
- 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)
- Competitive Compensation
- Weekly Pay
- 401(k) Retirement Plan
- Holiday Pay
- Paid Time Off (PTO)
- Comprehensive Health Coverage
- Pet Insurance
- Employee Assistance Program (EAP)
- Professional Development Opportunities
- Tuition Assistance
- Employee Discount Program
All qualified applicants will receive consideration for employment and will not be discriminated against on the basis of race color religion national origin or ancestry sex (including gender pregnancy sexual orientation and/or gender identity) age disability genetic information veteran status and/or any other basis protected by applicable federal state or local law.
We are an Equal Opportunity Employer including disability and protected veteran status.
We prohibit all types of discrimination and are committed to providing access and equal opportunity for individuals with disabilities. For additional information or if reasonable accommodation is needed to participate in the job application interview or hiring processes or to perform the essential functions of a position please contact us the Companys Human Resources department.
Required Experience:
IC
About Company
Quanta has built the largest craft labor force in North America by uniting over 200 operating companies to tackle the most complex infrastructure challenges in the world.