Business Analyst (Capital Markets)

Job Description

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 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 3 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.
  • Minimum 2 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
• Nice To Have
  • 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

RBC is committed to supporting flexible work arrangements when and where available. Details to be discussed with Hiring Manager.

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.
JOB SUMMARY
City: Toronto OR Halifax
Address: 155 Wellington Street West OR 120 Western Parkway, 6th floor, Bedford
Work Hours/Week: 37.5
Work Environment: Office
Employment Type: Full Time
Career Level: Experienced Hire/Professional
Application Deadline: 11/16/2021
Platform: Capital Markets
Req ID: 426898
Ad Code(s):