Master Data Management; MDM Architect

Role

Master Data Management (MDM) Architect

Austin, TX (100% Onsite)

Long Term

• Excellent understanding of MDM principles, goals, and tools and how these relate to overall HHS data quality and cross-program data integrations.
• Responsible for development and implementation of new MDM capabilities using the Informatica application tool stack in IDMC.
• Works collaboratively with EIM program staff, with client’s Information Technology (IT) resources, and MDM business analysts to implement new program requirements for mastering critical agency data, identity resolution, trusted attribution, and governed reference data.
• Developing MDM solutions for healthcare provider and managed care member domains (using an Informatica tool stack).
• Developing extract/transform/load processes for HHS system data into MDM applications (using Oracle, Snowflake and Informatica tools).
• Developing, testing, and maintenance of enhancements/upgrades to MDM application layer(s).
• Working closely with EIM data architects, HHS subject matter experts, and HHS system data models to accurately represent as‑is and to‑be process models involving HHS master data.
• Operational responsibility for metadata loads.
• Planning and monitoring MDM/Metadata project lifecycle deployment using agile methods.
• Ensuring that the build and deployment of the MDM components are of high quality and comply client’s IT coding and security standards.

• Work with program areas and project sponsor to plan and execute multiple analytics projects asynchronously.
• Explain project findings and data limitations in simple, non-technical language to agency leadership and program staff.

• Develop and refine effective AI prompts and query strategies to retrieve and synthesize master data for complex data domains.
• Develop a library of standardized prompts and query templates for common reporting needs.
• Provide subject matter expertise on validating output from AI, particularly with respect to identifying and mitigating hallucinations.
• Ensure all data outputs adhere to agency reporting standards, data governance, and compliance regulations.
• Promote a data‑driven culture by enabling and empowering all staff to effectively utilize data and AI.
• Stay up to date on new AI and data analytics tools and techniques to continuously improve program competencies.

• Work closely with data engineering, IT, and Program teams to troubleshoot data‑related issues and address inconsistencies and mitigation strategies.
• Provide expert guidance to program staff on interpreting data trends and answering complex data questions.

• 8+ years of advanced experience in Informatica development and ETL (Extract, Transform, Load) solutions.
• 8+ years of experience applying Enterprise Information Management (EIM) best practices and methodologies.
• 8+ years of experience designing and implementing Master Data Management (MDM) solutions.
• 8+ years of experience designing and implementing custom solutions using Informatica Power Center.
• 8+ years of experience using Erwin, ER/Studio, or equivalent data modeling tools for enterprise data architecture and modeling.
• 8+ years of experience demonstrating strong communication, analytical, and interpersonal skills across all organizational levels.
• 8+ years of proven experience collaborating successfully with both technical and non-technical teams while managing multiple priorities and responsibilities.
• 8+ years of experience producing technical documentation with strong technical writing skills.

• 5+ years of experience as an Oracle Database Administrator (DBA).
• 5+ years of experience installing, configuring, and supporting Informatica Metadata Manager architecture.
• 5+ years of experience architecting enterprise-scale Master Data Management (MDM) solutions.
• 4+ years of education or equivalent experience with a Bachelor's degree in Computer Science, Systems Engineering, or a related field.