5+ years of experience in data analysis, preferably in project controls or related fields.
Strong proficiency in Power BI, including dashboard creation and DAX formulas.
Expertise in integrating data from various sources such as Primavera P6 and ERP systems.
Experience using Power Query for data extraction and transformation.
Solid understanding of project management processes and metrics.
Responsibilities
Design and maintain interactive Power BI dashboards for project reporting.
Integrate data from multiple sources including project controls and risk management systems.
Utilize Power Query to cleanse and transform project data.
Develop DAX measures to enhance project-performance reporting.
Create executive-level dashboards to highlight trends and performance issues.
Analyze project performance using trend and variance analyses.
Collaborate with cross-functional teams to understand reporting needs.
Benefits
Remote work flexibility for candidates in specific states.
Opportunities for professional development and upskilling.
Collaborative team environment with cross-disciplinary engagement.
Full Job Description
Manifest Solutions is currently seeking a Power BI Project Controls Data Analyst for a remote position. Must reside in one of the following states, OH, TX, LA, OK, WV, VA, IN, MI, KY, AR, TN.
Design, develop, and maintain interactive Power BI dashboards for project and portfolio reporting.
Integrate data from multiple sources, including:
Primavera P6
Excel
ERP and cost-management systems
Project controls systems
Risk registers
Other project and enterprise data sources
Use Power Query to extract, transform, cleanse, and integrate project data.
Develop robust DAX measures, calculated columns, and data models to support project-performance reporting.
Develop executive-level reporting that enables leadership to quickly identify performance issues, trends, and areas requiring attention.
Create reporting solutions that consolidate cost and schedule information into a single, consistent view of project performance.
Incorporate quantitative risk-analysis outputs, including Monte Carlo P50/P80/P90 results, into Power BI dashboards when applicable.
Develop trend and variance analyses to identify changes in project performance and emerging areas of concern.
Support reporting of key project-controls metrics, including budget, actuals, forecast, commitments, schedule performance, earned value, and progress.
Partner with project controls, project management, scheduling, estimating, risk, finance, and technology teams to understand reporting requirements and data sources.
Validate data quality, reconcile discrepancies, and ensure dashboards provide
