Senior Data Analyst - Project Controls

vConstruct,

We are seeking a skilled and detail-oriented Data Analyst to support large-scale construction projects through data-driven insights. The ideal candidate will have experience in data analysis, reporting, and visualization, with a strong understanding of Construction Project Controls such as Cost, Schedule, Risk, Quality, and Safety.

Job Responsibilities:

1. Collaborate with project teams and clients to understand business requirements and translate them into analytical solutions (BRD/FRD).

2. Analyze large, complex datasets related to construction projects (Cost, Schedule, Risk, Quality, Safety, etc.) to identify trends, anomalies, and actionable insights.

Power BI

4. Perform data validation and quality assurance checks to ensure accuracy and consistency of reports and models.

5. Optimize and maintain data models and ETL processes in collaboration with data engineering teams.

6. Support forecasting and predictive analytics for cost overruns, schedule delays, and risk exposure using statistical tools (e.g., Python, R).

7. Track and report on key project performance indicators (KPIs) and project controls.

8. Communicate findings and recommendations clearly to technical and non-technical stakeholders.

9. Contribute to continuous improvement of data processes and reporting standards.

Technical Skills:

• Proficiency in Power BI, Power Platform (Power Automate, PowerApps), and Paginated Reports.

• Strong SQL skills for querying and transforming data from relational databases (SQL Server, Snowflake preferred).

• Experience with Python or R for statistical analysis and predictive modeling.

• Familiarity with APIs and ETL processes for data integration.

• Understanding of data warehousing concepts and transactional systems.

• Advanced Excel skills for data manipulation and reporting.

Domain Knowledge (Construction Analytics):

Cost Management:

• Interpret and deconstruct project budgets and estimates into granular cost components.
• Analyze budget vs. actuals to identify cost overruns and savings opportunities.
• Develop and maintain data-driven cash flow forecasts by integrating budget data with trade sequencing and project schedules.
• Collaborate with project controls and finance teams to ensure cost data accuracy and alignment with reporting standards.
• Track and analyze change orders and their impact on scope, cost, and schedule.

Schedule Management:

• Identify schedule variances and potential delays through trend analysis and critical path evaluation.
• Track Monitor project timelines and milestone progress using scheduling tools like Primavera P6.
• Integrate schedule data with cost and resource metrics to support holistic project performance reviews.

Quality:

• Analyze quality inspection data and punch lists to identify recurring issues and trends.
• Develop KPIs and dashboards to monitor quality performance across projects and contractors.
• Support root cause analysis and continuous improvement initiatives using data-driven insights.

Safety:

• Monitor safety incident data and near-miss reports to identify high-risk activities or locations.
• Provide visualizations and reports to aid safety audits and compliance tracking.

Soft Skills:

• Strong analytical thinking and problem-solving skills.

• Excellent communication and stakeholder management abilities.

• Ability to work independently and collaboratively in a fast-paced, deadline-driven environment.

Required Qualifications:

Experience:

Education:

Client Experience:

Preferred Tools & Platforms:

Project Management Tools:

Databases:

BI Tools:

Others:

About vConstruct:

vConstruct

For more information, please visit www.vconstruct.com

About DPR Construction:

DPR Construction is a national commercial general contractor and construction manager specializing in technically challenging and sustainable projects for the advanced technology, biopharmaceutical, corporate office, higher education and healthcare markets. With the purpose of building great things—great teams, great buildings, great relationships—DPR is a truly great company. For more information, please visit www.dpr.com.