University degree in computer engineering, computer science, mathematics, data science, or related discipline.
4+ years of experience in Data Engineering, Analytics Engineering, or Business Intelligence.
2+ years of hands-on experience with Microsoft Fabric or Azure Data Engineering services.
Strong SQL proficiency along with knowledge of data modeling and warehousing.
Proficiency in Python for data processing and automation.
Experience with Spark-based processing and notebook development.
Knowledge of data governance within Microsoft ecosystems.
Responsibilities
Partner with clients to understand business goals and translate them into technical designs.
Work with teams to develop end-to-end data strategies involving ingestion and analytics.
Contribute to the design of repeatable and scalable analytics solutions using Microsoft Fabric.
Lead the delivery of various data platform components including Fabric Lakehouse.
Design and implement data ingestion and transformation pipelines using Fabric tools.
Build scalable data processing pipelines utilizing Spark and real-time ingestion patterns.
Establish governance practices across Fabric with Microsoft Purview.
Benefits
Comprehensive and competitive Total Rewards program.
Opportunities for professional development and certifications support.
Access to a collaborative and innovative work environment.
Full Job Description
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 Information
The 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.
