Senior Consultant, Data Analytics & Automation-Databricks

KPMG LLP Canada; Toronto; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading consulting firm in Toronto is seeking a Senior Consultant in Data, Analytics and Automation. You will support the design and implementation of data architecture with a focus on Databricks and drive data-driven decision-making. Responsibilities include developing scalable data models and pipelines, collaborating with cross-functional teams, and optimizing data solutions. The ideal candidate will have a university degree and 2+ years of relevant experience in business intelligence and data management.

Benefits

Inclusive and supportive workplace

Opportunities for training and development

Qualifications

• 2+ years of experience developing with Databricks.
• Good knowledge of SQL, including window functions and subqueries.
• Experience in business intelligence in the financial or insurance sector is a plus.

Responsibilities

• Support the design and implementation of Databricks data architecture.
• Develop and maintain data models, data warehouses, and data lakes.
• Design, build, and test end to end data pipelines.
• Optimize data pipelines for performance and scalability.

Skills

Databricks development

SQL

Data modeling

Data pipeline development

Education

University degree in relevant field

Tools

Databricks

Azure

AWS

Airflow

Snowflake

Job description

Overview

At KPMG, you’ll join a team of diverse and dedicated problem solvers, connected by a common cause: turning insight into opportunity for clients and communities around the world.

KPMG’s Management Consulting practice helps organizations leverage change. The data intelligence and engineering team helps organizations to utilize data by supporting data-informed decision-making with the development and implementation of advanced solutions that fully use structured and unstructured data, in complex technical environment.

We help organizations to become data driven! Will you collaborate with us?

As a Senior Consultant in Data, Analytics and Automation, you will be a part of our Technology Consulting (Data, Analytics and Automation) practice within KPMG. This is a worldwide network of professionals who collaborate on a daily basis to create value from data. Enterprise Data Management integrates and is the connecting link with other data focused advisory services including Business Intelligence, Advanced Analytics, Digital Transformation, Enterprise Solutions and Data Security.

We collaborate across service offerings on data driven solutions. And that is why Forrester Research has recently recognized KPMG as one of the most prominent advisory firms in Data & Analytics!

The successful candidate will take part in various business intelligence and data engineering mandates using Databricks technology, which could involve assessing current practices, as well as developing a business intelligence and data engineering strategy, roadmaps, dashboards and performance indicators, devising and validating data models, and analyzing data to support timely decision-making, etc.

This role is for a Databricks Data Specialist with strong experience in design/data modeling/development & performance tuning.

What you will do

• Support the design and implementation of Databricks data architecture, ensuring scalability, security, and performance.
• Develop and maintain data models, data warehouses, and data lakes on Databricks.
• Collaborate with cross-functional teams to identify business requirements and develop data solutions.
• Design, build and test end to end data pipeline including data ingestion (streaming, events, and batch), data integration, data curation.
• Leverage automation and intelligent code‑assistance tools to programmatically generate and evolve data models, transformation logic, and pipeline components, with strong validation and review practices.
• Design, develop, and deploy scalable data pipelines and ETL processes on cloud-based infrastructure using Azure, AWS, Databricks, DBT, Airflow, Cosmos DB, and accelerate using intelligent code‑assistance tools.
• Define and implement automation of jobs and testing.
• Optimize data pipelines to support workloads and use cases.
• Support mission critical applications and near real time data needs from the data platform.
• Address data issues, environment issues, performing impact analysis, root cause analysis, corrective, adaptive and perfective maintenance.
• Implement data models, transformations, and schema designs to support analytical and reporting needs, and accelerate using intelligent code‑assistance tools.
• Optimize and tune Databricks performance, including query optimization, resource management, and scaling strategies.
• Present our Databricks service offerings and develop new service offerings on the platform.
• Grow the expertise of our regional Databricks CoE with training and certification plans.

What you bring to the role

• University degree in computer science, business intelligence, information architecture, information science, business administration or another related field.
• 2+ years of relevant business intelligence experience.
• 2+ years of experience on Databricks development with Databricks certifications.
• 2+ years of experience using intelligent code‑assistance tools (e.g., GitHub Copilot, OpenAI, Databricks Assistant) to accelerate data model and pipeline development, with appropriate validation and review.
• Experience in developing and using relational and dimensional models.
• Good knowledge of SQL (window functions, subqueries, conditional tables, etc.)
• Strong ability to convey complex information to different organizational levels and stakeholders with different levels of business intelligence maturity.
• Knowledge of data pipeline development tools (e.g., Apache Airflow, Luigi, dbt, stitch, etc.) considered an asset.
• Knowledge of programming languages in a data pipeline development context (e.g., Java, C#, Python) considered an asset.
• Experience in Snowflake considered an asset.
• Professional experience in the financial or insurance industry, considered an asset.
• Knowledge of cloud computing suites (AWS, Azure, GCP) considered an asset.
• Snowflake certifications considered an asset.

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

Our Values, The KPMG Way

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 1-888-466-4778.