What is the opportunity?

As Senior Analyst, you will be responsible for the production, development, enhancement and maintenance of financial reporting across RBC’s lines of business. You will partner closely with our business partners to deliver management reports, financial reports, and statutory and regulatory reports that drive business decisions. You will provide production support in monthly, quarterly, and year-end reporting activities with particular intensity during quarter-end and year-end close.

You will implement automated reporting solutions using VBA and SQL to enhance reporting efficiency and accuracy, while supporting Reporting Shared Services’ strategic direction and vision.

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 Finance teams and the CFO group across all RBC lines of business

Interact with Finance/business platforms to ensure accurate understanding of report requirements and provide timely response to user requests

Provide support to RBC’s auditors: internal, external, and 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 (Key Performance Indicators) metrics and quality standards are adhered to

Manage multiple competing priorities effectively, especially during intense period-end close cycles (quarter-end and year-end)

What do you need to succeed?

Must-Have Qualifications:

Education: Bachelor’s degree in Business, Accounting, Finance, or Finance/Accounting designation or equivalent education and experience

Applications: Advanced knowledge of Microsoft Excel

Code Languages: Intermediate hands on experience with VBA (Visual Basic for Application) for automating Excel based financial reports. Basic SQL knowledge.

Financial Reporting Literacy:



Comprehension of financial statements (balance sheet, income statement, variance analysis) necessary to validate report accuracy and support stakeholder requirements

Quick learner capable of grasping new reporting tools within a short time frame

Must-Have Competencies:

Curiosity and continuous learning mindset: Proactive approach to developing new skills and staying current with evolving tools and technologies

Openness to change and adaptability: Comfort with evolving platforms, methodologies, technology and business requirements

Detail-oriented with strong problem-solving and validation rigor: Ability to identify issues, validate data accuracy, and implement robust solutions in a complex financial reporting environment

Ability to manage multiple competing priorities: Particularly during intense period-end close cycles (quarter-end and year-end)

Cross-functional collaboration and stakeholder management: Ability to work effectively across RBC’s lines of business and partner with senior finance leadership in the CFO group

Strong communication skills: Ability to clearly articulate technical and reporting concepts to finance teams and senior leadership

Nice-to-Have:

Experience with IBM Planning Analytics for Excel (PAfE).

Coding languages: Advanced SQL, Python

Experience working with RPA, AI

Lean Six Sigma; 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 mentoring opportunities

Ability to make a difference and lasting impact on RBC’s financial reporting infrastructure

Work in a dynamic, collaborative, progressive, and high-performing team A world-class training program in financial services





Versatile work/life balance options

Opportunities to do challenging work that directly influences senior leadership decision-making

Job Skills

Ad Hoc Reporting, Decision Making, Detail-Oriented, Financial Reporting and Analysis, Financial Services Industry, Financial Statement Analysis, Group Problem Solving, Management Reporting, Reporting Processes, Reporting Requirements, Results-Oriented

Additional Job Details

Address

120 WESTERN PKY:BEDFORD

City

Bedford

Country

Canada

Work hours/week

37.5

Employment Type

Full time

Platform

TECHNOLOGY AND OPERATIONS

Job Type

Regular

Pay Type

Salaried

Posted Date

2026-06-02

Application Deadline

2026-08-14

Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date above

Our Employment Opportunities

At RBC, we are guided by living shared values of Client First, Integrity, Collaboration, Respect and Excellence and winning together as One 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.

Join our Talent Community Stay in-the-know about great career opportunities at RBC. Sign up and get customized info on our latest jobs, career tips and Recruitment events that matter to you. Expand your limits and create a new future together at RBC. Find out how we use our passion and drive to enhance the well-being of our clients and communities at jobs.rbc.com.

RBC is presently inviting candidates to apply for this existing vacancy. Applying to this posting allows you to express your interest in this current career opportunity at RBC. Qualified applicants may be contacted to review their resume in more detail.

📌 Senior Analyst, Reporting Shared Services (Dartmouth)
🏢 Royal Bank of Canada
📍 Dartmouth