Senior Data Analyst

vConstruct, a Pune based Construction Technology company 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. 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. 3. Develop and maintain dashboards and reports using tools like Power BI, Paginated Reports, and Excel to support project decision-making. 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: 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. - 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: 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-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 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 .