{bc}
indeed

Senior Business Analyst / Data Analyst (Security Master)

RBC
Toronto, CAN
Full-time
Senior
Onsite
Discovered 4 weeks ago
Business analysisData analysis and profilingSecurity reference dataSQLPythonMicrosoft Office

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.

Sarah M.James T.Maya R.

Trusted by over 500,000 job seekers on Base Career

Start Free Today

More from this employer

More jobs at RBC