Manager - Financial Analysis

KPMG LLP Canada; Toronto; On-site; CAD 70,000 - 90,000; Full time

Job summary

KPMG LLP Canada seeks a Manager – Financial Analysis to join its Finance Reporting team in Toronto. This role involves creating financial reports, managing data workflows, and collaborating with internal clients. The ideal candidate has a degree in finance, strong analytical skills, and experience with Power BI and Azure technologies.

Qualifications

• 2-3 years experience in financial analysis.
• Experience creating Power BI reports and DAX measures.
• Experience with Azure Databricks and Azure Synapse Analytics an asset.

Responsibilities

• Create and modify dashboards and reports in Power BI.
• Prepare financial reports and ad hoc analyses in Excel.
• Create and modify data ETL workflows in Azure Databricks and Synapse.

Skills

Analytical problem-solving

Communication skills

Advanced Microsoft Excel

Creating Power BI reports

Writing SQL queries

Education

Undergraduate degree in business, finance, accounting, or data science

Tools

Power BI

Azure Databricks

Azure Synapse Analytics

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.

As part of the Finance Reporting team, the Manager – Financial Analysis will prepare financial reports using Power BI and Excel. They will communicate with internal clients across the country to present their work, discuss new requests, and answer business questions. The Manager – Financial Analysis will also create and modify data ETL workflows within Azure Databricks and Synapse.

What you will do

• Report Creation (60% of time):
  • Create and modify dashboards and reports in Power BI
  • Create financial reports and ad hoc analyses in Excel
  • Write SQL queries to import data into Power BI and Excel
  • Review reports to ensure accuracy
• Collaboration (20% of time):
  • Demonstrate newly created reports to end users
  • Meet with internal clients to answer their business questions
  • Work with other Finance Reporting team members to solve problems and discuss improvements
• Data Management (15% of time):
  • Create and modify data ETL workflows in Azure Databricks and Synapse
  • Query data from Azure Synapse
  • Identify data discrepancies
• Learning (5% of time):
  • Research data visualization and data management best practices
  • Enhance Microsoft Azure, Power BI, and Excel skills
  • Learn about the business and how to support it with helpful financial information

What you bring to the role

• 2-3 years experience in financial analysis
• Undergraduate degree in business, finance, accounting, or data science
• Strong communication skills
• Analytical problem-solving mindset
• Advanced Microsoft Excel skills
• Experience creating Power BI reports and DAX measures
• Experience writing SQL queries an asset
• Experience with Azure Databricks an asset
• Experience with Azure Synapse Analytics an asset

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.