Senior Project Controls Analyst

Stantec; Maharashtra; On-site; INR 900,000 - 1,500,000; Full time

Job summary

Stantec is seeking a Power Platform Specialist to design, develop, and maintain low-code solutions for project controls and PMO workflows in Pune, India. You will build Power Apps, automate processes with Power Automate, and create Power BI dashboards to drive data-driven decisions across programs and portfolios.

The role emphasizes governance, data quality, and collaboration with PMO teams, with a focus on scalable, enterprise-grade Power Platform solutions within a client-focused engineering

Qualifications

• 3–6 years of experience in Power Platform development, business automation, or analytics roles.
• Experience supporting multiple projects or stakeholders in a matrix environment.
• Preferred qualifications: Microsoft Power Platform certifications (PL 100, PL 200, PL 300, or equivalent).
• Exposure to governance, security, and environment management within Power Platform.

Responsibilities

• Design and develop Power Apps (Canvas and Model Driven) to support project management use cases such as registers, logs, approvals, and trackers.
• Build and maintain Power Automate flows to automate routine PMO and project controls processes (e.g., reporting, notifications, approvals).
• Manage integrations between SharePoint, Excel, Teams, Outlook, and Dataverse to ensure seamless data flow across tools.
• Develop and enhance Power BI dashboards for project performance, cost, schedule, utilization, and risk reporting.
• Translate project controls data into actionable insights for Project Managers and leadership.
• Replace manual, Excel heavy reporting with standardized, automated dashboards, aligning with current PM practices.
• Maintain documentation, user guides, and support materials for developed applications and dashboards.

Skills

Power Apps

Power Automate

Power BI

SharePoint

Dataverse

Data modeling

Data analytics

Tools

Microsoft 365

Power Platform certifications

Job description

Stantec is a global leader in sustainable engineering, architecture, and environmental consulting. The diverse perspectives of our partners and interested parties drive us to think beyond what’s previously been done on critical issues like climate change, digital transformation, and future-proofing our cities and infrastructure. We innovate at the intersection of community, creativity, and client relationships to advance communities everywhere, so that together we can redefine what’s possible. The Stantec community unites approximately 32,000 employees working in over 450 locations across 6 continents.

Primary Purpose of Job

The Power Platform Specialist will support the Project Management team by designing, developing, and maintaining low code solutions using Microsoft Power Platform (Power BI, Power Apps, Power Automate, and SharePoint). The role focuses on digitizing project controls, automating PMO workflows, improving reporting quality, and enabling data driven decision making across projects, programs, and portfolios.

Power Platform Development & Automation

• Design and develop Power Apps (Canvas and Model Driven) to support project management use cases such as registers, logs, approvals, and trackers.
• Build and maintain Power Automate flows to automate routine PMO and project controls processes (e.g., reporting, notifications, approvals).
• Manage integrations between SharePoint, Excel, Teams, Outlook, and Dataverse to ensure seamless data flow across tools.

Project Reporting & Analytics

• Develop and enhance Power BI dashboards for project performance, cost, schedule, utilization, and risk reporting.
• Translate project controls data into actionable insights for Project Managers and leadership.
• Replace manual, Excel heavy reporting with standardized, automated dashboards, aligning with current PM practices.

PMO & Project Controls Enablement

• Work closely with Project Controls Specialists to understand operational pain points and convert them into digital solutions.
• Support governance, data quality, and version control for Power Platform solutions used across multiple projects.
• Maintain documentation, user guides, and support materials for developed applications and dashboards.

Continuous Improvement & Innovation

• Identify opportunities to optimize project workflows using low code/no code solutions.
• Stay current with Microsoft Power Platform features, security, and best practices, ensuring solutions align with enterprise standards.
• Support adoption and basic training of end users (PMs, analysts, coordinators).

Technical Skills

• Strong hands on experience with:
• Power Apps
• Power Automate
• Power BI
• SharePoint / Dataverse
• Experience integrating Power Platform with Microsoft 365 tools.
• Solid understanding of data modeling, relationships, and performance optimization in Power BI.

Project Management Domain Knowledge

• Familiarity with project management or project controls concepts (cost, schedule, utilization, risks, KPIs).
• Experience working with PMO, engineering, infrastructure, or consulting project environments is highly desirable.

Professional Experience

• 3–6 years of experience in Power Platform development, business automation, or analytics roles.
• Experience supporting multiple projects or stakeholders in a matrix environment.
• Preferred Qualifications
• Microsoft Power Platform certifications (PL 100, PL 200, PL 300, or equivalent).
• Experience in infrastructure, engineering, or professional services organizations.
• Exposure to governance, security, and environment management within Power Platform.
• Key Competencies
• Strong analytical and problem solving mindset.
• Ability to translate business needs into practical digital solutions.
• Clear communication skills and ability to work with non technical stakeholders.
• High attention to detail, documentation, and data accuracy.

Primary Location: India | Pune

Organization: 3880 Water-IN Technical Services-Pune IN

Employee Status: Regular

Management Level: Individual contributor

Business Justification: New Position

Travel: No

Schedule: Full time