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.

Job Description

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:
- Application Deadline:

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

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.

#J-18808-Ljbffr

📌 Senior Analyst, Reporting Shared Services (Halifax Regional Municipality)
🏢 RBC
📍 Halifax Regional Municipality