Capital Markets Data SME – Transaction, Reference & Market Data

<p> </p> <p class="isSelectedEnd"></p> <p data-pm-slice="1 1 []"><strong>Design the data foundation that connects trades, instruments, and markets.</strong></p> <p class="isSelectedEnd"><strong>The Role</strong></p> <p>We’re looking for an experienced <strong>Capital Markets Data SME</strong> to design and shape a scalable Transaction Data Warehouse and analytics platform that brings together transaction data, Security Master, Reference Data, and Market Data.</p> <p>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.</p> <p>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.</p> <p class="isSelectedEnd"><strong>What You’ll Do</strong></p> <ul> <li>Design and shape a scalable Transaction Data Warehouse supporting analytics, reporting, and downstream consumption across Capital Markets use cases.</li> <li>Integrate and enrich transaction and trade data with Security Master, Reference Data, and Market Data, including effective-dated and historical datasets.</li> <li>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.</li> <li>Design efficient ingestion, transformation, enrichment, and query patterns using QuestDB, columnar or time-series databases, and other technologies suited to high-volume financial datasets.</li> <li>Establish data-quality, reconciliation, validation, lineage, and exception-management controls while partnering with business and technology teams to deliver trusted, analytics-ready data solutions.</li> </ul> <p class="isSelectedEnd"><strong>What We’re Looking For</strong></p> <ul> <li>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.</li> <li>In-depth understanding of Security Master and Reference Data, including instrument identifiers, security mappings, instrument resolution, and the enrichment of transactional datasets.</li> <li>Good understanding of Market Data, including pricing, historical and time-series data, and the use of market information within analytical data models.</li> <li>Advanced SQL, database, data-modelling, and data-analysis skills, with experience joining, reconciling, and analysing high-volume financial datasets.</li> <li>Experience with columnar or time-series database technologies and building analytics-ready data models; QuestDB experience is highly desirable but not essential.</li> </ul> <p class="isSelectedEnd"><strong>Bonus Points For</strong></p> <ul> <li>Python and data-engineering framework experience.</li> <li>Experience with cloud-based data platforms.</li> <li>Knowledge of market and reference-data providers such as Bloomberg, ICE, S&P, or LSEG.</li> <li>Experience with EDM or Security Master platforms such as GoldenSource, Markit EDM, or Bloomberg Enterprise Data.</li> <li>Exposure to real-time or near-real-time transaction analytics.</li> &l