Consultant, Data Engineering

Avanade Inc.; Toronto; On-site; CAD 110,000 - 150,000; Full time

Job summary

Avanade Inc. in Toronto, Ontario seeks a data engineering professional to partner with client stakeholders, translate complex needs into scalable data solutions, and lead problem-solving across ambiguous environments.

You will design, build, test, and support data pipelines, lakehouse solutions, and curated data products using Microsoft Fabric and Azure Databricks, while developing data transformations with Python, PySpark, and SQL.

Qualifications

• Partner with client stakeholders to understand data priorities and translate complex needs into actionable data solutions.
• Lead problem-solving activities across ambiguous environments, evaluating options, risks, dependencies, and trade-offs.
• Design, build, test, and support scalable data pipelines, lakehouse solutions, and curated data products using Microsoft Fabric and Azure Databricks.

Responsibilities

• Develop reliable data transformations using Python, PySpark, and SQL.
• Facilitate discovery sessions, technical workshops, backlog refinement, and stakeholder updates.
• Manage stakeholder expectations through clear communication and transparent delivery reporting.
• Apply engineering practices for data quality, observability, security, governance, and performance optimization.

Skills

Stakeholder management

Complex problem solving

Mentoring

Data collaboration

AI integration

Tools

Microsoft Fabric

Azure Databricks

Python

PySpark

SQL

Job description

What You'll Do

• Partner with client stakeholders to understand business priorities, uncover root causes, define requirements, and translate complex needs into actionable data solutions.
• Lead problem-solving activities across ambiguous and complex environments, evaluating options, risks, dependencies, and trade-offs.
• Design, build, test, and support scalable data pipelines, lakehouse solutions, and curated data products using Microsoft Fabric and Azure Databricks.
• Develop reliable data transformations and engineering components using Python, PySpark, and SQL.
• Facilitate discovery sessions, technical workshops, backlog refinement, solution walkthroughs, and stakeholder updates.
• Manage stakeholder expectations through clear communication, proactive issue management, and transparent delivery reporting.
• Apply sound engineering practices for data quality, observability, security, governance, performance optimization, and operational support.
• Contribute to architecture decisions, estimates, delivery plans, technical documentation, and client presentations.
• Collaborate with architects, analysts, data scientists, AI engineers, and delivery teams across onshore and offshore environments.
• Support and mentor junior team members through technical guidance, reviews, and knowledge sharing.
• Explore opportunities to integrate AI engineering capabilities into data solutions, including Microsoft Foundry and Microsoft Copilot Studio.

Equal Employment Opportunity Statement

All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, veteran status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status or any other basis as protected by federal, state, or local law.

Job candidates will not be obligated to disclose sealed or expunged records of conviction or arrest as part of the hiring process.

Avanade is committed to providing veteran employment opportunities to our service men and women.