You're using an older version of Internet Explorer that is no longer supported. Please update your browser.
KPMG

Senior Analyst, Financial Reporting

Posted 3 days ago

Job Details

Location

Canada

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):
    • Demonstrate newly created reports to end users
    • 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
  • Post Secondary Education or Undergraduate degree in business, finance, accounting, or data science
  • Strong communication skills
  • 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. For more information about Inclusion, Diversity & Equity in Recruitment, please click here .

Adjustments and accommodations throughout the recruitment process
At KPMG, we strive for an inclusive recruitment process that allows all candidates to Come As You Are and Thrive with Us. We aim to provide a positive experience and are ready to offer adjustments or accommodations to help you perform at your best. Adjustments (an informal request), i.e. extra preparation time or the option for micro breaks during interviews, and accommodations (a formal request), i.e. accessible communication supports or technology aids are tailored to individual needs and role requirements.

To begin a confidential conversation about adjustments or accommodations at any point throughout the recruitment process, we encourage you to contact KPMG's Employee Relations Service team for support by emailing cdnersteam@kpmg.ca or by calling 1-888-466-4778, Option 3.

For information about accessible employment at KPMG, please visit our accessibility page .

About KPMG

KPMG LLP is the Canadian member firm of KPMG International. We provide Audit, Tax, and Advisory services to many of the public and private business, not-for profit, and public sector organizations in Canada. Nationally, there are 40 offices and over 700 partners and 7,000 employees working together to help Canadian businesses achieve their goals. Leveraging the skills, knowledge and passion of our firm and our people allows us to serve our clients with uncompromising professionalism, cutting through complexity to provide valuable insight—in Canada and around the world. KPMG s.r.l./S.E.N.C.R.L. est le cabinet canadien membre de KPMG International Cooperative (« KPMG International »). Nous offrons des services professionnels en audit et en fiscalité ainsi que des services-conseils à une vaste clientèle composée notamment de sociétés ouvertes et fermées, d’organismes sans but lucratif et d’organisations du secteur public au Canada. KPMG compte 40 bureaux à l’échelle nationale, au sein desquels collaborent plus de 700 associés et 7 000 employés pour aider les sociétés canadiennes à atteindre leurs objectifs. Nous misons sur les compétences et le savoir-faire de notre équipe pour servir nos clients − au Canada et ailleurs dans le monde − avec rigueur et professionnalisme. Notre mission première : simplifier la complexité en proposant des perspectives éclairantes.

Industry

Banking & Finance

Company Size

5001-10,000 employees

Application closing date is 2025-01-10

Interested in jobs like this?

Sign up for email alerts
Get job alerts

Work with our Featured Employers

M space man icon M
Watch now
H O T Marketing. Tips. Sauce.
Marketing On Mars Podcast Full episodes twice per month
Job successfully reported

Thank you for helping us identify suspicious behaviour.