Senior Business Analyst / Data Analyst (Security Master)
Role Overview
Join the Product Team to own business logic, data quality, and product backlog for the enterprise Security Master.
The platform ingests reference data from multiple financial vendors and serves as a single source of truth for the firm.
Security Master data supports proposal, trade order management, portfolio management, and client reporting systems.
The role does not build technical data pipelines to downstream consumers.
Key Skills for This Role
Full Job Posting
Role overview
Join the Product Team to own business logic, data quality, and product backlog for the enterprise Security Master.
The platform ingests reference data from multiple financial vendors and serves as a single source of truth for the firm.
Security Master data supports proposal, trade order management, portfolio management, and client reporting systems.
The role does not build technical data pipelines to downstream consumers.
What you will do
- Define and document business requirements, data-mapping rules, and functional specifications for the Security Master platform.
- Create JIRA user stories and precise acceptance criteria; participate in sprint planning and grooming.
- Analyze, normalize, and reconcile vendor reference data across equities, fixed income, mutual funds, ETFs, and alternatives.
- Establish golden-copy rules, survivorship logic, and data-quality metrics to identify and resolve anomalies.
- Connect engineering teams, external data vendors, and downstream product owners to align data models with business needs.
- Lead UAT for Security Master enhancements and verify changes against downstream requirements.
Required qualifications
- Bachelor’s degree in Finance or an IT-related field.
- 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 symbology such as ISIN, CUSIP, SEDOL, and ticker.
- Proficiency in SQL and Python for analysis, profiling, and complex database queries; advanced Microsoft Office proficiency for documentation and reporting.
- Strong familiarity with security-data workflows for proposal generation, order execution or trading, and portfolio management.
- Exceptional analytical skills and a proven record resolving complex discrepancies across multiple vendors.
Nice to have
- Working knowledge of Python, PySpark, Microsoft Azure, and Azure Synapse for cloud data analysis is nice to have.
Team and organization
The role is part of the Technology & Innovation Division and its technology group.
The team develops and maintains solutions for clients and colleagues.
Rewards and development
- The employer describes a total rewards program with bonuses, flexible benefits, competitive compensation, commissions, and stock where applicable.
- The posting mentions coaching, development opportunities, collaborative work, challenging assignments, and increasing accountability.
Employment details
Employment type is listed as full time and job type as regular.
The listed work week is 37.5 hours.
The posting identifies this as an existing vacancy.
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
RBC Group Consultant - Québec
Montréal, CAN
RBC is seeking a self-motivated sales professional to acquire business sponsors and members for its Group Advantage retirement savings and financial wellness programs. The role combines business development, sales activa
Director, Corporate Client Group Finance
Toronto, CAN
RBC is seeking a Director to support mid-market corporate banking through loan structuring, delivery, and management. The role requires a business-related undergraduate degree, strong financial analysis and modeling skil
Senior Manager, Treasury Solutions – Corporate, Transaction Banking (ONE)
Ottawa, CAN
RBC is seeking a Senior Manager to advise corporate clients on cash management solutions and grow revenue across a complex client portfolio. Candidates need at least five years of commercial or corporate banking sales ex
Senior Manager, Treasury Solutions – Corporate, Transaction Banking (ONE)
Ottawa, CAN
RBC is seeking a Senior Manager to advise corporate clients on cash management solutions and grow revenue across a portfolio. The role includes client onboarding and adoption of digital solutions, relationship developmen
Associate Portfolio Manager
Toronto, CAN
RBC is seeking an Associate Portfolio Manager to support investment counsellors serving high-net-worth individuals, trusts, and charitable foundations. The role involves building and monitoring customized portfolios and
RBC Group Consultant - Québec
Montréal, CAN
RBC is seeking a mobile sales consultant for current and upcoming opportunities across Québec, selling group retirement savings and financial wellness programs to businesses and their members. The role focuses on busines
RBC Group Consultant - Québec
Montréal, CAN
RBC is seeking a bilingual sales consultant to grow its Group Advantage retirement savings and financial wellness business with commercial and corporate clients. The role focuses on business development, sales activation
Senior Manager, Treasury Solutions – Corporate, Transaction Banking (ONE)
Ottawa, CAN
RBC is seeking a senior treasury solutions professional to grow relationships and revenue across a portfolio of corporate clients. The role advises clients on cash management, leads onboarding and adoption of digital sol
RBC Group Consultant - Québec
Montréal, CAN
Director, Corporate Client Group Finance
Toronto, CAN
Senior Manager, Treasury Solutions – Corporate, Transaction Banking (ONE)
Ottawa, CAN
Senior Manager, Treasury Solutions – Corporate, Transaction Banking (ONE)
Ottawa, CAN
Associate Portfolio Manager
Toronto, CAN
RBC Group Consultant - Québec
Montréal, CAN
RBC Group Consultant - Québec
Montréal, CAN
Senior Manager, Treasury Solutions – Corporate, Transaction Banking (ONE)
Ottawa, CAN