Senior Analyst, Reporting Shared Services

RBC; Toronto; On-site; CAD 80,000 - 100,000; Full time

Job summary

A major financial institution in Toronto is seeking a Senior Analyst responsible for producing and maintaining financial reports. The ideal candidate will hold a degree in Business or Accounting and possess advanced skills in Microsoft Excel and VBA. This role involves working closely with Finance teams to ensure accurate reporting and adherence to quality standards. Join a dynamic and inclusive team that values employee development and offers competitive compensation, bonuses, and benefits.

Benefits

Competitive compensation

Bonuses and flexible benefits

World-class training program

Qualifications

• Bachelor’s degree or equivalent education in Business/Accounting/Finance.
• Ability to learn and apply new reporting tools quickly.
• Advanced skills in Microsoft Excel with VBA knowledge.

Responsibilities

• Produce and maintain financial management reports.
• Support Finance teams for financial reporting.
• Adhere to report quality standards and documentation.

Skills

Advanced knowledge of Microsoft Excel

Quick learner for new reporting tools

Intermediate knowledge of VBA

Education

Bachelor’s degree in Business/Accounting/Finance

Tools

SQL

Cognos TM1

Cognos Analytics

Job description

Job Description

As Senior Analyst, you will be responsible for the production, development, enhancement and maintenance of platform financial reporting for external, management and other reporting needs. You will provide production support in quarterly, monthly and year‑end reporting activities and implement automated solutions according to business requirements.

What will you do?

• Accountable for the production, maintenance and enhancements of required financial management reports.
• Accountable for the timely development and delivery of scheduled, new and ad‑hoc reports and change requests.
• Support the Finance teams responsible for the financial reporting of Total RBC.
• Interact with Finance/business platforms to ensure accurate understanding of report requirements and provide timely response to user requests.
• Interact with RBC’s auditors: internal, external, SOX controls.
• Ensure report and quality standards are adhered to and continuous improvement initiatives are embedded within production and development.
• Ensure adequate and up‑to‑date documentation on workflow tickets, report inventory, reporting processes and related activities/components.
• Responsible for ensuring KPI metrics and quality standards are adhered to.

What do you need to succeed?

Must‑Have

• Bachelor’s degree in Business/Accounting/Finance or Finance/Accounting designation or equivalent education and experience.
• Quick learner to grasp new reporting tools within a very short time frame and apply the skills to develop, run and maintain financial reports.
• Advanced knowledge of Microsoft Excel.
• Intermediate knowledge of VBA (Visual Basic for Application) or equivalent programming language.

Nice‑to‑have

• Knowledge of Certent CDM, Cognos TM1, Cognos Analytics, TM1 Perspectives, IBM Planning Analytics for Excel (PAfE).
• Programming (SQL, WebFOCUS, etc.).
• Lean Six Sigma tools; Agile Methodology; Quality Assurance.

What’s in it for you?

• A comprehensive Total Rewards Program including bonuses and flexible benefits, competitive compensation, commissions, and stock where applicable.
• Leaders who support your development through coaching and managing opportunities.
• Ability to make a difference and lasting impact.
• Work in a dynamic, collaborative, progressive, and high‑performing team.
• A world‑class training program in financial services.
• Opportunities to do challenging work.

Inclusion and Equal Opportunity Employment

At RBC, we believe an inclusive workplace that has diverse perspectives is core to our continued growth as one of the largest and most successful banks in the world. Maintaining a workplace where our employees feel supported to perform at their best, effectively collaborate, drive innovation, and grow professionally helps to bring our Purpose to life and create value for our clients and communities. RBC strives to deliver this through policies and programs intended to foster a workplace based on respect, belonging and opportunity for all.