Data Consultant

KPMG Canada

Posted 14 days ago

Full Time

Toronto, Ontario

In Person

Smart Summary

Responsibilities

The Data Consultant will support audit engagement teams by performing data extraction, transformation, and load tasks using various analytical tools. They will also communicate technical project implications to stakeholders and assist in developing innovative data-driven solutions for audit planning.

Qualifications

You have a Bachelor's or Master's degree in a relevant IT field and proficiency with data analytics tools such as SQL, Alteryx, and Power BI. You also possess strong communication and organizational skills, with the ability to manage diverse responsibilities and solve problems creatively.

Must Have Skills for ATS

Alteryx

SQL

Databricks

Power BI

Microsoft PowerApps

Microsoft PowerAutomate

Excel

PowerQuery

VBA

Python

Job Description

Overview

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. 

The Audit Technologies Group is a part of the national audit center, audit support team. The Audit Technologies Group is tasked with implementing new technologies in the audit practice and providing digital and data & analytics services to our clients. The group works as part of a multi-disciplinary team providing and supporting KPMG proprietary and third-party data & analytics solutions to our teams. 

Data consultants will work as part of the CDST to assist clients facing teams with data extraction, transformation, and load capabilities into our various audit tools. In addition, they provide critical support with data analysis, reporting and data visualization. This work will enable us to deliver innovative solutions to our clients.
 
This position requires written and oral fluency in English. The successful candidate may be required to support or collaborate with English-speaking colleagues or stakeholders while at KPMG. The successful candidate may be required to create, interpret and/or apply policies, practices, laws and and/or regulations during the regular course of their employment.


What you will do

  • Work with audit engagement teams to support the use of Data and Analytics (D&A) in the performance of external audits including data acquisition, movement and transformation; utilize a range of technologies and data capabilities such as Alteryx, SQL, Databricks, Power BI and Microsoft PowerApps & PowerAutomate
  • Communicate the technical implications of D&A projects to audit engagement teams; identify issues / challenges, and provide recommendations, opportunities, and mitigation strategies
  • Work with audit engagement teams to scope D&A projects, review analytic results and deliver innovative solutions that enhance audit planning and execution.
  • Collaborate with client technology teams to understand ERP environments and data architecture, assess the technical implications of data acquisition and analysis, and deliver clear, well structured audit documentation across the D&A lifecycle, while building long term client relationships through high-quality engagement delivery and professional networking
  • Participate in business development by identifying new opportunities and assisting with proposal development for a high-quality technology and data enabled audit

What you bring to the role

  • Bachelors or Diploma or Master in Computer Science, Database Management, Data Programming, Information Systems, Data Engineering, Data Analytics, Applied Computing or other IT-related degree;
  • Ideal candidate will also have coursework or experience in the Accounting and/or Finance industry
  • Proficiency with Microsoft Office suite of tools, including Word, Excel, and PowerPoint
  • Strong database proficiency (e.g., SQL, My SQL, Oracle etc.) and knowledge of SQL code scripting, including creation/implementation of API’s and debugging ability.
  • Knowledge of data analytics, visualization, scripting, and automation tools including Alteryx, PowerBI, Azure Databricks, Python, Microsoft VBA, PowerQuery, PowerApps, and PowerAutomate.
  • Strong communication skills (verbal and written) - ability to work with multiple stakeholders and communicate priorities/ manage expectations
  • Proven time management and organizational skills
  • Comfortable managing diverse responsibilities from day to day administrative and operational work to project and deadline driven tasks
  • Resourceful and creative problem-solving skills - you are proactive and always bring new ideas and ways of working forward

Keys to your success:

  • Ability to clearly articulate, identify and define problems and develop creative and practical solutions to address different and unique client requirements
  • Able to employ sound professional judgment and professional skepticism; flexible and adaptable team player; leadership experience; resourceful in delivering high-quality, detail-oriented deliverables; ability to demonstrate sound organization and project management skills

KPMG Ontario Region pay range informationThe expected base salary range for this position is $60,000 to $78,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


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.

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.

KPMG Canada

KPMG LLP is the Canadian member firm of KPMG International. We provide Audit, Tax, and Advisory services to many of the public and private business, not-for profit, and public sector organizations in Canada. Nationally, there are 40 offices and over 700 partners and more than 10,000 employees working together to help Canadian businesses achieve their goals. Leveraging the skills, knowledge and passion of our firm and our people allows us to serve our clients with uncompromising professionalism, cutting through complexity to provide valuable insight—in Canada and around the world. KPMG s.r.l./S.E.N.C.R.L. est le cabinet canadien membre de KPMG International Cooperative (« KPMG International »). Nous offrons des services professionnels en audit et en fiscalité ainsi que des services-conseils à une vaste clientèle composée notamment de sociétés ouvertes et fermées, d’organismes sans but lucratif et d’organisations du secteur public au Canada. KPMG compte 40 bureaux à l’échelle nationale, au sein desquels collaborent plus de 700 associés et plus de 10 000 employés pour aider les sociétés canadiennes à atteindre leurs objectifs. Nous misons sur les compétences et le savoir-faire de notre équipe pour servir nos clients − au Canada et ailleurs dans le monde − avec rigueur et professionnalisme. Notre mission première : simplifier la complexité en proposant des perspectives éclairantes.
Runway Icon
Boost Your Interview Chances

With Runway

See Your Fit for This Role

1-5 min

Your Score

?

Top Applicants

90%

Your Job Search Advantage

Key Gaps & Next Steps:

Address these in your resume & Interview

Top Strengths For This Role

Highlight these in your cover letter & interview

Your Interview Guide

A Personalized Interview Strategy

Freshest Opportunities

Never Miss a Good Fit

Get notified when jobs mach your criteria