Senior Consultant, Microsoft Fabric Data Engineer, Data & AI- job post KPMG

Full job description
Overview:
At KPMG in Canada, our people bring their unique perspectives to Canada’s most important challenges. Here, you can build momentum that reaches beyond our business, develop skills for the future, and take ownership of your career with support at every stage. Join a firm where your career can make a difference.

Are you a talented leader with a proven track record for motivating teams and delivering exceptional client service?

Our team is looking for a Data Engineer with deep hands-on expertise in Microsoft Fabric and strong consulting capabilities. This role will support and lead data platform modernization initiatives, helping clients migrate from legacy and on‑premise environments to scalable, secure, and unified analytics platforms leveraging Microsoft Fabric, OneLake, and Azure-native services.
What you will do:
Partner with clients to understand business goals, gather requirements, and translate them into actionable technical designs and delivery plans using Microsoft Fabric.
Work with engagement teams to translate business and analytics requirements into end‑to‑end data strategies, including ingestion, transformation, semantic modeling, and analytics enablement.
Contribute to solution architecture design for repeatable, scalable, and cost‑optimized analytics platforms using Microsoft Fabric components.
Lead delivery of modern data platforms leveraging Fabric Lakehouse, Data Warehouse, Data Engineering, and Real-Time Analytics workloads.
Design and implement data ingestion and transformation pipelines using Fabric Data Factory, notebooks, and Spark.
Implement medallion architecture patterns (Bronze, Silver, Gold) using Fabric Lakehouse and OneLake.
Develop scalable batch and streaming pipelines using Spark, Eventstreams, and real-time ingestion patterns.
Build and optimize semantic models for downstream analytics and reporting in Power BI.
Apply CI/CD and engineering best practices including version control, automated deployment, testing, and release management for Fabric workloads.
Establish and operationalize governance across Fabric using Microsoft Purview, role-based access control, and data lineage.
Support testing, performance tuning, and production releases across Fabric workloads.
Proactively contribute to creation of presentation materials and client-facing documentation related to data and analytics initiatives.
Provide technical leadership and mentorship to junior team members.
What you bring to this role:
University degree in computer engineering, computer science, mathematics, data science, or related disciplines.
4+ years of professional 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 proficiency in SQL and solid understanding of modern data modeling principles and data warehousing concepts.
Proficiency in Python (or similar languages) for data processing