Stantec’s Enterprise Data & Analytics team is looking for a Data Consultant to support data-driven decision-making and contribute to business insights across the organization.
Key Responsibilities- Support data solution design and development from business requirement intake and assessment.
- Transform business data into actionable insights and support user acceptance testing (UAT).
- Collaborate with Corporate stakeholders throughout the development lifecycle and post‑production support.
- Gather and manage business requirements, capture acceptance criteria, and build user stories for testing.
- Analyze datasets to identify trends, patterns, and insights and translate findings into clear narratives.
- Develop and maintain dashboards, reports, and visualizations using Power BI, Oracle Data Visualizer, or similar platforms.
- Support data quality, integrity, and security following established governance practices.
- Contribute to a culture of continuous learning, data insights, and effective data storytelling.
- Excellent communication and presentation skills for technical and non‑technical audiences.
- Proficiency in translating business requirements into test‑driven user stories.
- Experience with source‑data profiling, proofs‑of‑concept, and data modeling.
- Strong analytical, organizational, time‑management, and problem‑solving abilities.
- Attention to detail and critical thinking.
- Ability to work independently and collaborate with cross‑functional teams.
- Familiarity with Agile development, Scrum, and source‑control tools (Git, Azure Dev Ops, Jira, Confluence).
- Bachelor’s degree in Computer Science, Statistics, Data Science, Commerce (Business Technology Management) or equivalent.
- 2+ years of experience in data analytics, business intelligence, or a similar role.
- Working knowledge of SQL, Power Query, DAX, Python, R, or related programming languages.
- Experience supporting data modeling and testing activities for data solutions.
- Experience in UAT workshops with partners and stakeholders.
- Exposure to ETL/ELT environments such as Azure Databricks is an asset.
- Experience with Power BI or Oracle Data Visualizer.
- Knowledge of source‑control and document‑control tools.
- Bonus: certification in Oracle, Microsoft or Azure platforms; experience with ERP systems (especially Oracle); finance, HR, or project data knowledge.
Locations Outside Lower Mainland‑BC & Ontario: CA $68,200.00 – $98,900.00 annually.
Locations in Lower Mainland‑BC, GTA & Ottawa, Ontario: CA $72,300.00 – $ annually.
Full‑time employees receive health, dental, vision plans, wellness programs, health‑care spending account, retirement savings plan, employee stock purchase program, tax‑free savings account, AD&D insurance, short‑ and long‑term disability plans, emergency travel benefits, tuition reimbursement, professional membership fee coverage, and paid time off. Temporary/casual employees receive retirement savings plan, employee stock purchase program, and tax‑free savings account.
Primary
Location:
Canada
• Ontario
• Waterloo
Other Locations:
Canada
• British Columbia
• Burnaby
Employee Status:
Regular
Schedule:
Full time
Report Date: 29/06/2026
To Search, View & Apply for jobs on this site that accept applications from your location or country, tap here to make a Search: