Capital Markets Data SME – Transaction, Reference & Market Data

Design the data foundation that connects trades instruments and markets.

The Role

Were looking for an experienced Capital Markets Data SME to design and shape a scalable Transaction Data Warehouse and analytics platform that brings together transaction data Security Master Reference Data and Market Data.

This is a senior hands-on SME role with significant ownership across solution design data modelling enrichment and analytics. Youll help create a trusted data foundation that enables consolidated views of trades securities issuers pricing and market information across a range of business and analytical use cases.

Working closely with Trading Operations Analytics Product and Engineering teams youll translate complex business and data requirements into scalable solutions strengthen data quality and controls and shape how high-volume financial data is organized enriched and consumed.

What Youll Do

• Design and shape a scalable Transaction Data Warehouse supporting analytics reporting and downstream consumption across Capital Markets use cases.
• Integrate and enrich transaction and trade data with Security Master Reference Data and Market Data including effective-dated and historical datasets.
• Define robust data models and relationships across transactions instruments securities issuers accounts pricing and market data including instrument resolution using ISIN CUSIP SEDOL FIGI tickers and internal identifiers.
• Design efficient ingestion transformation enrichment and query patterns using QuestDB columnar or time-series databases and other technologies suited to high-volume financial datasets.
• Establish data-quality reconciliation validation lineage and exception-management controls while partnering with business and technology teams to deliver trusted analytics-ready data solutions.

What Were Looking For

• 7 years of relevant experience within Capital Markets trading data financial data or related data-focused roles including hands-on experience with transaction or trade data and data warehouse architectures.
• In-depth understanding of Security Master and Reference Data including instrument identifiers security mappings instrument resolution and the enrichment of transactional datasets.
• Good understanding of Market Data including pricing historical and time-series data and the use of market information within analytical data models.
• Advanced SQL database data-modelling and data-analysis skills with experience joining reconciling and analysing high-volume financial datasets.
• Experience with columnar or time-series database technologies and building analytics-ready data models; QuestDB experience is highly desirable but not essential.

Bonus Points For

• Python and data-engineering framework experience.
• Experience with cloud-based data platforms.
• Knowledge of market and reference-data providers such as Bloomberg ICE S&P or LSEG.
• Experience with EDM or Security Master platforms such as GoldenSource Markit EDM or Bloomberg Enterprise Data.
• Exposure to real-time or near-real-time transaction analytics.

Why Join Capco

• Deliver high-impact technology solutions for Tier 1 financial institutions.
• Work in a collaborative flat and entrepreneurial consulting culture.
• Access continuous learning training and industry certifications.
• Be part of a team shaping the future of digital financial services.
• Help shape the future of digital transformation across FS & Energy.

Benefits

We offer a competitive people-first benefits package designed to support every aspect of your life:

• Comprehensive Benefits Coverage 100% company-paid health life and disability insurance effective from Day 1 of employment.
• Retirement Savings Program Registered Retirement Savings Plan (RRSP) with the option of receiving a matching employer contribution.
• Virtual Health Care & Support Company-paid virtual health care and Employee & Family Assistance Program (EFAP) available to employees and their dependents/partners.
• Family & Wellness Support Parental Leave Top-Up a New Parent Gift and fitness reimbursement to support health and well-being.
• Career Development A Business Coach from Day 1 providing personalized one-on-one coaching to support career growth accelerate development and help you achieve your professional goals at Capco.

Inclusion at Capco

Were committed to making our recruitment process accessible and straightforward for everyone. If you need any adjustments at any stage just let us know well be happy to help. We value each persons unique perspective and contribution. At Capco we believe that being yourself is your greatest strength. Our #BeYourselfAtWork culture encourages individuality and collaboration a mindset that shapes how we work with clients and each other every day.

Use of Artificial Intelligence in Talent Acquisition

At Capco we use artificial intelligence (AI) tools to support and enhance several parts of talent acquisition. This includes using AI-enabled features within LinkedIn to help source potential candidates speeding up routine recruitment communications such as emails and creating compelling and brand-aligned job postings that accurately reflect role requirements and AI-scheduling applications to improve the efficiency of interview coordination.

AI is used as a support tool only. All hiring decisions are made by talent acquisition and hiring teams.

Why This Role Is Open

We are currently hiring for this role due to an existing or newly created vacancy within our organization. This position is open as part of our ongoing business needs and we are actively reviewing applications to fill this role with a qualified candidate who can make an immediate impact.