Tech & Engineering
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