Technology Consultant, Power BI Developer

Stantec

Power BI Developer working with data visualization and analytics for project management at Stantec. Collaborating with interdisciplinary teams to drive transformative project solutions and insights.

Posted 6/29/2026full-timeChicago • Illinois • 🇺🇸 United StatesJuniorMid-Level💰 $79,000 - $114,500 per yearWebsite

Tech Stack

Tools & technologies

ETLPythonSQL

About the role

Key responsibilities & impact

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

Requirements

What you’ll need

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.

Benefits

Comp & perks

Regular full-time and part-time employees have access to medical, dental, and vision plans
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
Paid family leave
Ten paid holidays in each calendar year
Accrue vacation between 10 and 20 days per year
Eligible for paid sick leave

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

Data AnalysisStatistical MethodsData CleaningData ValidationAPI ManagementETL ProcessesData WarehousingPython ProgrammingR ProgrammingSQL

Soft Skills

Analytical SkillsProblem-SolvingCommunicationCollaborationAttention to Detail