MDM/RDM Architect

Job Description

A healthcare payor client is seeking an MDM/RDM Architect to optimize and scale their Master Data Management Solutions that support complex data integration initiatives. As the MDM Architect you will serve at the first escalation point for defining how the member, provider and reference data is mastered across the enterprise. This is a high-impact, strategic role helping drive data accuracy, interoperability and better business outcomes. Key Responsibilities include:

Architecture & Solution Design (40%)

 • Design and enhance MDM/Reference Data architecture supporting enterprise data initiatives

 • Define and implement: Match & merge logic, Survivorship rules, Golden record frameworks

 • Establish and maintain data architecture standards and best practices

 • Translate business requirements into scalable data architecture solutions

 

Data Integration & Engineering Oversight (30%)

 • Design and guide data movement pipelines across:

  ○ On-prem systems (SQL Server, NoSQL, Oracle, etc.)

  ○ Azure cloud environment

 • Support ETL development, SQL processes, and job automation (Tidal)

 • Oversee integration of member and provider data into centralized MDM platform

Platform Optimization & Support (20%)

 • Ensure stability of production MDM and data integration processes

 • Serve as the technical escalation point for complex MDM/data issues

 • Identify and implement enhancements to improve data quality and system efficiency

Data Governance & Quality(10%)

 • Support creation and maintenance of golden records (member & provider)

 • Guide data quality, reconciliation, and integrity processes

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to [email protected] learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.

Skills and Requirements

• 10+ years of experience in data architecture /MDM solutions

 • 5+ years of recent experience in the healthcare sector

 • 9+ years creating golden records with Informatica, Reltio, Profisee or Semarchy or similar tools

 • Expertise in architecting and design/improving the solution in sourcing data from on prem multiple data sources as well as external sources

 • Expertise in SQL Queries NO SQL DB, managing production environment, making enhancements to existing production ETL jobs & deliverables

 • Expertise in implementing service integration frameworks for Data integration to Azure cloud, cloud to cloud, cloud to on-prem integration and services.

 • Experience with healthcare payer data, (member & provider data ideal) • Informatica MDM tool experience highly desired

 • Extensive healthcare data knowledge and advanced data modeling & data relationship concepts

 • Strong organization, time management and project management skills and multi-tasking abilities.

 • TOGAF Certification highly desired.

 • Experience with Azure Data Lake / Databricks

Experience evaluating or migrating between MDM platforms