1. 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:
o Power Apps
o Power Automate
o Power BI
o 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.
3. 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.
4. 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.
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.
Skills Required
- Strong hands on experience with Power Apps
- Strong hands on experience with Power Automate
- Strong hands on experience with Power BI
- Strong hands on experience with SharePoint / Dataverse
- 3-6 years of experience in Power Platform development, business automation, or analytics roles
What We Do
We're active members of the communities we serve. That's why at Stantec, we always design with community in mind. The Stantec community unites approximately 22,000 employees working in over 350 locations across six continents. We collaborate across disciplines and industries to bring buildings, energy and resource, environmental, and infrastructure projects to life. Our work—engineering, architecture, interior design, landscape architecture, surveying, environmental sciences, project management, and project economics, from initial project concept and planning through design, construction, and commissioning—begins at the intersection of community, creativity, and client relationships. Our local strength, knowledge, and relationships, coupled with our world-class expertise, have allowed us to go anywhere to meet our clients' needs in more creative and personalized ways. With a long-term commitment to the people and places we serve, Stantec has the unique ability to connect to projects on a personal level and advance the quality of life in communities across the globe.
.jpg)
