Senior Technology Consultant, Power BI

Key Skills

Analytical and Problem solving, Effective communication skills, ETL frameworks, PowerBI, Python Programming, R Programming, SQL

Job Description

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.

By managing capital programs and projects as if they were our own, our project management business, and technical experts work with clients to strategize, plan, and implement projects that help them achieve their organization’s objectives. Our award-winning team has managed thousands of projects across all sectors — hospitals, airports, and entire university campuses; infrastructure like mass transit and water-treatment facilities; and energy and resource assignments, from mines to wind farms.

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.

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

Your 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 (e.g., REST)
• Experience with Middleware tools (e.g., Boomi, Power Automate)
• Previous leadership and management of teams

Education and Experience

• Bachelor’s degree in a relevant field (e.g., Data Science, Statistics, Computer Science, Engineering)
• Minimum 10 years’ experience in a similar role.
• Advanced degree in relevant field (e.g., Data Science, Statistics, Computer Science, Business Administration) is preferred
• 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.

Stantec is a place where the best and brightest come to build on each other’s talents, do exciting work, and make an impact on the world around us. Join us and redefine your personal best.

Additional Information

• Salary Range(s): Pay transparency laws require employers to provide the following information for positions that may be in the following jurisdiction(s):
• Location Description: Min/Max Pay Range for postings located in CO, HI, MD and IL
• Min Pay Range: $108,000
• Max Pay Range: $162,000
• Note: The final agreed upon compensation is based on individual education, qualifications, experience, and work location. At Stantec certain roles are bonus eligible.