Senior Consultant/Manager, Data, Analytics and Automation

KPMG LLP Canada; Montreal; On-site; CAD 70,000 - 90,000; Full time

Job summary

Join a leading consulting firm as a Business Intelligence Consultant, where you'll leverage your data engineering skills to help clients make informed decisions. Collaborate with diverse teams, develop data strategies, and deliver high-quality solutions that meet client expectations. Ideal candidates will have a strong background in data analysis, SQL, and experience with BI tools like PowerBI and Tableau.

Qualifications

• 3-7 years of relevant business intelligence experience.
• Experience in developing and using relational and dimensional models.

Responsibilities

• Developing and implementing data models aligned with clients’ needs.
• Assisting clients in implementing recommendations and managing projects.

Skills

SQL

Data Analysis

Communication

Education

University degree in computer science

Business administration

Tools

PowerBI

Tableau

Looker

Apache Airflow

Python

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 business intelligence and engineering team helps organizations to utilize data by supporting data-informed decision-making with the development and implementation of advanced technological solutions that fully use structured and unstructured data, even in a big data environment.

What you will do

The successful candidate will take part in various business intelligence and data engineering mandates, 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.

The successful candidate will have a range of responsibilities, including:

• Taking part in client meetings and supporting the team in developing presentation materials in relation to project kick-off meetings, needs gathering and analysis, project management, presentation of results, etc.
• Developing and implementing dimensional and tabular data models aligned with clients’ business intelligence needs.
• Advising on the implementation of indicators aligned with organizational or sectoral objectives to support performance management and decision-making.
• Playing a role in developing and implementing roadmaps, dashboards, performance indicators, data modelling, business intelligence and data engineering systems architectures, data analyses supporting decision-making, etc.
• Assisting and supporting clients in implementing recommendations and managing projects in accordance with deadlines, budgets and client expectations.
• Working on multiple client engagements of varying scope and complexity at the same time.
• Delivering high-quality work on time that meets the Firm’s quality standards and client expectations.
• Working with cross-functional teams with people of diverse backgrounds and skill sets.

What you bring to the role

• University degree in computer science, business intelligence, information architecture, information science, business administration or another related field.
• 3-7 years of relevant business intelligence experience.
• Professional experience in the financial or insurance industry, considered an asset.
• Experience in developing and using relational and dimensional models.
• Good knowledge of SQL (window functions, subqueries, conditional tables, etc.)
• Experience developing dashboards and performance indicators using PowerBI, Tableau, Looker, 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.
• Familiarity with certain cloud computing suites (AWS, Azure, GCP) 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 the opportunity to request an adjustment or accommodation at any point throughout the recruitment process. 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.