Full Time Data Analyst R Programming Jobs in Ottawa, ON

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.

Your work matters. As part of our Audit & Assurance practice, you’ll deliver highquality work that supports trust, transparency, and confidence across both public and private organizations. We foster an environment of high challenge, where curiosity and critical thinking are encouraged.  Through high support, including progressive learning, strong coaching, inclusive teamwork, and a shared commitment to integrity, we perform at our best – measuring what matters, recognizing impact, and continuously evolving to deliver excellence.  This creates a culture where the best work happens when high challenge and high support work together.  That balance is how our values show up—in how we work, how we lead, and what we deliver.

We are looking for a Senior Manager of Data Analysis & Audit Productivity to join our Audit Center – Audit Technology and Transformation team.

• Leverage Databricks to design, build, and maintain scalable data pipelines, automate data processing, and support advanced reporting and analytics initiatives across the audit practice.
• Utilize Microsoft Power Automate and PowerApps to develop workflow automation solutions, reducing manual effort, improving process consistency, and enhancing stakeholder experience.
• Develop end-user dashboard solutions to aid our engagement teams in project managing their audits, and to assist leadership in their ability to centrally monitor audit progress nationally
• Lead and manage the updates, maintenance, and support our audit teams with the use of our automated budget dashboard and milestone monitoring dashboard
• Lead and manage the updates, maintenance, and support our national office with the use of mining data from a globally supported solution, KCw Data Mining
• Coach, supervise and review the work of junior team members, including audit project coordinators, data analyst and the Central Data Support Team (includes data engineers, software developers and data scientists)
• Lead the junior team members through design, build, testing, and deployment of new or updated solutions, ensuring quality and operational excellence, and sufficient documentation of testing results  
• Proactively improve internal audit processes and leveraging automation, analytics, and AI tools to address them
• Liaise with subject matter experts’ teams to identify the need for, and obtain access to information that supports our automated and centralized processes
• Proactively contributes to the creation of presentation materials and quarterly reporting relating to data activities for stakeholder discussions (national and global).

• Technical: 7+ years of experience
  • Post-secondary degree in computer engineering, mathematics, data science, or related disciplines
  • Intermediate proficiency in Microsoft Excel (specifically with Power Query and VBA) and Microsoft Power Platform (including PowerBI, Power Automate, and Power Apps)
  • Intermediate proficiency working with databases
  • Intermediate proficiency in Python (or similar scripting languages) for data processing, automation, and analytical workflows
  • Experience with QA testing, including ability to create test plans, test cases, execute test cycles, etc.
  • Exposure to AI agent tools and generative AI capabilities, such as Copilot Studio, Azure AI, Azure OpenAI, or similar platforms
  • Understanding of integrations, APIs, SharePoint Online, ServiceNow, or comparable enterprise platforms
  • Relevant Microsoft, Azure, Power Platform, or AI certifications are considered an asset
    
• Soft Skills: 5+ years of experience
  • Ability to translate business needs into clear technical work items and help teams move from intake through build, testing, release, and sustainment
  • Experience collaborating with cross-functional teams to solve complex data challenges
    Self-Starter who identifies gaps in processes and advocates solutions for improvement
  • Experience and ability to coach, supervise and review the work of junior employees, as well as managing and coordinating expectations of stakeholders
  • Exceptional attention to detail and ability to self-review
    
• 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.

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

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

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

• Technical: 7+ years of experience
  • Post-secondary degree in computer engineering, mathematics, data science, or related disciplines
  • Intermediate proficiency in Microsoft Excel (specifically with Power Query and VBA) and Microsoft Power Platform (including PowerBI, Power Automate, and Power Apps)
  • Intermediate proficiency working with databases
  • Intermediate proficiency in Python (or similar scripting languages) for data processing, automation, and analytical workflows
  • Experience with QA testing, including ability to create test plans, test cases, execute test cycles, etc.
  • Exposure to AI agent tools and generative AI capabilities, such as Copilot Studio, Azure AI, Azure OpenAI, or similar platforms
  • Understanding of integrations, APIs, SharePoint Online, ServiceNow, or comparable enterprise platforms
  • Relevant Microsoft, Azure, Power Platform, or AI certifications are considered an asset
    
• Soft Skills: 5+ years of experience
  • Ability to translate business needs into clear technical work items and help teams move from intake through build, testing, release, and sustainment
  • Experience collaborating with cross-functional teams to solve complex data challenges
    Self-Starter who identifies gaps in processes and advocates solutions for improvement
  • Experience and ability to coach, supervise and review the work of junior employees, as well as managing and coordinating expectations of stakeholders
  • Exceptional attention to detail and ability to self-review
    
• 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.

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