MDM Lead Engineer

Micasa Global; New York (NY); Hybrid; USD 180,000 - 280,000; Full time

Job summary

Micasa Global is seeking a highly hands-on MDM Lead Engineer responsible for technical ownership of enterprise Master Data Management initiatives in a hybrid New York environment. You will leverage Semarchy xDM to design, implement, and optimize MDM solutions, perform data profiling and root-cause analysis, and guide onshore/offshore teams through production deployments.

The role requires 10+ years of experience, deep MDM expertise, strong SQL, data modeling, and a collaborative approach with

Qualifications

• 10+ years of relevant engineering/data experience.
• Strong hands-on Semarchy xDM experience.
• Deep Master Data Management expertise.
• Strong SQL, data profiling, and data analysis skills.
• Enterprise MDM implementation experience.
• Strong data engineering and production pipeline experience.
• Experience with modern data technologies (Snowflake, Azure, ADF, dbt, Fivetran, Python, APIs).
• Strong data modeling, governance, metadata, lineage, and stewardship.
• Strong technical leadership and stakeholder communication skills.
• Financial Services / Banking experience.
• MDM modernization or re-architecture experience.
• Experience integrating MDM with cloud data warehouses, operational systems, APIs, and analytical platforms.

Responsibilities

• Own MDM initiatives from requirements and data analysis through implementation and production support.
• Design and implement enterprise MDM solutions using Semarchy xDM.
• Develop and optimize match/merge, survivorship, golden records, hierarchies, workflows, and data-quality processes.
• Perform deep SQL, data profiling, and root-cause analysis.
• Analyze source data, business processes, and downstream data consumption.
• Review and guide data models, SQL, pipelines, architecture, implementation approaches, and code.
• Provide hands-on technical leadership to onshore and offshore engineering teams.
• Work closely with Product Owners, Data Stewards, architects, engineering teams, and senior technology leaders.
• Translate business requirements into scalable and maintainable technical solutions.
• Help modernize and improve existing MDM implementations and integrations.

Skills

Semarchy xDM

SQL

Data profiling

Data analysis

Production pipelines

Data governance

Stakeholder communication

Technical leadership

Tools

Snowflake

Azure

ADF

dbt

Fivetran

Python

APIs

Job description

Location: New York, NY

Work Model: Hybrid — 3 days onsite per week

Onsite Requirement: Must be able to work onsite from Day 1

Employment: Full-Time / FTE

We are looking for a highly hands‑on MDM Lead Engineer to take technical ownership of enterprise Master Data Management initiatives.

This is an ideal opportunity for someone with strong Semarchy xDM expertise who can go beyond platform configuration — someone who can analyze data, design MDM solutions, lead implementation, troubleshoot complex data‑quality issues, guide engineering teams, and drive initiatives through production with minimal oversight.

Responsibilities

• Own MDM initiatives from requirements and data analysis through implementation and production support
• Design and implement enterprise MDM solutions using Semarchy xDM
• Develop and optimize match/merge, survivorship, golden records, hierarchies, workflows, and data‑quality processes
• Perform deep SQL, data profiling, and root‑cause analysis
• Analyze source data, business processes, and downstream data consumption
• Review and guide data models, SQL, pipelines, architecture, implementation approaches, and code
• Provide hands‑on technical leadership to onshore and offshore engineering teams
• Work closely with Product Owners, Data Stewards, architects, engineering teams, and senior technology leaders
• Translate business requirements into scalable and maintainable technical solutions
• Help modernize and improve existing MDM implementations and integrations

Requirements

• 10+ years of relevant engineering/data experience
• Strong hands‑on Semarchy xDM experience
• Deep Master Data Management expertise
• Strong understanding of match/merge, survivorship, golden records, hierarchies, data quality, stewardship, and workflows
• Strong SQL, data profiling, and data analysis skills
• Enterprise MDM implementation experience
• Strong data engineering and production pipeline experience
• Experience with modern data technologies such as Snowflake, Azure, ADF, dbt, Fivetran, Python, APIs, or comparable technologies
• Strong data modeling, governance, metadata, lineage, and stewardship
• Strong technical leadership and stakeholder communication skills
• Financial Services / Banking experience
• Client, Customer, Organization, Contact, Account, or Party master data experience
• MDM modernization or re‑architecture experience
• Experience integrating MDM with cloud data warehouses, operational systems, APIs, and analytical platforms
• Interest in AI-native approaches to data quality, automation, and engineering productivity