Sr. Data Analyst - Project Controls

Vconstruct; Nagpur District, Pune District; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

vConstruct seeks a Senior Data Analyst to support large-scale construction projects with data-driven insights. The role emphasizes cost, schedule, risk, quality, and safety analytics, translating requirements into BRD/FRD and delivering actionable dashboards and reports.

You will collaborate with project teams and clients, perform QA checks, and work with SQL, Python/R, and ETL tools to maintain data models and support forecasting. Strong communication is essential.

Qualifications

• 5–8 years of combined experience in data analysis and construction or infrastructure domains.
• Experience applying data analytics to construction-related functions, with exposure to project controls.

Responsibilities

• Collaborate with project teams to translate requirements into analytical solutions (BRD/FRD).
• Analyze large datasets on Cost, Schedule, Risk, Quality, Safety to identify trends and insights.
• Develop and maintain dashboards and reports using Power BI, Paginated Reports, and Excel.
• Validate data quality and ensure accuracy of reports and models.
• Optimize data models and ETL processes with data engineering teams.
• Support forecasting and predictive analytics for cost overruns and delays using Python/R.
• Track KPIs and communicate findings to stakeholders.
• Contribute to continuous improvement of data processes and reporting standards.

Skills

Power BI

Power Platform

SQL

Python

R

APIs & ETL

Data warehousing

Advanced Excel

Construction analytics

Paginated Reports

Education

Bachelor's or Master's in Engineering/Construction Management/Analytics

Tools

SQL Server

Snowflake

Primavera P6

ACC

CMiC

Power Automate

PowerApps

Paginated Reports

Job description

vConstruct, a Pune based international engineering and construction services firm seeks a Senior Data Analyst for their Data Science and Analytics team which is a tight-knit group of analysts and engineers that support all data aspects of business.

Job Summary:

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:

• Collaborate with project teams and clients to understand business requirements and translate them into analytical solutions (BRD/FRD).
• Analyze large, complex datasets related to construction projects (Cost, Schedule, Risk, Quality, Safety, etc.) to identify trends, anomalies, and actionable insights.
• Develop and maintain dashboards and reports using tools like Power BI, Paginated Reports, and Excel to support project decision-making.
• Perform data validation and quality assurance checks to ensure accuracy and consistency of reports and models.
• Optimize and maintain data models and ETL processes in collaboration with data engineering teams.
• Support forecasting and predictive analytics for cost overruns, schedule delays, and risk exposure using statistical tools (e.g., Python, R).
• Track and report on key project performance indicators (KPIs) and project controls.
• Communicate findings and recommendations clearly to technical and non-technical stakeholders.
• Contribute to continuous improvement of data processes and reporting standards.

Skills:
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: The analyst should possess a strong understanding of construction cost structures and estimating practices to effectively interpret and analyze financial data.
• 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: The analyst should understand construction scheduling methodologies and dependencies to accurately assess project timelines and risks.
• Track Monitor project timelines and milestone progress using scheduling tools like Primavera P6.
• Identify schedule variances and potential delays through trend analysis and critical path evaluation.
• Integrate schedule data with cost and resource metrics to support holistic project performance reviews.
• Quality: The analyst should be familiar with construction quality assurance processes to interpret inspection data and support continuous improvement.
• 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: The analyst should understand construction safety protocols and reporting standards to effectively analyze incident data and support risk mitigation.
• 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: 5 to 8 years of combined experience in data analysis and construction or infrastructure domains. Candidates should demonstrate hands-on experience applying data analytics to construction-related functions. Prior roles in project controls, construction management, or field operations with exposure to data-driven decision making are highly preferred.
• Education: bachelor's or master's degree in engineering, Construction Management, Business Analytics, or a related field.
• Client Experience: Preferred experience working with US or international clients. Preferred Tools & Platforms:
• Project Management Tools: Primavera P6, ACC, CMiC
• Databases: SQL, Snowflake
• BI Tools: Power BI, Power Platforms
• Others: Advanced Excel, Paginated Reports

About vConstruct:

vConstruct specializes in providing high-quality Building Information Modeling and Construction Technology services geared towards construction projects. vConstruct is a wholly owned subsidiary of DPR Construction. vConstruct has 100+ team members working on Software Development, Data Analytics, Data Engineering and AI/ML. We have matured Data Science practice and growing at an accelerated pace. 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 thingsgreat teams, great buildings, great relationshipsDPR is a truly great company. For more information, please visit www.dpr.com.