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.