Senior Consultant, Azure Data Engineer

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.

KPMG Ignition is our innovation advisory offering support to various clients’ in exploring the art of the possible and build leading-edge solutions. We utilize exponential technologies, human-centered thinking, and business model innovations to unpack core business challenges and help clients seize opportunities in an era of rapid and disruptive change.

We are looking for a skilled and innovative Senior Consultant ,Azure Data Engineer with 3 to 4 years of hands-on experience in designing, implementing, and optimizing data solutions in Azure environments. The selected candidate will play a crucial role in leveraging advanced Azure data services, SQL expertise, and AI tools to deliver robust data-driven solutions that meet our clients' evolving business needs.

• Design, develop, and optimize ETL/ELT pipelines using Azure Data Factory to manage complex data workflows
• Build and maintain data solutions with Azure Synapse Analytics for big data analytics and reporting
• Develop scalable data processing frameworks using Databricks and integrate them into Azure-based data pipelines
• Implement and manage Azure Cosmos DB for NoSQL and globally distributed data solutions
• Harness the power of Microsoft Fabric for unified compute and storage capabilities
• Utilize Generative AI toolsets, such as Azure OpenAI Services and Azure AI Search, to deliver innovative AI-driven solutions
• Optimize SQL queries and configurations for performance and scalability in large datasets
• Collaborate with cross-functional teams, including business analysts to deliver end-to-end data solutions
• Stay current with new Azure and AI advancements to continuously enhance solutions and services

• 3 to 4 years of professional experience in data engineering with significant exposure to Azure data tools.
• Proven expertise in SQL, including query writing, optimization, and database management.
• Hands-on experience with the following Azure tools: Azure Data Factory, Azure Synapse Analytics, Databricks, Azure Cosmos DB, Microsoft Fabric 
• Familiarity with AI and Gen AI toolsets, such as Azure OpenAI and Azure AI Search 
• Strong understanding of data modeling, ETL/ELT processes, and data pipeline best practices
• Working knowledge of data governance and data security standards in cloud environments
• Excellent problem-solving skills and the ability to work autonomously or as part of a team
• Certification in Azure Data Engineer Associate or Azure AI Engineer Associate is an asset but not required

KPMG Ontario Region Pay Range Information

The expected base salary range for this position is $55,000 to $82,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. 

Providing you with the support you need to be at your best

Integrity , we do what is right |  Excellence , we never stop learning and improving |  Courage , we think and act boldly | Together , we respect each other and draw strength from our differences |  For Better , we do what matters

KPMG in Canada is a proud equal opportunities employer and we are committed to creating a respectful, inclusive and barrier-free workplace that allows all of our people to reach their full potential. A diverse workforce is key to our success and we believe in bringing your whole self to work. We welcome all qualified candidates to apply and hope you will choose KPMG in Canada as your employer of choice.

Adjustments and accommodations throughout the recruitment process

At KPMG, we are committed to fostering an inclusive recruitment process where all candidates can be themselves and excel. We aim to provide a positive experience and are prepared to offer adjustments or accommodations to help you perform at your best. Adjustments (informal requests), such as extra preparation time or the option for micro breaks during interviews, and accommodations (formal requests), such as accessible communication supports or technology aids, are tailored to individual needs and role requirements. You will have an opportunity to request an adjustment or accommodation at any point throughout the recruitment process. If you require support, please contact KPMG’s Employee Relations Service team by calling View phone number on careers.kpmg.ca.

AI Usage

We embrace the use of artificial intelligence (AI) to enhance the candidate experience and streamline our recruitment processes. AI tools may help with organizing applications or surfacing relevant qualifications. However, no hiring decisions are made using AI. Every hiring decision is made by our hiring managers and recruitment professionals, who are equipped with training that empowers them to use these tools responsibly. AI technologies used in our recruitment process undergo detailed risk assessments, including security and privacy requirements, that align with KPMG’s Trusted AI framework.

We believe technology should empower human judgment, not replace it. It’s one of the many ways we’re delivering on our vision of being a technology-first, people-driven firm.