Senior Business Analyst / Data Analyst (Security Master)
Role Overview
Own business logic, data quality, and product backlog for the enterprise Security Master.
The platform ingests reference data from financial vendors and supports proposal, trading, portfolio management, and client reporting applications.
The role does not build technical data pipelines for downstream consumers.
Key Skills for This Role
Full Job Posting
Role overview
Own business logic, data quality, and product backlog for the enterprise Security Master.
The platform ingests reference data from financial vendors and supports proposal, trading, portfolio management, and client reporting applications.
The role does not build technical data pipelines for downstream consumers.
Responsibilities
- Define and document business requirements, data mapping rules, and functional specifications.
- Create JIRA user stories with acceptance criteria and participate in sprint planning and grooming.
- Analyze, normalize, and reconcile vendor data covering equities, fixed income, mutual funds, ETFs, and alternatives.
- Establish golden copy rules, survivorship logic, and data quality metrics.
- Coordinate with engineering, vendors, and downstream product owners on data models.
- Lead UAT and validate enhancements against downstream data requirements.
Required qualifications
- Bachelor's degree in Finance, IT, or a related field.
- 5+ years as a Business Analyst, Data Analyst, or Product Owner within Wealth Management, Asset Management, or Capital Markets.
- Deep understanding of security reference data, corporate actions, and ISIN, CUSIP, SEDOL, and ticker symbology.
- Proficiency in SQL and Python for 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 demonstrated resolution of complex discrepancies across vendors.
Preferred skills
- Working knowledge of Python, PySpark, Microsoft Azure, and Azure Synapse for cloud data analysis.
Benefits and work environment
- The posting describes a total rewards program, flexible benefits, development support, and a collaborative team environment.
Compensation
- The posting describes competitive compensation and possible bonuses, commissions, and stock, but gives no amount or pay cadence.
Schedule and employment
- Full-time, regular role with 37.5 work hours per week.
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 mobile sales consultant to acquire commercial and corporate sponsors and members for its Group Advantage retirement savings and financial wellness programs. Applicants need proven sales success, prospect
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
Senior Manager, Treasury Solutions – Corporate, Transaction Banking (ONE)
Ottawa, CAN
RBC is seeking a Senior Manager to grow relationships and revenue across a portfolio of corporate clients through tailored cash management solutions. The role leads client advice, onboarding and adoption of digital solut
Operations Analyst, Production Support
Toronto, CAN
RBC is seeking an Operations Analyst to monitor and support production applications across multiple platforms in a 24/7/365 environment. The role requires an undergraduate degree with an IT background, change management
Director, Corporate Client Group Finance
Toronto, CAN
RBC is seeking a Director, Corporate Client Group Finance to support mid-market corporate banking through loan structuring, credit analysis, transaction delivery, and client-related advice. Applicants need a relevant und
Senior Manager, Treasury Solutions – Corporate, Transaction Banking (ONE)
Ottawa, CAN
RBC is seeking a Senior Manager to grow corporate client relationships and revenue through cash management solutions. The role leads client onboarding and adoption, delivers tailored advice, and requires 5+ years of comm
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. The role emphasizes prospecting, relationship building, and sa
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
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
Operations Analyst, Production Support
Toronto, CAN
Director, Corporate Client Group Finance
Toronto, 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