Assistant Consultant - Project Controls

WSP in India; Dadri; Hybrid; INR 480,000 - 720,000; Full time

Job summary

WSP India is seeking a Data Analyst to support the PMO with Power BI, Python, and automation. The role focuses on building dashboards, integrating data sources, and delivering actionable insights to improve project delivery.

You will automate reports, validate data, and collaborate with global teams to drive efficient project controls and performance analysis.

Qualifications

• Bachelor's degree in computer science, information technology, data analytics, engineering or a related field.
• 1.5-3 years of experience in Data Analytics, BI, Reporting Automation, PMO Analytics, or Project Controls Analytics.
• Hands-on experience with Power BI dashboards and Power Platform.
• Strong analytical and problem-solving skills with attention to data accuracy and governance.

Responsibilities

• Support project setup, budgeting, forecasting, and performance tracking.
• Monitor project cost, schedule, resource, and revenue data for reporting and forecasts.
• Use EVM and financial systems to analyze project performance and KPIs.
• Collaborate with PMs to collect, validate, and analyze project data for reporting.
• Develop automated Power BI dashboards and reporting templates.
• Create interactive visuals and management reports from project data.
• Identify opportunities to standardize, digitize, and automate reporting processes.

Skills

Advanced Excel

Power BI

Power Platform

Python

VBA

Power Apps

Power Automate

Data extraction & analysis

SharePoint integration

Education

Bachelor's degree in Computer Science / IT / Data Analytics / Engineering

Tools

ERP systems

SharePoint

Job description

Job Description

WSP India is seeking a highly motivated Data Analyst with experience in Power BI, Power Platform, Python, and reporting automation to support the Project Management Office (PMO). The successful candidate will drive automation initiatives, develop business intelligence solutions, and transform project data into actionable insights that improve operational efficiency and project delivery.

Responsibilities

Project Cost Control

• Support project setup, budgeting, forecasting, and financial performance tracking activities using enterprise project management systems.
• Monitor project cost, schedule, resource, and revenue data and assist in generating project performance reports and forecasts
• Use Earned Value Management (EVM) and financial systems to analyze and report on project performance and KPIs.
• Collaborate with Project Managers and project teams to collect, validate, and analyze project data for reporting and decision-making.
• Support data quality reviews, compliance checks, and maintenance of project records and reporting documentation.
• Contribute to project performance analysis, including variance analysis, trend reporting, and earned value metrics.

Automation and Data Analysis

• Develop and automate Project Controls reports, dashboards, and existing reporting templates using Power BI, Python, VBA, and Power Platform to improve reporting efficiency and reduce manual effort.
• Develop and maintain Power BI dashboards integrated with SharePoint and project data sources to provide real‑time visibility into project cost, schedule, resource, and portfolio performance.
• Perform data extraction, cleansing, validation, analysis, and consolidation from ERP, financial, and project management systems.
• Develop Power Apps, automated workflows, and reporting solutions to streamline project controls processes, approvals, and data management activities.
• Create interactive visualizations, management reports, and presentation materials that convert complex project data into meaningful business insights.
• Identify opportunities to standardize, digitize, and automate existing Project Controls processes, reports, and templates.

Key Competencies / Skills:

• Hands on experience in Advanced Excel, including complex formulas, Power Query, data modeling, and reporting automation.
• Hands‑on experience with Power BI, including dashboard development, data modeling, DAX, and integration with SharePoint and enterprise data sources.
• 1.5 -3 years of working knowledge of Python, VBA, Power Apps, and Power Automate for report automation, workflow development, and process improvement.
• Experience in data extraction, transformation, validation, and analysis from ERP, financial, and project management systems.
• Strong analytical and problem‑solving skills with the ability to interpret complex datasets and present actionable insights.
• Understanding of reporting, forecasting, KPI tracking, and performance analysis concepts.
• Familiarity with project controls, project financials, cost management, or portfolio reporting is desirable
• Excellent attention to detail with a strong focus on data accuracy, governance, and quality assurance.
• Ability to create impactful dashboards, management reports, and executive presentations using Power BI, Excel, and PowerPoint.
• Strong communication, stakeholder management, and collaboration skills with the ability to work effectively across global teams.
• Self‑motivated, proactive, and eager to learn new technologies, business processes, and project management concepts.
• Flexible with work timings to support US‑based project teams and stakeholders.

Qualifications

• Bachelor's degree in computer science, Information Technology, Data Analytics, Engineering, or a related field.
• 1.5-3 years of experience in Data Analytics, Business Intelligence, Reporting Automation, PMO Analytics, or Project Controls Analytics.

BGV:

• Employment with WSP India is subject to the successful completion of a background verification ("BGV") check conducted by a third‑party agency appointed by WSP India.
• Candidates are advised to ensure that all information provided during the recruitment process — including documents uploaded — is accurate and complete, both to WSP India and its BGV partner.

About Us

WSP is one of the world’s leading professional services consulting firms. We are dedicated to our local communities and propelled by international brainpower. We are technical experts and strategic advisors including engineers, technicians, scientists, architects, planners, surveyors and environmental specialists, as well as other design, program and construction management professionals. We design lasting solutions in the Transportation & Infrastructure, Property & Buildings, Earth & Environment, Power & Energy, Resources and Industry sectors, as well as offering strategic advisory services. Our talented people around the globe engineer projects that will help societies grow for lifetimes to come.

With approximately 4,000 talented people across 3 locations (Noida, Bengaluru & Mumbai offices) in India and more than 73,000 globally, in 550 offices across 40 countries, we engineer projects that will help societies grow for lifetimes to come.

At "WSP" we draw on the diverse skills and capabilities of our employees globally to compete for the most exciting and complex projects across the world and bring the same level of expertise to our local communities. We are proud to be an international collective of innovative thinkers who work on the most complex problems. Unified under one strong brand, we use our local expertise, international reach and global scale to prepare our cities and environments for the future, connect communities and help societies thrive in built and natural ecosystems. True to our guiding principles, our business is built on four cornerstones: Our People, Our Clients, Our Operational Excellence and Our Expertise.

www.wsp.com

We are

• Passionate people doing purposeful and sustainable work that helps shape our communities and the future.
• A collaborative team that thrives on challenges and unconventional thinking.
• A network of experts channeling our curiosity into creating solutions for complex issues.

Inspired by diversity, driven by inclusion, we work with passion and purpose.

Working with Us

At WSP, you can access our global scale, contribute to landmark projects and connect with the brightest minds in your field to do the best work of your life. You can embrace your curiosity in a culture that celebrates new ideas and diverse perspectives. You can experience a world of opportunity and the chance to shape a career as unique as you.

Our Hybrid Working Module

With us, you can operate in a flexible, agile, yet structured work environment and follow a Hybrid Work Model.

• Maximize collaboration.
• Maintain product quality and cultural integrity.
• Balance community, collaboration, opportunity, productivity, and efficiency.

Health, Safety and Wellbeing

Our people are our greatest asset, and we prioritize a safe work environment. Health, safety, and wellbeing are integral to our culture, with each of us accountable for fostering a safe workplace through our “Making Health and Safety Personal” initiative. Our Zero Harm Vision drives us to reduce risks through innovative solutions, earning recognition for our global health and safety practices with the prestigious RoSPA Health and Safety Awards for six consecutive years.

Inclusivity and Diversity

WSP India is dedicated to fostering a sustainable and inclusive work environment where our greatest strength - Our People -feel valued, respected, and supported. We ensure an unbiased approach in hiring, promotion, and performance evaluation, regardless of age, gender identity, race, religion, sexual orientation, marital status, physical ability, education, social status, or cultural background.

Imagine a better future for you and a better future for us all.

Join our close-knit community of over 73,300 talented global professionals dedicated to making a positive impact. Together, we can make a difference in communities both near and far.

NOTICE TO THIRD PARTY AGENCIES:

WSP does not accept unsolicited resumes from recruiters, employment agencies, or other staffing services. Unsolicited resumes include any resume or hiring document sent to WSP in the absence of a signed Service Agreement where WSP has expressly requested recruitment/staffing services specific to the position at hand. Any unsolicited resumes, including those submitted to hiring managers or other business leaders, will become the property of WSP and WSP will have the right to hire that candidate without reservation – no fee or other compensation will be owed or paid to the recruiter, employment agency, or other staffing service.