Senior Financial Analyst (16-Month Contract)

KPMG LLP Canada; Toronto; On-site; CAD 60,000 - 80,000; Full time

Job summary

A leading company in Canada is seeking a Financial Analyst to manage structure changes in SAP and Oracle reporting applications. The role involves preparing detailed reports, analyzing data, and supporting the Business Enablement Services function. Ideal candidates will have a Bachelor's degree and relevant experience in financial analysis and data analytics, with strong skills in Excel and SQL.

Qualifications

• 1-2 years’ experience in financial analysis and/or data analytics.
• Strong analytical skills and attention to detail.
• Experience writing SQL queries and creating Power BI reports.

Responsibilities

• Prepare detailed reports and assist in month-end close process.
• Manage ServiceNow requests and perform administrative tasks.
• Write complex SQL queries and create dashboards in Power BI.

Skills

Analytical skills

Customer focus

Interpersonal skills

Attention to detail

Communication skills

Microsoft Excel

SQL

Power BI

Education

Bachelor’s degree in accounting, finance, data science or equivalent

Tools

SAP

Oracle

Power BI

SQL Server

Excel VBA

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.

Reporting to the Senior Manager, Finance Reporting & Systems, the Financial Analyst is responsible for managing the requests for structure changes to be processed in our SAP and Oracle reporting applications. They will also be

responsible for analyzing data and preparing various monthly reports in support of our Business Enablement Services function.

What you will do

• Prepare detailed reports for assigned groups. Investigate identified variances
• Assist in month end close process
• Manage the ServiceNow requests for Structure Changes
• Perform administrative tasks to maintain structures changes in SAP and Oracle Reporting systems
• Manage Functional Mailboxes ensuring all enquiries are actioned or assigned
• Liaise with Finance Analysts and various client groups to follow up on time-sensitive queries
• Ad-hoc projects or analysis as required
• Writing complex SQL queries and aggregating large datasets to import data into Power BI and Excel
• Gathering raw data from various sources including databases (SQL Server), Spreadsheets (Excel) and other systems (SAP and SAP HANA)
• Troubleshooting application issues using Excel VBA Macros, Access Macros and SQL queries
• Ensuring the accuracy and consistency of reports through data quality checks and validation
• Create dashboards and reports in Power BI

At times, business needs arise, and employees are required and agree to work beyond their normal work day or work week to fulfill the accountabilities required for their job. Likewise, people need time to devote to personal matters, and our approach to flexibility provides for this.

What you bring to the role

• Bachelor’s degree in accounting, finance, data science or equivalent
• 1-2 years’ experience in financial analysis and/or data analytics and/or systems administration
• Strong customer focus, interpersonal skills and ability to work independently
• Strong analytical skills with an ability to get into the details, while also seeing and understanding the big picture
• Excellent written and verbal communication skills, with the ability to communicate with all levels within the firm
• Very strong attention to detail
• Ability to work quickly and accurately under the pressure of deadlines and changing priorities.
• Advanced Microsoft Excel skills
• Experience managing reporting Structures (SAP or Oracle an advantage)
• Experience writing SQL queries
• Experience creating Power BI report

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.