Senior Data Consultant- 24 Month Contract

KPMG Canada; Fort St. John; On-site; CAD 60,000 - 90,000; Full time

Job summary

A leading consultancy firm in Canada is looking for a Data Consultant to automate business processes with Microsoft PowerApps and PowerAutomate. The ideal candidate should have a relevant degree, strong statistical knowledge, and proficiency in data management. The role involves working with client data and providing innovative data solutions, emphasizing collaboration and communication.

Qualifications

• Must be fluent in written and oral English.
• Proven time management and organizational skills required.
• Knowledge of data extraction and loading tools essential.

Responsibilities

• Automate audit procedures using PowerApps and PowerAutomate.
• Provide recommendations and mitigation strategies to teams.
• Process large volumes of data as part of ETL.

Skills

Proficiency with Microsoft PowerApps

Strong Statistical Knowledge

Creative problem-solving

Strong communication skills

Knowledge of ETL processes

Education

Diploma or bachelor’s in computer science or related field

Tools

Azure Databricks

Alteryx

Power BI

SQL

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.

The Audit Technologies group is a part of the national audit centre, 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 Audit Technologies team to assist with the automation of key business processes using Microsoft PowerApps and PowerAutomate. In addition, they provide client facing teams critical support with data analysis, reporting and data visualization. This work will enable us to deliver innovative solutions to our clients.

What You Will Do

• Automate key business processes and audit procedures using Microsoft PowerApps and PowerAutomate workflows
• Identify issues / challenges and provide recommendations, opportunities and mitigation strategies to engagement teams
• Work with unique data analytic programs to deliver innovative solutions to our engagement team.
• Process large volumes of client data for import into KPMG proprietary applications as a part of the ETL process
• Build long-term business relationships with client teams through engagement delivery and networking in professional organizations
• Participate in business development by identifying new opportunities and assisting with proposal development
• Collaborate and effectively communicate with professionals with a non-technical background
• Create and roll out bespoke client discreet D&A routines
  
  

What You Bring To The Role

Must-haves

• Diploma or bachelor’s in computer science, Database Management or Programming (or similar programs)
• Proficiency and knowledgeable with Microsoft PowerApps and PowerAutomate
• Strong Statistical Knowledge and Mathematical Foundations.
• Strong communication skills (oral and written) - ability to work with multiple stakeholders, communicate priorities and manage expectations.
• Resourcefulness and creative problem-solving skills - you are a proactive person and always come up with new ideas and ways of working forward.
• Proven time management and organizational skills
• Knowledge of data extraction, transformation, and loading tools and utilities.
• This position requires written and oral fluency in English
  
  

Highly Preferred

• Proficiency and knowledgeable with data management and processing within Azure Databricks.
• Experience with analytics and visualization tools such as Alteryx, Power BI, Power Query, Python, R.
• Experience with databases including SQL, My SQL, Oracle etc.
• Experience with SQL code scripting, including creation/implementation of API’s and debugging ability.
  
  

This position requires written and oral fluency in English. The successful candidate will 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.

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.