Senior Business System Analyst

RBC; Toronto; On-site; CAD 90,000 - 130,000; Full time

Benefits offered by this job

Total rewards program

Flexible benefits

Stock options

World-class training

Job summary

RBC is seeking a Senior Business Systems Analyst to lead requirements sessions, analyze data models, and collaborate with Product and Finance Controllers on large initiatives. You will model and map data flows, facilitate cross-functional discussions, and support testing cycles in an agile environment.

Strong communication and SQL/Excel skills are essential for success. The role emphasizes independence, teamwork, and the ability to drive resolution across complex projects within the Canada-based

Qualifications

• Bachelor’s or Master’s degree in Technology or Business.
• 5-7 years of Business Systems Analysis experience in fast-paced environment.
• Expert knowledge of SQL and Excel for data analysis.
• Good Capital Markets product knowledge, particularly derivatives.
• Proven Data Analysis experience and project delivery in financial services, preferably in MS Access.
• Understanding and experience in software development life-cycle.
• Excellent communication skills are critical for this role.
• Able to quickly gather, synthesize and drive resolution of project tasks in a cross-functional team.
• Self-starter with the ability to work with minimal supervision.
• Teamwork & Collaboration; willing to challenge ideas and brainstorm.

Responsibilities

• Undertake BA responsibilities of multiple strategic applications involving Capital Market Products.
• Understand modelling of financial products traded on RBC Markets and related booking/settlement concepts.
• Analyze existing data models (MS Access) and map gaps to business requirements.
• Lead requirements discovery, analysis, and review with business stakeholders.
• Perform data analysis and reverse engineering to identify current and future states; map dependencies.
• Create data flow and system context diagrams; work with development teams to ensure correct implementation.
• Provide hands-on support during Functional, SIT, and UAT testing.
• Adopt Agile methodologies to enable periodic implementations.
• Manage risks, assumptions, and constraints; communicate with stakeholders.
• Work with JIRA, Confluence, SQL; learn adhoc tools as needed.

Skills

Stakeholder facilitation

Communication

Requirements analysis

Agile mindset

Education

Bachelor's or Master's degree in Technology or Business

Tools

JIRA

Confluence

SQL

Excel

Job description

What is the opportunity?

The Senior Business Systems Analyst (BSA) responsibilities will be conducting requirements gathering sessions and other BA activities with a large diverse set of Product Controllers and Finance Controllers for medium to large size project initiative and able to provide high level key deliverable plan and detail break down of major tasks; understanding the various Capital Market Products and ability to differentiate various trade economics; mapping and tracing source data to WSB applications and understanding impact; work on requirements gathering and solution design for change requests and major programs.

Job Description

The Senior Business Systems Analyst (BSA) responsibilities will be conducting requirements gathering sessions and other BA activities with a large diverse set of Product Controllers and Finance Controllers for medium to large size project initiative and able to provide high level key deliverable plan and detail break down of major tasks; understanding the various Capital Market Products and ability to differentiate various trade economics; mapping and tracing source data to WSB applications and understanding impact; work on requirements gathering and solution design for change requests and major programs.

This position requires a lot of interpersonal interaction at all levels within the organization, from technical personnel to high level management, excellent communication skills are a must for this role.

What will you do?

• Undertake BA responsibilities of multiple strategic applications involving Capital Market Products
• Understand the various financial products traded on Markets in RBC and how they have been modeled eg: securities, Derivatives etc.. Be familiar with booking and settlement process and concepts of trades, positions, and sub-ledger, price valuations.
• Analyze existing data models built on MS Access and co-relate Business requirements to gaps in Data models and build solutions.
• Analysis and document Business and Functional requirements from business stakeholders. Lead and facilitate collaborative sessions with business stakeholders to drive requirements discovery, analysis, and review.
• Get familiar with current data models and systems. Perform data analysis and reverse engineering, to access the current and future states and perform gap analysis. Identify upstream and downstream dependencies.
• Construct data flow diagrams, business, and system context diagrams, create design solutions. Work closely with the development teams to ensure there is full understanding and proper execution of requirements in a timely manner.
• Provide hands‑on support during various cycles of testing including Functional Testing, Systems Integration Testing, and User Acceptance Testing.
• Adopt Agile methodologies to enable periodic implementations.
• Scrum Management experience, provide high level key deliverable plan and detail break down to user stories and major tasks; providing guidance and leadership through to the scrum team during all project phases; ability to handle pressure with multiple priorities.
• Manage risks, assumptions, and constraints for requirements, and communicate to appropriate parties.
• Work with tools and platforms such as JIRA, Confluence, SQL and be willing to learn adhoc.

Must-have:

• Bachelor’s or Master’s degree. Preferably Technology or Business.
• 5-7 years of Business Systems Analysis experience in fast-paced environment
• Expert knowledge of SQL and Excel for data analysis
• Good Capital Markets product knowledge, particularly derivatives
• Proven Data Analysis experience and project delivery in financial service industry preferably in MS Access
• Understanding and experience in software development life-cycle
• Excellent communication skills are critical for this role
• Able to quickly and effectively gather, synthesize and drive resolution of project tasks in a cross-functional team
• Self-starter and ability to work with minimal supervision.
• Teamwork & Collaboration – Have principals, disagree if needed, and brainstorm.
• Analytical and creative thinker
• Ability to clearly articulate problems and solutions
• Detailed oriented with strong problem solving skills
• Expert time management and organizational skills with the ability to manage multiple projects with competing deadlines

Nice-to-have:

• Experience working in Banking IT servicing Product Controllers and Finance Controllers
• Familiarity with coding languages like JAVA, .Net
• Dealing with Ambiguity

What’s in it for you?

We thrive on the challenge to be our best, progressive thinking to keep growing, and working together to deliver trusted advice to help our clients thrive and communities prosper. We care about each other, reaching our potential, making a difference to our communities, and achieving success that is mutual.

• 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
• Flexible work/life balance options
• Opportunities to do challenging work

Job Skills

Agile Methodology, Business Data Analysis, Business Process Modeling, Commercial Acumen, Communication, Critical Thinking, Decision Making, Group Problem Solving, Interpersonal Relationship Management, Requirements Analysis

Additional Job Details

Address: RBC CENTRE, 155 WELLINGTON ST W:TORONTO

City: Toronto

Country: Canada

Work hours/week: 37.5

Employment Type: Full time

Platform: TECHNOLOGY AND OPERATIONS

Job Type: Regular

Pay Type: Salaried

Posted Date: 2026-07-16

Application Deadline: 2026-09-11

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.