MDM Architect

Programmers.io; United States; On-site; USD 140,000 - 200,000; Full time

Job summary

Programmers.io is seeking an experienced MDM Architect to lead enterprise data governance and master data management initiatives in the United States. You will define the target architecture, data domains, source-of-truth strategy and CRUD processes across key entities.

Responsibilities include assessing maturity, validating vision, prioritizing domains, and designing an architecture that supports scalable data quality, matching/merging and cloud-based ETL pipelines using SQL, Python and Spark.

Qualifications

• Experience as an MDM architect and MDM data modeller.
• Implemented MDM tools such as Informatica, Reltio, Profisee or Semarchy xDM or custom builds.
• Strong understanding of data entities and a party model in complex domains.
• Knowledge of data quality, match-merge modelling and survivorship rules.
• Proficient in SQL, ETL techniques, cloud services (AWS/Azure), Python, PySpark.

Responsibilities

• Assess current data, integration and governance maturity.
• Validate the business vision and acquisition-readiness drivers.
• Define MDM architecture and phased implementation roadmap.
• Identify Master authoring system for all enterprise entities.
• Define CRUD processes for all enterprise entities.
• Align architecture with key uses cases and target data models.
• Evaluate entity resolution (matching/merging/survivorship) for master entities.
• Define buy vs build version of MDM.

Skills

MDM architect

MDM data modeler

SQL

Python

PySpark

ETL

Cloud services (AWS/Azure)

Data governance

Tools

Informatica

Reltio

Profisee

Semarchy xDM

Job description

Assess current data, integration and governance maturity Validate the business vision and acquisition-readiness drivers Confirm scope, success criteria and known constraints Identify priority domains and enterprise entities Assess mastering and source-of-truth needs Analyze key Source & Consumptions systems by in-scope data domain Identify key Users and processes that will consume data from MDM Identify Master authoring system (system where new record is created) for all enterprise entities Define CRUD processes for all enterprise entities Define MDM architecture Define systems/use cases/processes that will ingest data from MDM as a feedback Align the conceptual architecture with key uses cases Define Target MDM logical architecture Evaluate Entity resolution process (Matching/merging/survivorship) for Master entities Define Buy Vs Build version of MDM (comparison metrics) Define Physical architecture with Tech stack options Define phased implementation roadmap

Required Skills

• Strong experience as an MDM architect and MDM Data Modeler
• Implemented MDM tools like Informatica/ Reltio/ Profesee/ Semarchy xDM etc. Or custom build MDM.
• Strong understanding of Data entities like Party model in Insurance domain
• Understanding of data quality and Match-merge modelling by entities.
• Strong in SQL, ETL tech stack, Cloud services (AWS /Azure), Python, Pyspark.