Business System Analyst

Capgemini; Toronto; On-site; CAD 80,000 - 120,000; Full time

Job summary

A leading company seeks a Business System Analyst in Toronto to enhance the efficiency of reference data management across trading and risk systems. Your expertise in Capital Markets and analytical skills will be valuable in ensuring data accuracy and compliance. You will engage with various teams to elicit requirements, document needs, and drive improvements in data governance practices. This role offers a chance to contribute significantly to the firm's digital transformation initiatives.

Qualifications

• 3+ years working with reference data domains in trading, risk or back office functions.
• Strong understanding of Securities data feed from Bloomberg, LSEG.
• Excellent Excel skills to perform data analysis and build summaries.

Responsibilities

• Elicit and document reference data requirements and system enhancements.
• Implement data validation checks and manage inventory of data issues.
• Prepare architectural and functional flows for systems dependencies.

Skills

Capital Markets Domain Expertise

SQL

Data Analysis

Data Governance

Analytical Skills

Communication Skills

Education

Bachelor's degree in Finance, Computer Science, Information Systems

Tools

Collibra

DataHub

APIs

Job description

Press Tab to Move to Skip to Content Link

Select how often (in days) to receive an alert :

Business System Analyst

Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you’d like, where you’ll be supported and inspired bya collaborative community of colleagues around the world, and where you’ll be able to reimagine what’s possible. Join us and help the world’s leading organizationsunlock the value of technology and build a more sustainable, more inclusive world.

Job Description

We're seeking a detail-oriented Business System Analyst with deep Capital Markets reference data expertise. In this role, you will be a 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.

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, DataHub) and metadata 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.

• Education :

Bachelor's degree in Finance, Computer Science, Information Systems or related field.

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.

Disclaimer

Capgemini is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity / expression, age, religion, disability, sexual orientation, genetics, veteran status, marital status or any other characteristic protected by law.

This is a general description of the Duties, Responsibilities and Qualifications required for this position. Physical, mental, sensory or environmental demands may be referenced in an attempt to communicate the manner in which this position traditionally is performed. Whenever necessary to provide individuals with disabilities an equal employment opportunity, Capgemini will consider reasonable accommodations that might involve varying job requirements and / or changing the way this job is performed, provided that such accommodations do not pose an undue hardship.

Capgemini is committed to providing reasonable accommodations during our recruitment process. If you need assistance or accommodation, please reach out to your recruiting contact.

Click the following link for more information on your rights as an Applicant http : / / www.capgemini.com / resources / equal-employment-opportunity-is-the-law .

Please be aware that Capgemini may capture your image (video or screenshot) during the interview process and that image may be used for verification, including during the hiring and onboarding process.

Applicants for employment in Canada must have valid work authorization that does not now and / or will not in the future require sponsorship of a visa for employment authorization in Canada by Capgemini.

Capgemini is a global business and technology transformation partner, helping organizations to accelerate their dual transition to a digital and sustainable world, while creating tangible impact for enterprises and society. It is a responsible and diverse group of 340,000 team members in more than 50 countries. With its strong over 55-year heritage, Capgemini is trusted by its clients to unlock the value of technology to address the entire breadth of their business needs. It delivers end-to-end services and solutions leveraging strengths from strategy and design to engineering, all fueled by its market leading capabilities in AI, generative AI, cloud and data, combined with its deep industry expertise and partner ecosystem.

Ref. code : 276756

Posted on : 26 Jun 2025

Experience Level : Experienced Professionals

Contract Type : Permanent

Location : Toronto, CA

Brand : Capgemini

Professional Community : Business Analysis