Senior Analyst, Financial Reporting

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

Job summary

Join a leading company as a Senior Analyst in the Finance Reporting team, where you will manage financial data and create insightful reports using SQL Server, Power BI, and Excel. This role involves collaborating with internal clients and enhancing your analytical skills. If you have a strong background in finance or data analytics and excel in communication, we want you to apply!

Qualifications

• 1-2 years experience in financial analysis and/or data analytics.
• Strong communication skills and ability to build working relationships.

Responsibilities

• Design and administer SQL Server databases.
• Create dashboards and reports in Power BI.
• Collaborate with internal clients to answer business questions.

Skills

Communication

Analytical Problem-Solving

SQL

Power BI

Excel

Education

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

Tools

SQL Server

Power BI

Excel

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 Senior Analyst will organize financial data using SQL Server and prepare management reports using Power BI and Excel. They will also communicate with internal clients across the country to discuss new reports and answer business questions.

What you will do

• Data Management (15% of time):
  • Design, develo, and administer SQL Server databases
  • Use ETL processes to transfer, cleanse, and assimilate data
  • Identify data discrepancies
• Report Creation (60% of time):
  • Create 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):
  • Reach out to end users and stakeholders to share findings and solutions, ensuring clarity and understanding
  • Work with internal clients to answer their business questions
  • Work with other Finance Reporting team members to solve problems and discuss improvements
• Learning (5% of time):
  • Research data management and data visualization best practices
  • Enhance SQL Server, Power BI, and Excel skills
  • Learn about the business and its reporting challenges

What you bring to the role

• 1-2 years experience in financial analysis and/or data analytics
• Post Secondary Education or Undergraduate degree in business, finance, accounting, or data science
• Strong communication skills and ability to build working relationships in a remote environment
• Ability to engage in effective communication and collaboration with various internal teams/stakeholders
• Ability to work autonomously to gather and analyze information, demonstrating a strong sense of ownership and accountability
• Demonstrated analytical problem-solving mindset
• Advanced Microsoft Excel skills
• Experience writing SQL queries
• Experience creating Power BI reports and creating measures in DAX

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 the opportunity to request an adjustment or accommodation at any point throughout the recruitment process. 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.