Business System Analyst (Reference Data)

Iris Software Inc.; Toronto; Hybrid; CAD 80,000 - 110,000; Full time

Job summary

A leading Canadian financial services company is hiring a Business System Analyst to manage and analyze critical reference data for trading and risk systems. This role requires expertise in capital markets, data governance, and strong communication to liaise among technical teams and stakeholders. The analyst will ensure data quality and support system testing while translating business needs into practical specifications.

Qualifications

• 3+ years in reference data domains for trading, risk, or back office.
• Strong understanding of securities data feeds and asset classes.
• Proficient in SQL and data modeling, familiar with APIs and data governance.

Responsibilities

• Elicit and document reference data requirements from various teams.
• Implement data validation checks and manage inventory of data issues.
• Produce status reports and updates for senior management.

Skills

Detail Oriented

Problem Solving

Stakeholder Management

Data Analysis

Tools

SQL

Excel

Data Governance Platforms

Job description

Iris’s client, one of the Top 5 Bank in Canada is looking to hire a Business System Analyst (Reference Data) for a long term contract opportunity.

Our Client is a Canada multinational financial services company and the largest bank in Canada by market capitalization. The bank serves over 17 million clients and has more than 89,000 employees worldwide. Bank is serving individual consumers, small and middle market businesses and large corporations with a full range of banking, investing, asset management and other financial and risk-management products and services.

Position : Business System Analyst (Reference Data)

Location : Toronto, ON (Hybrid)

Duration : Long Term

About the Role

• We’re seeking a detail oriented Business System Analyst with deep Capital Markets reference data expertise. In this role, you will partner with front office, data governance and technology teams to define, source, curate and deliver critical reference data (e.g. instrument identifiers, legal entity data, product hierarchies) for trading, risk, compliance and reporting systems. Your combination of domain knowledge and technical acumen will ensure our reference data pipeline is accurate, complete and scalable.

Key Responsibilities

Business Analysis & Requirements Gathering :

• Work with Operations, Support, FO and BO (Risk, Finance, Compliance) IT teams to elicit and document reference data requirements and system enhancements.
• Map and define reference data elements (e.g. ISIN, CUSIP, SEDOL, LEI, product classifications) across asset classes (equities, fixed income, derivatives).

Data Triage & Curation :

• Identify and evaluate external vendors, market data feeds and proprietary sources for reference data.
• Implement data validation checks, exception handling processes and reconciliation routines.
• Manage inventory of data issues, triage issues, work out tactical and strategic remediation with various teams
• Solution Design & Implementation :
• Translate business needs into functional and technical specifications for IT delivery.
• Prepare architectural and functional flows clearly depicting systems dependencies.
• Support system testing : develop test scripts, execute UAT, and track defects through resolution.
• Data Governance & Quality :
• Monitor key data quality indicators and drive continuous improvements in remediation workflows.
• Stakeholder Communication & Reporting :
• Produce clear status reports, data catalog updates and impact assessments for senior management.
• Conduct training sessions and prepare user guides on reference data standards and tools.

Required Qualifications

• Capital Markets Domain Expertise :
• 3+ years working with reference data domains in trading, risk or back office functions.
• Strong understanding of Securities data feed from Bloomberg, LSEG (Reuters)
• Strong understanding of various Asset classes and important attributes associated with each asset classes
• Good understanding of instrument identifiers (ISIN, CUSIP, FIGI, RIC), entity identifiers (LEI) and product taxonomy

Technical Skills :

• Proficient in SQL and relational data modeling concepts
• Familiarity with using APIs and JSON, XML structures
• Familiarity with MDM and data governance platforms (e.g. Collibra, Data Hub) and meta data management best practices.
• Excellent Excel skills to perform various data analysis, triage recons and build summaries

Analytical & Communication Skills :

• Strong problem solving mindset and keen attention to detail.
• Excellent stakeholder management skills : able to translate between business and technical audiences.