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

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in data analysis, visualization, and reporting, with proficiency in tools like Power BI and programming languages such as SQL, Python, and R. Strong analytical skills combined with effective communication and collaboration abilities support high-quality data-driven decision-making.

Highest-signal resume keywords

Data VisualizationData AnalysisSQL ProgrammingPower BIProject Controls

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

Data AnalysisStatistical MethodsData CleaningData ValidationAPI ManagementETL ProcessesData WarehousingPython ProgrammingR ProgrammingSQL

Soft Skills

Analytical SkillsProblem-SolvingCommunicationCollaborationAttention to Detail

Tools & Technologies

Power BIBoomiPower AutomateMiddleware ToolsData Visualization Tools

Industry Keywords

Public Sector ProgramsWaterTransportationData ModelsBusiness Process Development

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