What is the opportunity?

The Senior Data Business Analyst will be responsible for the acceptance of and growth in RBC Capital Markets’ central repository of securities data. In this position, you will achieve success 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 also be essential for the analyst to provide reference data expertise throughout RBC Capital Markets and build effective relationships with business units and development teams across RBC.

What will you do?

• Provide subject matter expertise within the reference data space to internal clients and development groups.
• Participate in the data integration process: requirements analysis and definition, documentation of functional specifications, building of test cases, and final integration into the production environment.
• Identify root causes of data issues and implement process improvement initiatives.
• Contribute to the maintenance of securities reference metadata.
• Develop and document operational controls and work processes.
• Provide analysis in the selection of new market data vendors if and when required
• Keep abreast of industry best practices, regulatory requirements, and emerging tools, practices, concepts, and standards.

What you need to succeed?

Must-have

• University Degree
• Minimum 5 years of experience in the use of reference data across different product types (fixed income, equity, derivatives, currencies, commodities, indices) within an established financial institution, investment bank or fund management organization.
• 2 to 3 years of experience in defining requirements and documenting functional specifications including requirements documents, technical specifications, and process flows.
• Experience developing SQL queries or reports from SQL databases and applications used in the analysis of requirements as well as reports produced for operations.
• Relevant work experience using MS Excel, MS Access, Visio, and JIRA.
• Self-starter – take initiative and work independently
• Strong presentation skills to communicate effectively with stake holders across various business units.

Nice to haves :

• Canadian Securities Course
• Understanding of capital market trading applications and its need for securities reference data.
• Experience with the use of Bloomberg and Reuters data (reference data, corporate actions).
• Experience with GoldenSource or any another enterprise data management systems.
• Working knowledge of ADP/Broadridge systems.
• Strong organizational skills
• Team player with excellent interpersonal communication skills.
• Advanced problem solving, analytical, and decision-making skills.
• Familiarity of the systems development life cycle.
• Knowledge of Information Technology capabilities and constraints.
• Experience with Python is an asset

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.

• 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

Job Skills

Critical Thinking, Data Administration, Database Structures, Data Modeling, Data Movement, Detail-Oriented, Group Problem Solving, Information Capture, Standard Operating Procedure (SOP), Teamwork

Additional Job Details

RBC CENTRE, 155 WELLINGTON ST W:TORONTOTORONTOCanada37.5Full timeCAPITAL MARKETSContract (Fixed Term)Salaried2025-05-062025-05-20

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

Inclusion and Equal Opportunity Employment

At 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.