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 the 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, automation, and analytics workflows.
- Hands-on experience with Spark-based data processing and notebook-driven development.
- Experience with Fabric Lakehouse, Data Warehouse (SQL Endpoint), OneLake, and semantic modeling.
- Experience supporting data platform modernization and Azure-based migration initiatives.
- Experience applying CI/CD practices to data and analytics solutions.
- Strong understanding of data governance, security, and access control within Microsoft ecosystems.
- Experience collaborating with cross-functional teams to solve complex data challenges.
- Familiarity with Power BI and downstream analytics enablement.
Certifications (Preferred)- Microsoft Certified: Fabric Analytics Engineer Associate
- Microsoft Certified: Azure Data Engineer Associate
- Power BI Data Analyst certification
- Other relevant Microsoft Azure or data engineering certifications
KPMG Ontario Region Pay Range InformationThe expected base salary range for this position is $77,000 to $102,000 and may be eligible for bonus awards. The determination of an applicant's base salary within this range is based on the individual's location, skills & competencies, and unique qualifications. In addition, KPMG offers a comprehensive and competitive Total Rewards program.
KPMG BC Region Pay Range Information The expected base salary range for this position is $73,000 to $100,000 and may be eligible for bonus awards. The determination of an applicant's base salary within this range is based on the individual's location, skills & competencies, and unique qualifications. In addition, KPMG offers a comprehensive and competitive Total Rewards program.
