Senior MDM Architect: Build Custom Customer Master Hub

Insight Global; United States; Remote; USD 150,000 - 230,000; Full time

Job summary

Insight Global is seeking a Senior MDM Architect to design and build a custom, warehouse-native Customer Master Data Hub from the ground up. This hands-on role focuses on data modeling, entity resolution, and SQL-based logic using Snowflake, PostgreSQL, and dbt.

You will implement survivorship rules, merge/unmerge processes, and lineage tracking while building robust data pipelines for large-scale datasets. Strong SQL and data modeling expertise are required for success.

Qualifications

• Experience in designing and implementing MDM architecture and data models.
• Hands-on proficiency with entity resolution, record linkage, and probabilistic matching.
• Experience defining survivorship rules and golden records for master data.
• Strong SQL skills including advanced features and performance tuning.
• Proficiency with Snowflake, PostgreSQL, and dbt for data pipelines.

Responsibilities

• Design and implement customer/party master data models.
• Build entity resolution, record matching, and identity resolution frameworks.
• Develop probabilistic matching, survivorship rules, and merge/unmerge processes.
• Create crosswalks, lineage tracking, and golden record strategies.
• Model customer hierarchies and relationships.
• Write and optimize advanced SQL for large-scale datasets.
• Implement data pipelines and testing using dbt.

Skills

MDM architecture & data modeling

entity resolution

probabilistic matching

survivorship rules

Snowflake

PostgreSQL

dbt

custom MDM solutions

SQL performance tuning

Tools

CTEs

MERGE operations

window functions

Job description

Insight Global is seeking a Senior MDM Architect to design and build a custom, warehouse-native Customer Master Data Hub from the ground up. This hands-on role focuses on data modeling, entity resolution, and SQL-based logic using Snowflake, PostgreSQL, and dbt.

You will implement survivorship rules, merge/unmerge processes, and lineage tracking while building robust data pipelines for large-scale datasets. Strong SQL and data modeling expertise are required for success.