Master Data Management (MDM) Architect

SunRay Enterprise Inc
United States
21 days ago
Apply on www.dice.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
10 years minimum
Working hours
Regular working hours
Job source

Tech stack

Data Architecture Data Cleansing Data Deduplication Information Engineering Data Governance Data Infrastructure Performance Tuning Reference Data Cloud Services Standard Sql Data Ingestion Data Management
+2 more
User Identification Databricks

Job description

We are 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 a unified view of customers, contacts, organizations, and relationships., Master Data Strategy & Architecture

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

Identity Resolution & Entity Matching

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

Company Hierarchy & Relationship Modeling

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

Data Governance & Data Quality

  • Define data quality framework and KPIs.
  • Establish stewardship workflows and remediation processes.
  • Design data governance operating model, standards, and controls.
  • Define monitoring, auditability, lineage, and data certification practices.
  • Create operational runbooks for ongoing MDM support.

Databricks & Data Engineering Collaboration

  • Work closely with Data Engineering teams to implement MDM capabilities on Databricks.
  • Design Delta-based master data structures.
  • Define data ingestion, enrichment, and mastering workflows.
  • Leverage Unity Catalog and governance capabilities where applicable.
  • Support performance optimization for large-scale mastering workloads.

Third-Party Data Enrichment

  • Evaluate and integrate external enrichment providers such as:
  • Dun & Bradstreet (D&B)
  • ZoomInfo
  • Similar entity resolution providers

Requirements

  • 10+ years of data architecture and master data management experience.
  • Strong understanding of:
  • Master Data Management concepts
  • Golden Record creation
  • Data Stewardship
  • Data Governance
  • Data Quality Management
  • Reference Data Management
  • Hands-on experience designing:
  • Customer 360 solutions
  • Enterprise customer master
  • Contact master
  • Company master
  • Experience with identity resolution and entity matching algorithms.
  • Strong understanding of:
  • Deduplication techniques
  • Survivorship rules
  • Fuzzy matching
  • Probabilistic matching
  • 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. *

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.dice.com
Prepare application

Good distractions

Loading talks and stories from around this role…