Cover for RBC
Senior Business Analyst
CA$75k - CA$98k (Glassdoor est.)
Apply Now
Rating Highlights
Compensation & Benefits : 3.8
Culture & Values : 4.1
Career Opportunities : 3.9
Work/Life Balance : 3.9
Job & Company Insights
Job Type : Full-time
Job Function : business analyst
Industry : Finance
Size : 10000+ Employees

What is the opportunity?

The Securities Data Services group within RBC's Capital Markets Business and Client Services division is responsible for the management of data within the organization's securities reference data repositories.

As a Senior Business Analyst you will contribute to the success of the team by leading the analysis of business requirements and the subsequent translation into functional specifications as well as writing and executing test scrips to ensure quality of deliverables. It will be essential in this role to provide reference data expertise and build effective relationships with business units and development teams across RBC.

What will you do?

  • Meet with project stakeholders that require securities reference data to review, understand, and capture requirements. Requirements will be analyzed and documented, then the solution will be presented to the stakeholders to confirm that it meets their needs. Once requirements are agreed upon, you will provide them to the development team and develop test cases. Once development is complete you will test in a non-production environment. Once approved the project will be promoted to the production environment and you will conduct post-production verification of the changes
  • Document projects in a shared location to support knowledge transfer among team members. Any ongoing support or controls required as the result of a project will be documented and reviewed with the securities data reference data operations team to ensure a seamless transition from the project phase to the support phase
  • Work with the securities reference data operations teams to review and identify the root cause of data problems and work to understand and resolve by implementing systematic solutions
  • Provide subject matter expertise within the securities reference data space to internal RBC clients
  • Write SQL queries to capture data in securities reference data repositories to support analysis and testing
  • Work with external data vendors to understand how vendor changes will impact existing processes and address changes as required
  • Provide analysis in the selection of new external data vendors or new data sets from existing external vendors to meet project requirements
  • Stay abreast of industry standards, best practices, and relevant regulatory requirements

What will you need to succeed?

Must Have

  • University degree with a major in a related field such as business or finance or sufficient post-secondary experience in the financial industry
  • Minimum 7 years of experience using reference data across different product types (equities, fixed income, MBS, options, futures, indices, etc…) within an established financial institution, or investment bank
  • 2-5 years of experience in defining requirements and documenting functional specifications including requirements documents, technical specifications, and process flows
  • Experience writing SQL queries for use in analysis and reports
  • Familiarity with system development life cycle, waterfall and agile project methodologies


  • CFA
  • Canadian Securities Course (CSC)
  • Experience with vendors Bloomberg, Refinitiv, and Broadridge
  • Experience using JIRA, Visio, MS Excel, MS Access, Bloomberg terminal, Refinitiv Eikon terminal
  • Experience with GoldenSource or other enterprise data management systems
  • Strong organizational skills

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
  • Leaders who support your development through coaching and managing opportunities
  • Work in a dynamic, collaborative, progressive, and high-performing team
  • Opportunities to do challenging work
  • Flexible work/life balance options


City: Toronto
Address: 155 Wellington Street West
Work Hours/Week: 37.5
Work Environment: Office
Employment Type: Permanent
Career Level: Experienced Hire/Professional
Pay Type: Salaried
Position Level: PL08
Required Travel(%): 0-25
Exempt/Non-Exempt: N/A
People Manager: No
Application Deadline: 07/16/2021
Req ID: 384000

Show more
Get alerts to jobs like this, to your inbox.

Suggested Searches