Senior Lead EDM Engineer

Key Responsibilities
Security Master and EDM Engineering
Assess the current Security Master architecture, workflows, data model, business rules, and operational processes.
Design, develop, configure, and maintain EDM workflows supporting the ingestion, transformation, mastering, enrichment, validation, and publication of security-reference data.
Work with EDM components and configurations for data loading, workflow orchestration, matching, mastering, validation, exception management, and downstream distribution.
Build and optimize match/merge logic, including exact, fuzzy, and rule-based matching across multiple source systems.
Define and maintain survivorship and source-precedence rules to create trusted golden records.
Configure business validations, data-quality checks, exception queues, and remediation workflows.
Support security mastering across asset classes such as:
Equities
Fixed income and debt instruments
Listed and OTC derivatives
Funds
Foreign exchange and money-market instruments
Other relevant financial products
Manage identifiers and cross-references, including ISIN, CUSIP, SEDOL, ticker, exchange codes, vendor identifiers, and internal security IDs.
Support reference-data attributes such as issuer, instrument classification, currency, exchange, country, maturity, coupon, corporate hierarchy, and lifecycle status.
Ensure lineage, auditability, traceability, and controlled publication of mastered data.
SQL, ETL, and Data Integration
Develop, optimize, and maintain complex SQL queries, stored procedures, views, functions, and data transformations used by EDM workflows.
Perform SQL-based data profiling, reconciliation, enrichment, deduplication, and exception analysis.
Build and support ETL pipelines for loading data from vendors, internal applications, data warehouses, data lakes, and operational systems.
Create source-to-target mappings and transformation rules for security-reference-data feeds.
Optimize query performance, indexing strategies, batch processing, and high-volume data loads.
Troubleshoot failed loads, workflow errors, data discrepancies, and performance bottlenecks.
Support inbound and outbound integrations using files, databases, APIs, messaging platforms, and other enterprise integration mechanisms.
Work with market- and reference-data feeds from providers such as Bloomberg, ICE, Refinitiv/LSEG, and other relevant sources, where applicable.
Develop reconciliation controls to confirm completeness, accuracy, timeliness, and consistency across upstream and downstream systems.
Required Technical Skills
Significant hands-on experience with IHS Markit EDM / Markit EDM and/or Gresham EDM.
Strong experience implementing, enhancing, or supporting a Security Master or financial-instrument reference-data platform.
Expert-level SQL development skills, preferably in Microsoft SQL Server and T-SQL, or an equivalent relational database environment.

Work arrangement
No