When you care deeply about the work you do, it’s rewarding to see it through from concept to completion. We partner with clients to provide both program management and construction management to strategize, plan, and implement projects that drive organizations forward. From hospitals and airports to university campuses, mass transit systems, water treatment facilities, mines, and wind farms, we've successfully managed thousands of projects.
Joining our team, turning visionary ideas into reality, will shape your future—and the future of your community.
We are strategizing, planning, and implementing projects that help clients achieve their organization’s objectives. Join our award-winning program management team and bring transformational project solutions to life.
Your Opportunity
We are seeking a talented and detail-oriented Power BI Developer to join our dynamic and growing Programs and Construction Management (PMCM) team. The ideal candidate will be working closely with Controls Specialists and Controls Managers to collect, analyze, and interpret large datasets by developing dashboards and reports to help inform business decisions. In this role, you will also work closely with Controls Leadership to develop and implement standards for technology usage within the group and linking component subsystems to work together as a coherent unit for program management.
Your Key Responsibilities
- Develop and maintain comprehensive and visually appealing reports and dashboards.
- Collect and analyze large datasets to derive actionable insights.
- Use statistical methods to interpret data and generate useful business reports.
- Identify trends, patterns, and anomalies in data.
- Ensure data accuracy and integrity through validation and cleaning processes.
- Collaborate with the Controls team and other teams to resolve data-related issues.
- Assist with Business Process development regarding data gathering and analysis
Your Capabilities and Credentials
- Ability to work with large complex data models
- Experience with data visualization tools (e.g. Power BI is strongly preferred, but similar alternatives may be considered).
- Strong analytical and problem-solving skills.
- Excellent written/verbal communication and collaboration abilities.
- Attention to detail and a commitment to producing high-quality work.
- Ability to work independently and as part of a team.
- Ability to multi-task, manage time, organize, set priorities, and make timely decisions.
- Experience with large public sector programs in water or transportation
- Prior work in project controls
- Experience with API calls and management (e.g., REST)
- Experience with Middleware tools (e.g., Boomi, Power Automate)
- Previous leadership and management of team
- Proficient in data analysis tools and programming languages (e.g., SQL, Python, R) Familiarity with data warehousing and ETL processes.
Education and Experience
- Bachelor’s degree in a relevant field (e.g., Data Science, Statistics, Computer Science, Engineering)
- Minimum 2-5 years’ experience in a similar role.
- Strong Power BI (or similar) experience is required.
- Industry-specific knowledge and experience (e.g., Architecture, Engineering, Construction).
This description is not a comprehensive listing of activities, duties or responsibilities that may be required of the employee and other duties, responsibilities and activities may be assigned or may be changed at any time with or without notice.
About Stantec
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.
Skills Required
- Ability to work with large complex data models
- Strong Power BI experience
- Experience with data visualization tools
- Proficient in SQL
- Proficient in Python or R
- Familiarity with data warehousing and ETL processes
- Experience with API calls and management (e.g., REST)
- Experience with Middleware tools (e.g., Boomi, Power Automate)
- Prior work in project controls
- Experience with large public sector programs in water or transportation
- Previous leadership and management of team
- Bachelor's degree in Data Science, Statistics, Computer Science, Engineering or relevant field
- Minimum 2-5 years' experience in a similar role
- Strong analytical and problem-solving skills
- Excellent written/verbal communication and collaboration abilities
- Attention to detail and commitment to producing high-quality work
- Ability to work independently and as part of a team; multitask and manage time
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.
