Data Support Senior Consultant

KPMG • Edmonton, AB

58d

About The Position

The Central Data Support Team (CDST) is a part of the national audit center, audit support team. The CDST 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.

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

Requirements

• Bachelors or Diploma in Computer Science, Database Management, Data Programming, Information Systems, Data Engineering, Data Analytics, or other IT-related degree;
• Strong database proficiency (e.g., SQL, My SQL, Oracle etc.) and experience in Microsoft SQL Server technology, MSBI suite (including SQL stored procedures and data modeling) or cloud technologies (Azure suite, Databricks pipelines in Python) for financial analysis
• SQL code scripting, including creation/implementation of API’s and debugging ability.
• 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
• 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

Nice To Haves

• Proficiency and knowledgeable with analytics and visualization tools such as Power BI, Python, R, Alteryx, Microsoft PowerApps is preferred.
• Knowledge of data extraction tools and utilities and aptitude to quickly learn various technologies (MS Office, ERP systems, KPMG Audit tools, client applications, Azure cloud technologies)
• Ideal candidate has experience in the Accounting and/or Finance industry

Responsibilities

• 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, Python, PySpark, Azure Data Factory, Databricks, Microsoft Fabric, Azure Data Lake Storage, Power BI and other Azure technologies
• Communicate the technical implications of D&A capabilities to audit engagement teams; identify issues / challenges, and provide recommendations, opportunities, and mitigation strategies
• Work with audit engagement teams to scope D&A capabilities, 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 This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 5,001-10,000 employees