Senior Lead EDM Engineer

Crisil; Mumbai; On-site; INR 1,800,000 - 3,200,000; Full time

Job summary

Crisil seeks an experienced professional to architect and optimize Security Master platforms and EDM workflows in Mumbai. The role involves designing data models, survivorship rules, and robust data-quality processes across asset classes, while ensuring lineage and auditability of mastered data.

You will develop and optimize SQL-based transformations, load data from vendors and internal systems, and support integrations with market data feeds from Bloomberg, ICE, Refinitiv/LSEG, and others.

Qualifications

• Significant hands-on experience with IHS Markit EDM / Markit EDM and/or Gresham EDM.
• 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.

Responsibilities

• Assess the current Security Master architecture, workflows, data model, business rules, and operational processes.
• Design, develop, configure, and maintain EDM workflows supporting ingestion, transformation, mastering, enrichment, validation, and publication of security-reference data.
• Work with EDM components 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, Derivatives, Funds, FX and money-market instruments.

Skills

Security Master platform

SQL development

SQL Server / T-SQL

Tools

IHS Markit EDM

Markit EDM

Gresham EDM

Job description

Key Responsibilities

• 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.