Job Summary:
Seeking an experienced Master Data Management (MDM) Architect to design and implement enterprise-wide customer and company mastering solutions on a modern cloud data platform, preferably Databricks. The ideal candidate will have deep expertise in identity resolution, Customer 360 solutions, entity matching, hierarchy management, deduplication, and data governance. This role will partner with business and technology teams to establish a trusted master data foundation across multiple source systems, enabling unified views of customers, contacts, organizations, and relationships.
Key Responsibilities:
• Define enterprise MDM architecture and target-state master data models.
• Design Customer, Contact, and Company master domains.
• Establish canonical data models and golden record strategies.
• Define survivorship, matching, merging, and stewardship processes.
• Design scalable MDM patterns leveraging Databricks Lakehouse architecture.
• Design and implement company identity resolution frameworks.
• Develop deterministic and probabilistic matching approaches.
• Resolve duplicate customer, company, and contact records across multiple source systems.
• Define business rules for entity consolidation and golden record creation.
• Implement trust scoring, confidence scoring, and survivorship rules.
• Design parent-subsidiary-ultimate parent hierarchy models.
• Build hierarchy management capabilities using internal and external reference data.
• Support corporate structure navigation and relationship intelligence use cases.
• Model complex relationships between companies, contacts, and business entities.
• Define data quality frameworks and KPIs.
• Establish stewardship workflows and remediation processes.
• Design data governance operating models, standards, and controls.
• Define monitoring, auditability, lineage, and data certification practices.
• Create operational runbooks for ongoing MDM support.
• Collaborate with Data Engineering teams to implement MDM capabilities on Databricks.
• Design Delta-based master data structures and define data ingestion, enrichment, and mastering workflows.
• Leverage Unity Catalog and governance capabilities where applicable.
• Support performance optimization for large-scale mastering workloads.
• Evaluate and integrate third-party data enrichment providers and entity resolution solutions.
Required Qualifications:
• 10+ years of experience in data architecture and Master Data Management.
• Strong understanding of MDM concepts, golden record creation, data stewardship, data governance, data quality management, and reference data management.
• Hands-on experience designing Customer 360 solutions, enterprise customer masters, contact masters, and company masters.
• Experience with identity resolution and entity matching algorithms.
• Strong understanding of deduplication techniques, survivorship rules, fuzzy matching, probabilistic matching, and graph-based relationship modeling.
• Experience working with large-scale cloud data platforms.
• Strong SQL and data modeling skills.
• Experience collaborating with business stakeholders and data governance teams.
Preferred Qualifications:
• Experience with the Databricks Lakehouse Platform.
• Knowledge of Delta Lake, Unity Catalog, Databricks Workflows, and Spark.
• Experience implementing MDM capabilities without relying on traditional MDM products.
• Experience with Customer 360, Relationship Intelligence, or Enterprise Data Hub initiatives.
• Familiarity with CRM platforms such as Salesforce, HubSpot, Dynamics 365, Affinity, or similar platforms.
• Experience integrating third-party data enrichment providers.
