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
Flexible 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
120 WESTERN PKY:BEDFORD
Bedford
Canada
37.5
Full time
TECHNOLOGY AND OPERATIONS
Regular
Salaried
2026-06-02
2026-06-19
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.
