Senior Data Consultant- 24 Month Contract

KPMG Canada; North Bay; On-site; CAD 60,000 - 80,000; Full time

Job summary

A leading professional services firm in North Bay is seeking a Data Consultant to join their Audit Technologies team. Responsibilities include automating business processes using Microsoft PowerApps, providing data analysis to clients, and collaborating with diverse teams. Ideal candidates will have a diploma or bachelor's in computer science and strong proficiency with data analytics tools. This role offers a dynamic work environment focused on innovation and excellence.

Qualifications

• Must have proficiency with Microsoft PowerApps and PowerAutomate.
• Strong communication skills and ability to manage multiple stakeholders.
• Resourcefulness and creative problem-solving ability.

Responsibilities

• Automate key business processes using Microsoft PowerApps.
• Identify issues and provide recommendations to engagement teams.
• Process large volumes of client data for ETL.

Skills

Microsoft PowerApps

PowerAutomate

Statistical knowledge

Communication skills

Problem-solving skills

Education

Diploma or bachelor's in computer science

Tools

Azure Databricks

Alteryx

Power BI

SQL

MySQL

Oracle

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 part of the national audit centre, audit support team. The group implements new technologies in the audit practice and provides digital and data & analytics services to clients. It works as part of a multi-disciplinary team supporting KPMG proprietary and third-party data & analytics solutions for our teams. Data consultants will work as part of the Audit Technologies team to assist with automating key business processes using Microsoft PowerApps and PowerAutomate. They also provide client-facing teams with data analysis, reporting and data visualization to deliver innovative solutions to 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 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 discrete 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 knowledge 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 proactive and offer new ideas and ways of working forward
• Proven time management and organizational skills
• Knowledge of data extraction, transformation, and loading tools and utilities
• Written and oral fluency in English

Highly Preferred

• Proficiency 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, MySQL, Oracle etc
• Experience with SQL code scripting, including creation/implementation of APIs and debugging ability

The successful candidate will be required to support or collaborate with English-speaking colleagues or stakeholders while at KPMG. The position may involve creating, interpreting and applying policies, practices, laws and regulations during employment.

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

Our Values, The KPMG Way: Integrity (doing what is right), Excellence (never stop learning and improving), Courage (think and act boldly), Together (respect and draw strength from differences), For Better (do what matters).

KPMG in Canada is an equal opportunities employer and is committed to a respectful, inclusive and barrier-free workplace. We welcome all qualified candidates to apply.

Adjustments and accommodations throughout the recruitment process

KPMG is committed to fostering an inclusive recruitment process. 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) and accommodations (formal requests) are tailored to individual needs and role requirements. You will have an opportunity to request an adjustment or accommodation at any point during the recruitment process. If you require support, please contact KPMG’s Employee Relations Service team at 1-888-466-4778.