MDM/RDM Architect

About the Role

The organization is seeking an MDM/RDM Architect with strong expertise in Data Management and ETL services (ETL tools, SQL & SQL tools, job/process automation), on‑prem (Windows Server) and Azure cloud architecture (Data Lake), and technologies within the Healthcare Payer domain.

The candidate will work closely with the Enterprise Data Office (EDO) and stakeholders across the organization. Responsibilities include solution architecture for Enterprise Information Management (EIM) applications, data movement using ETL & SQL tools, Master Data Management (MDM), Enterprise Reference Data Management (ERDM), and related data services including data virtualization, API integration, and data governance processes. The role also supports provider data remediation and provider reporting (regulatory & audit).

Key Responsibilities

• Strong background in master data management using ETL tools (Informatica Multi Domain MDM, Informatica MDM SaaS, DataStage, SAS DMA, etc.), developing complex SQL packages/procedures, databases (Oracle, MS SQL Server), SQL tools (SSMS, Toad), NoSQL DB, managing production environments, enhancing existing ETL jobs, and job schedulers (Tidal, etc.)
• Understand and maintain data management architectural standards and principles.
• Architect and improve solutions for sourcing data from on‑prem and external sources.
• Expertise in ETL tools, SQL queries, on‑prem databases, Azure Data Lake, and service integration frameworks (cloud‑to‑cloud, cloud‑to‑on‑prem).
• Guide design sessions and prototype new data solutions with business users.
• Serve as first‑level escalation for complex technical issues.
• Act as Application Architect in strategic technology planning.
• Understand business requirements for data and information to support enterprise strategy.
• Evaluate new technologies, architectural strategies, and processes to meet business challenges.
• Monitor compliance with architectural standards and ensure technical integrity.
• Collaborate with Enterprise Architects to develop technology plans requiring multi‑domain integration.
• Solve complex problems with broad architectural implications.
• Participate in strategic planning for the information/data landscape and future‑state architectures for EIM (MDM & ERDM).

Required Qualifications

• 12+ years of relevant experience with tools such as Informatica IDQ/MDM, Informatica Multi Domain MDM, Informatica MDM SaaS, Azure Cloud, Data Lake, ADF, SAS DMA, DataStage, Oracle SQL Developer, SSMS, Tableau, Tidal, WinSCP, GIT, Visual Studio, HP Quality Center, Visual Studio Code, Acrobat Pro, Quest Directory Expert, SharePoint.
• BA/BS degree or equivalent experience; or 10+ years relevant experience with MS degree.
• Mandatory Healthcare Payer experience in MDM/RDM.
• Degree in Computer Science or related field preferred.
• TOGAF certification highly desired.
• Relevant domain certifications preferred.
• Experience in data analysis, data services, data publishing, and enrichment.