JOB DETAILS:

Position: MDM Architect (Databricks)

Location: Remote

Type of Employment: 12+ Months Contract

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

Key Responsibilities

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 Modelling

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

Required Qualifications

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.

Preferred Qualifications:

Experience with Databricks Lakehouse Platform.
Knowledge of:

Delta Lake
Unity Catalog
Databricks Workflows
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
Investor platforms

Experience integrating third-party enrichment providers

MDM Architect (Databricks)

Key skills

About this role