Senior Manager, Data Analytics & Automation-Databricks

KPMG LLP Canada; Toronto; On-site; CAD 85,000 - 115,000; Full time

Job summary

A leading consulting firm in Ontario is seeking a Senior Manager in Data, Analytics and Automation to support data-driven decision-making. The role involves developing data solutions, optimizing data pipelines, and collaborating across functions leveraging Databricks technology. Ideal candidates will have over 6 years of business intelligence experience, strong SQL skills, and familiarity with data pipeline development tools. The firm is committed to fostering an inclusive workplace where everyone can thrive.

Benefits

Competitive salary

Development opportunities

Inclusive workplace

Flexible working adjustments

Qualifications

• 6+ years of relevant business intelligence experience.
• 4+ years of experience on Databricks development with certifications.
• Good knowledge of SQL (window functions, subqueries, conditional tables, etc.).
• Ability to convey complex information to stakeholders.
• Experience in financial or insurance industries is a plus.

Responsibilities

• Support the design and implementation of Databricks data architecture.
• Develop and maintain data models, data warehouses, and data lakes.
• Collaborate with teams to identify business requirements and develop solutions.
• Optimize and tune Databricks performance.
• Implement data models and transformations for analytical needs.

Skills

Databricks Development

Business Intelligence

Data Pipeline Development

SQL

Relational and Dimensional Models

Education

University degree in computer science or related field

Tools

Databricks

Apache Airflow

Snowflake

GitHub Copilot

Azure

AWS

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 Manager 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.

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.
• 6+ years of relevant business intelligence experience.
• 4+ years of experience on Databricks development with Databricks certifications.
• 4+ 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

We provide the support you need to be at your best by empowering you with the necessary resources, tools, and development opportunities.

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.