Capital Markets Data SME - Transaction, Reference & Market Data
$153k - $197k per yearCapco
Design the data foundation that connects trades, instruments, and markets.
The Role
We’re 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. You’ll 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, you’ll 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 You’ll 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 We’re 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
We’re committed to making our recruitment process accessible and straightforward for everyone. If you need any adjustments at any stage, just let us know – we’ll be happy to help. We value each person’s 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.
Pay Transparency
The salary range for this position is listed below. Additionally, this position may also be eligible to receive an annual discretionary/variable bonus payment.
Capco is committed to providing fair and equitable compensation to our people. Our compensation policies and salary ranges are designed to allow our people to progress through the salary range as they demonstrate strong performance and develop in their role over time. The base pay offered to selected candidates will be within the salary range and the placement will vary based upon a variety of factors, including, but not limited to job-related knowledge, skills, experience and internal equity.
Canada Pay Transparency
$153,000—$197,000 CAD
$95k - $145k per year
Senior Data Analyst (Capital Markets) Position Description This role is Hybrid and requires you to be in our Toronto, ON (minimum) 1 time per week. CGI is seeking a Senior Data Analyst to join our Financial Services team in the Greater Toronto Area. This role is ideal...Data$153k - $197k per year
...Own a critical data capability at the heart of trading, operations... ...re looking for an experienced reference data professional to take... ...introduction of new instruments, markets, and data capabilities. What... ...security master functions within capital markets, with a track record...DataInternshipImmediate start$85 per hour
Our client, a Top 5 Canadian Bank, is looking to hire a Data Lead - Capital Markets Data Governance for a 12-month contract. This is a hybrid role requiring in-office presence at their downtown Toronto location (2-3 days per week). Must-Have Skills ~3-5 years of experience...DataContract workWork at office2 days per week3 days per week$90.5k - $136k per year
...unique, industry-focused practice, and our Capital Markets consulting practice is a critical part... ...), risk management, digital assets, data, technology, regulatory compliance, market... ...assurance, consulting, tax, strategy and transactions. Fueled by sector insights, a globally connected...DataWork at officeWeekend work$104.5k - $325k per year
...Location: Toronto We are seeking a Debt Capital Markets Counsel to join our Corporate and... ...centres on bond issuances, capital-raising transactions, and covenant structuring , with a... ...about you and how it is used, our full data privacy notice is available here. Employment...DataFull timeFlexible hours- ...work closely with business and operational stakeholders across Capital Markets at Sia to translate strategic priorities into structured... ...particularly in areas such as client onboarding, lending, payments, transaction services, or related functions. Experience with Agile,...Full timeContract workWork at office
$70k - $150k per year
...evaluates the impact of new and emerging technology and technology risk on the organization’s processes and control environment. Utilizes data analytics in advisory engagements to improve quality and efficiencies. Develops an awareness of business strategies, policies and...DataPermanent employmentFull timeContract workPart time$80k - $130k per year
Sr. Business System Analyst (Capital market/Data) Position Description This role is hybrid and requires you to be at our downtown Toronto... ...e.g. Lending product, Facility, Security, Security Finance Transaction(SFT), and Derivative, etc. . Picking up new concept...DataWork at officeShift workAfternoon shiftEarly shift- ...Our client, a leading provider of capital markets services, is looking for a highly motivated full-time Institutional licensed sales... ...date with all regulatory rules and activities as they relate to transactions and ensuring that client interactions are accurately documented...Full timeManual labor
- ...! The Work The Senior Analyst, Capital Markets & Financial Operations is a key member of... ...Manage settlements for security transactions, including swap payments and receipts.... ...agreements and market conventions. Validate data input in the system against contractual...DataHourly payDaily paidPermanent employmentFull timeInternshipWork at office
$40 per hour
...banking client in Canada is looking to hire Business Analyst (Capital markets operations) x 2 positions for their team with a contract for 12... ...adhering to strict deadlines and changing volumes. Research, gather data, analyze, lead and/or support as required on projects to...DataContract workTemporary workWork at office- ...Responsibilities : Providing subject matter expertise within Private Markets Solutions at MUFG Investor Services, supporting Private... ...including account structure setup, investor allocations, capital activity workflows, data and reporting within the platform. Provide subject...DataInternshipWorldwide
$180k - $220k per year
...offices around the world combine experience across technology data sciences consulting and customer obsession to accelerate our clients... ...Role Overview The Java Lead will be part of the Capital Markets Technology Middle Office organization responsible for designing...DataFull timeWork at office$115k - $165k per year
Product Management – FX Trading & Capital Markets Position Description CGI is seeking a full-time Product Manager to join our FX Trading... ...exchange assets, FX Options, full front-to-back-office transaction processing, and regulatory requirements. - Strong technical...Full timeWork at office2 days per week- ...Today our strategy and management capabilities are augmented by data science, enhanced by creativity and driven by responsibility.... ...Sia Partners is seeking a high-performing Program Manager – Capital Markets Transformation to support complex regulatory and strategic transformation...DataFull timeContract workWork at officeWorldwide
$100 - $120 per hour
...General Catalyst , Peter Thiel , Adam D'Angelo , Larry Summers , and Jack Dorsey . Position: Legal Expert — Corporate & Capital Markets (Project Donna) Type: Contract Compensation: $100–$120/hour Location: Remote Commitment: ~24...Remote jobContract workSummer work$100 per hour
Our client, a leading financial institution, is seeking a Senior Change Manager - OSFI E-21 (Capital Markets) for a 6-month contract (with high potential for extension). This is a hybrid position based at 81 Bay Street, 31st Floor, with in-office work required 2 days per week...Contract workWork at office2 days per week- ...Sias Capital Markets (Corporate and Investment Banking) practice is seeking a Consultant with deep... ...front-to-back trade flows to assess data standardization issues manual touchpoints... ...Knowledge of regulations and securities transactions to help conduct requirement analysis facilitate...DataFull timeWork at officeRemote work
- ...Job Description What is the opportunity? RBC Capital Markets is seeking an experienced and highly motivated Project Manager - Capital... ...of the fundamentals of Capital Markets trading and the transaction lifecycle Minimum of 5–7 years of experience in project management...Long term contractFull timeWork at office
$102.47k - $147.84k per year
...jobs transfer modes and synchronization rules. * Experience defining data mappings attribute transformations lifecycle synchronization validation and reconciliation with AIG administration transaction monitoring job management troubleshooting and operational support. *...DataFull timeRelocation$90 - $130 per hour
...based in Canada. Pay: $90$130/hr Role Title: Corporate Transactions Attorney Role Type: Contractor Location: Remote We are... ...consistency. # Collaborate with product and research teams to refine data guidelines and best practices for AI-driven contract review...DataHourly payFull timeContract workPart timeFor contractorsRemote work- ...define and review requirements Provide Capital Markets Operations subject matter expertise as... ...fundamentals of Capital Markets trading and the transaction lifecycle Strong knowledge of... ...Job Skills Agile Methodology, Business Data Analysis, Business Process Modeling,...DataLong term contractFull timeWork at officeFlexible hours
- ...our portfolio companies with capital and technical capability.... ...investors, including DDQ responses, reference calls, and onsite visits,... ...analysis, company presentations), transaction structuring, diligence... ...the AI Lab to stay ahead of market shifts and firm-wide innovations...DataLong term contractFull timeInternshipWork at officeImmediate startRemote workShift work
$90 - $130 per hour
...Canada. Pay: $90$130/hr Job Title: Transactional Attorney Job Type: Contractor... ...with product and research teams to refine data guidelines and best practices for AI-driven... ...-House experience focused on technology transactions particularly negotiating MSAs NDAs ISDAs...DataHourly payFull timeContract workPart timeFor contractorsRemote work$65 per hour
Our client, a Top 5 Canadian Bank, is looking to hire an Risk Analyst (Capital Markets) for a 6-month contract. This is a hybrid role requiring in-office presence at their downtown Toronto location (2-3 days per week). Must-Have Skills ~ 2+ years of experience in Risk...Contract workManual laborWork at office2 days per week3 days per week- ...is to connect consumers with the world’s leading brands through data-driven content and technology. Headquartered in South Florida... ...high-performers. MUST HAVE: Proven experience in digital marketing, performance marketing, or the leadgen industry Building adtech...DataFull timeRemote work
$153k - $197k per year
...Own the market data ecosystem that powers trading, risk, and valuation . The Role We’re looking for an experienced Market Data... ...re Looking For ~10+ years of experience in market data within Capital Markets, gained within a buy-side, sell-side, or market-data vendor...DataInternshipImmediate start- ...our portfolio companies with capital and technical capability.... ...with full ownership of virtual data rooms (VDRs), private placement... ...inquiries, and conduct comprehensive market mapping to identify and... ...including data room administration, transaction documentation support, and...DataFull timeInternshipWork at officeImmediate startRemote workShift work
$65 per hour
...banks, is looking for a Business Systems Analyst to join their Capital Markets Technology team. This role will support regulatory trade reporting... ...application enhancements. o Create user stories, BRDs, FRDs, data mappings, and acceptance criteria. o Collaborate with business...DataPermanent employmentContract work1 day per week- ...Ventures, Sequoia, Salesforce Ventures, DST Global, and Lone Pine Capital, Airwallex is leading the charge in building the global payments... ...sounds like you, let’s build what’s next. About the team The SME & Growth Business team at Airwallex is a passionate group of...Long term contractFull timeWork at officeWorldwide3 days per week
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Capital Markets Data SME - Transaction, Reference & Market Data. Be the first to apply!
