Senior Technology Support Consultant, Power BI
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 Senior Technology Support Consultant 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
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.
Develop and maintain comprehensive and visually appealing reports and dashboards.
Communicate findings to non-technical stakeholders effectively.
Design, Implement, and Integrate technology solutions
Mentor and develop junior staff on development of reports
Assist with Business Process development regarding data gathering and analysis
QualificationsYour Capabilities and Credentials
Proficient in data analysis tools and programming languages (e.g., SQL, Python, R).
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).
Familiarity with data warehousing and ETL processes.
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, and set priorities and make timely decisions Preferred Qualifications:
Experience with large public sector programs in water or transportation
Prior work in project controls
Experience with API calls and management is preferred
Experience with Middleware tools (e.g., Boomi, Power Automate) is preferred
Previous leadership and management of teams is preferred
Education and Experience
Bachelor’s degree in a relevant field.
Minimum 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) is preferred.
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.
#Program&ProjectControlsAbout Company
Pay Transparency: In compliance with pay transparency laws, pay ranges are provided for positions in locations where required. Please note, the final agreed upon compensation is based on individual education, qualifications, experience, and work location. At Stantec certain roles are bonus eligible. Actual compensation for part-time roles will be pro-rated based on the agreed number of working hours per week.
Benefits Summary: Regular full-time and part-time employees (working at least 20 hours per week) have access to medical, dental, and vision plans, a wellness program, health saving accounts, flexible spending accounts, 401(k) plan, employee stock purchase program, life and accidental death & dismemberment (AD&D) insurance, short-term/long-term disability plans, emergency travel benefits, tuition reimbursement, professional membership fee coverage and paid family leave. Regular full-time and part-time employees will receive ten paid holidays in each calendar year. In addition, employees will be eligible to accrue vacation between 10 and 20 days per year and eligible for paid sick leave (and if more generous, in accordance with state and local law).
Temporary/casual employees have access to 401(k) plans, employee stock purchase program, and paid leave, in accordance with state and local law.
The benefits information listed above may not apply to union positions because benefits for such positions are governed by applicable collective bargaining agreements
Apply Now
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 Senior Technology Support Consultant 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
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.
Develop and maintain comprehensive and visually appealing reports and dashboards.
Communicate findings to non-technical stakeholders effectively.
Design, Implement, and Integrate technology solutions
Mentor and develop junior staff on development of reports
Assist with Business Process development regarding data gathering and analysis
QualificationsYour Capabilities and Credentials
Proficient in data analysis tools and programming languages (e.g., SQL, Python, R).
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).
Familiarity with data warehousing and ETL processes.
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, and set priorities and make timely decisions Preferred Qualifications:
Experience with large public sector programs in water or transportation
Prior work in project controls
Experience with API calls and management is preferred
Experience with Middleware tools (e.g., Boomi, Power Automate) is preferred
Previous leadership and management of teams is preferred
Education and Experience
Bachelor’s degree in a relevant field.
Minimum 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) is preferred.
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.
#Program&ProjectControlsAbout Company
Pay Transparency: In compliance with pay transparency laws, pay ranges are provided for positions in locations where required. Please note, the final agreed upon compensation is based on individual education, qualifications, experience, and work location. At Stantec certain roles are bonus eligible. Actual compensation for part-time roles will be pro-rated based on the agreed number of working hours per week.
Benefits Summary: Regular full-time and part-time employees (working at least 20 hours per week) have access to medical, dental, and vision plans, a wellness program, health saving accounts, flexible spending accounts, 401(k) plan, employee stock purchase program, life and accidental death & dismemberment (AD&D) insurance, short-term/long-term disability plans, emergency travel benefits, tuition reimbursement, professional membership fee coverage and paid family leave. Regular full-time and part-time employees will receive ten paid holidays in each calendar year. In addition, employees will be eligible to accrue vacation between 10 and 20 days per year and eligible for paid sick leave (and if more generous, in accordance with state and local law).
Temporary/casual employees have access to 401(k) plans, employee stock purchase program, and paid leave, in accordance with state and local law.
The benefits information listed above may not apply to union positions because benefits for such positions are governed by applicable collective bargaining agreements
Apply Now