Job Description

Toast is recruiting on behalf of one of the world’s largest professional services firms, a global leader in audit, tax, and advisory with more than 10,000 people across Canada. Their Data and AI practice helps some of the country’s most recognized organizations move off legacy and on-premise systems and onto modern, secure, unified analytics platforms. They are hiring a Senior Consultant, Microsoft Fabric Data Engineer, to lead hands-on platform modernization work for clients while mentoring junior team members. This is a full-time role based in Toronto, Vancouver, or Calgary.

Responsibilities

Partner with clients to understand business goals, gather requirements, and turn them into technical designs and delivery plans using Microsoft Fabric
Translate business and analytics needs into end-to-end data strategies covering ingestion, transformation, semantic modeling, and analytics enablement
Contribute to solution architecture for repeatable, scalable, and cost-optimized analytics platforms
Lead delivery of modern data platforms using Fabric Lakehouse, Data Warehouse, Data Engineering, and Real-Time Analytics workloads
Design and build ingestion and transformation pipelines using Fabric Data Factory, notebooks, and Spark
Implement medallion architecture patterns (Bronze, Silver, Gold) with Fabric Lakehouse and OneLake
Develop batch and streaming pipelines using Spark, Eventstreams, and real-time ingestion patterns
Build and optimize semantic models for analytics and reporting in Power BI
Apply CI/CD and engineering best practices, including version control, automated deployment, testing, and release management
Set up and operationalize governance using Microsoft Purview, role-based access control, and data lineage
Support testing, performance tuning, and production releases
Create presentation materials and client-facing documentation for data and analytics initiatives
Provide technical leadership and mentorship to junior team members

Requirements

University degree in computer engineering, computer science, mathematics, data science, or a related field
4+ years of experience in data engineering, analytics engineering, business intelligence, or a related field
2+ years of hands-on experience with Microsoft Fabric or Azure Synapse / Azure data engineering services
Strong SQL skills and a solid grasp of modern data modeling and data warehousing concepts
Proficiency in Python or a similar language for data processing, automation, and analytics workflows
Hands-on experience with Spark-based processing and notebook-driven development
Experience with Fabric Lakehouse, Data Warehouse (SQL Endpoint), OneLake, and semantic modeling
Experience supporting data platform modernization and Azure migration initiatives
Experience applying CI/CD practices to data and analytics solutions
Strong understanding of data governance, security, and access control within Microsoft environments
Experience working with cross-functional teams to solve complex data challenges
Familiarity with Power BI and downstream analytics enablement
Holding the Microsoft Certified: Fabric Analytics Engineer Associate or Azure Data Engineer Associate certification would be a plus
A Power BI Data Analyst certification or other relevant Azure or data engineering certifications is considered an asset

Benefits

Compensation listed on the posting is for base salary. Total compensation includes base salary + annual bonuses.
A comprehensive total rewards program covering health, wellness, and financial benefits
Lead modernization projects that move major Canadian organizations off legacy systems and onto platforms their teams will rely on for years
Build hands-on depth in Microsoft Fabric, one of the fastest-growing data platforms, while earning certifications and recognized expertise
Shape how clients govern and secure their data, with your architecture decisions directly influencing how decisions get made across their business
Grow your leadership skills by mentoring junior engineers within a large, well-supported Data and AI practice

Senior Consultant, Microsoft Fabric Data Engineer, Data & AI