Senior Business Analyst / Data Analyst (Security Master)
Role Overview
Join the Product Team as a Senior Business Analyst / Data Analyst owning business logic, data quality, and product backlog for the enterprise Security Master.
The platform ingests financial reference data from multiple vendors and serves as a firm-wide source of truth for critical applications.
The role focuses on data and product analysis, not building technical data pipelines.
Key Skills for This Role
Full Job Posting
Role overview
Join the Product Team as a Senior Business Analyst / Data Analyst owning business logic, data quality, and product backlog for the enterprise Security Master.
The platform ingests financial reference data from multiple vendors and serves as a firm-wide source of truth for critical applications.
The role focuses on data and product analysis, not building technical data pipelines.
What you will do
- Define and document business requirements, data mapping rules, and functional specifications.
- Write actionable JIRA user stories with acceptance criteria and participate in sprint planning and grooming.
- Analyze, normalize, and reconcile multi-vendor reference data for equities, fixed income, mutual funds, ETFs, and alternatives.
- Establish golden-copy rules, survivorship logic, and quality metrics to identify and resolve anomalies.
- Coordinate among engineering teams, data vendors, and downstream product owners.
- Lead UAT for platform enhancements and verify data changes meet downstream requirements.
Required qualifications
- Bachelor's degree in Finance, IT, or a related field.
- At least 5 years as a Business Analyst, Data Analyst, or Product Owner in Wealth Management, Asset Management, or Capital Markets.
- Deep knowledge of Security Reference Data structures, corporate actions, and ISIN, CUSIP, SEDOL, and ticker symbology.
- Proficient in SQL and Python for data analysis, profiling, and complex database queries; advanced Microsoft Office proficiency.
- Familiarity with proposal generation, order execution or trading, and portfolio management workflows.
- Strong analytical skills and experience resolving complex discrepancies across vendors.
Preferred skills
- Working knowledge of Python, PySpark, Microsoft Azure, and Azure Synapse for cloud data analysis is a plus.
Benefits
- The posting describes a total rewards program, flexible benefits, and development opportunities.
Workplace and schedule
- The posting lists an address in Toronto and work hours of 37.5 per week; no remote or hybrid policy is stated.
Compensation
- Pay type is listed as salaried; no compensation amount or cadence is stated.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at RBC
analyste d’entreprise, RBC amplifie 2027, Montréal / Business Analyst, RBC Amplify 2027, Montreal- EN
Montréal, CAN
Job Description Analyste d’entreprise RBC amplifie 2027 – Montréal Qu’est-ce que RBC amplifie ? RBC amplifie est un programme de stage d’été intensif qui vous permet de mettre à l’épreuve vos compétences en créant un pro
Senior Manager, Treasury Solutions – Corporate, Transaction Banking (ONE)
Ottawa, CAN
RBC is seeking a senior treasury solutions professional to grow corporate client relationships and revenue through cash management advice and solutions. The role includes client onboarding, sales planning, and travel acr
RBC Group Consultant - Québec
Montréal, CAN
RBC is seeking a mobile sales consultant to acquire business sponsors and members for group retirement savings and financial wellness programs across Québec. Candidates need strong prospecting and sales results, relation
Director, Corporate Client Group Finance
Toronto, CAN
RBC seeks a Director, Corporate Client Group Finance to support mid-market corporate banking through loan structuring, delivery, monitoring, underwriting, and client financing advice. Candidates need an undergraduate deg
analyste d’entreprise, RBC amplifie 2027, Montréal / Business Analyst, RBC Amplify 2027, Montreal
Montréal, CAN
RBC is recruiting for its RBC Amplify 2027 Business Analyst opportunity. The supplied description provides no specific duties or candidate qualifications for the role.
RBC Group Consultant - Québec
Montréal, CAN
RBC is seeking a self-directed sales professional to acquire commercial sponsors and members for its group retirement and financial wellness programs. The role combines business development, sales activation, and partner
RBC Group Consultant - Québec
Québec, CAN
The employer is seeking a self-motivated sales professional to acquire commercial sponsors and members for group retirement savings and financial wellness programs. The role combines business development, sales activatio
Director, Corporate Client Group Finance
Toronto, CAN
RBC is seeking a Director for its mid-market Corporate Client Group Finance team to structure, deliver, and manage bank-debt solutions and support client relationship objectives. Candidates need a relevant undergraduate
analyste d’entreprise, RBC amplifie 2027, Montréal / Business Analyst, RBC Amplify 2027, Montreal- EN
Montréal, CAN
Senior Manager, Treasury Solutions – Corporate, Transaction Banking (ONE)
Ottawa, CAN
RBC Group Consultant - Québec
Montréal, CAN
Director, Corporate Client Group Finance
Toronto, CAN
analyste d’entreprise, RBC amplifie 2027, Montréal / Business Analyst, RBC Amplify 2027, Montreal
Montréal, CAN
RBC Group Consultant - Québec
Montréal, CAN
RBC Group Consultant - Québec
Québec, CAN
Director, Corporate Client Group Finance
Toronto, CAN