Senior Consultant, Microsoft Fabric Data Engineer, Data & AI

Hybrid (Multiple Locations)
October 28, 2026
Salary
$
77000
 - 
$
102000
Job Type
Full Time
Years of Experience
4
 - 
9
 years
Industry
Accounting

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

Toast's Process

1. Application Review

Submit your application, including your resume and cover letter, through our online portal. Our team will carefully review your qualifications and experiences. We take pride in responding promptly, so if your application aligns with our current opportunities, you’ll hear back from us with next steps. Your journey with Toast begins here, and we’re excited to see what you bring to the table!

2. Vetting Call

If your application is successful, we’ll schedule a vetting call with a member of the Toast team. This 30-45 minute informal conversation is designed for us to get to know you better and assess your skills. Be prepared to discuss your past projects, the challenges you’ve tackled, and the impact you’ve made. This is your chance to shine and show us why you’re a great fit for the roles we offer.

3. Profile Creation

Once you’ve impressed us in the vetting call, we’ll create an unbiased profile that highlights your experience while minimizing common biases. Instead, we focus on your skills, industry experience, and the impact you’ve made. This way, your profile reflects your true potential and accomplishments.

4. Client Submission

After crafting your unbiased profile, we submit it to our trusted clients. We work closely with these clients to ensure they understand the value you bring. Throughout their interview process, we remain by your side, providing support and guidance. Our goal is to help you navigate the hiring process smoothly and confidently, ensuring you have the best chance to secure a role that fits your skills and aspirations.