Senior Business Analyst (18-month contract)

RBC; Toronto; On-site; CAD 70,000 - 110,000; Full time

Job summary

An established industry player is seeking a Senior Data Business Analyst to enhance their securities data repository. In this role, you will leverage your expertise in reference data to lead business analysis, develop functional specifications, and ensure quality through rigorous testing. You'll work closely with various business units and development teams, fostering relationships that drive efficiency and innovation. This dynamic position offers the opportunity to influence data integration processes and contribute to operational excellence. Join a collaborative team dedicated to delivering trusted advice and making a positive impact on clients and communities.

Benefits

Flexible work/life balance options

Opportunities for challenging work

Supportive leadership for development

Qualifications

• 5+ years of experience in reference data across product types.
• Experience developing SQL queries and reports for operations.
• 2-3 years in defining requirements and documenting specifications.

Responsibilities

• Lead analysis of business requirements and translate into specifications.
• Participate in data integration and documentation of functional specs.
• Identify root causes of data issues and implement improvements.

Skills

Critical Thinking

Data Administration

Database Structures

Data Modeling

Data Movement

Detail-Oriented

Group Problem Solving

Information Capture

Standard Operating Procedure (SOP)

Teamwork

Education

University Degree

Tools

SQL

MS Excel

MS Access

Visio

JIRA

Job description

Job Summary

Job Description

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

Address:

RBC CENTRE, 155 WELLINGTON ST W:TORONTO

City:

TORONTO

Country:

Canada

Work hours/week:

37.5

Employment Type:

Full time

Platform:

CAPITAL MARKETS

Job Type:

Contract (Fixed Term)

Pay Type:

Salaried

Posted Date:

2025-05-06

Application Deadline:

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

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.