MDM Architect (Required Local Candidates)

Austin

**Respond by: 06/11/2026** **Rate: DOE** **Type: Contract** **Work Mode: Onsite** **Location: Austin TX** Please respond with resume and 3 references preferably supervisor (name, title, company, email, phone number) Background Check will be performed if a candidate is selected for placement and will have to be passed' **Job Description** **The worker:** Has an excellent understanding of MDM principles, goals, and tools and how these relate to overall data quality and cross-program data integrations. Is responsible for development and implementation of new MDM capabilities using the Informatica application tool stack in IDMC. Works collaboratively with EIM program staff, with 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. **The applicant will be able to demonstrate extensive experience in:** Developing **MDM solutions for healthcare provider** and managed care member domains (using an Informatica tool stack). Developing extract/transform/load processes for 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 system data models to accurately represent as-is and to-be process models involving 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 IT coding and security standards. **Strategic Liaison and Translation** 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. **AI Prompting and Data Synthesis** 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. **Collaboration and Problem-Solving** 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. **II. CANDIDATE SKILLS AND QUALIFICATIONS** |----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|--------------------|------------------------------------------------------------------------------------------------------------------| | **Minimum Requirements:** Candidates that do not meet or exceed the **minimum** stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity. | | Years | Required/Preferred | Experience | | 8 | Required | **Advanced Informatica and ETL developer skills** | | 8 | Required | Experience and understanding of**Enterprise Information Management** best practices | | 8 | Required | Experience designing and implementin**g Master Data Management solutions** | | 8 | Required | Experience designing and implementing **Informatica PowerCenter custom solutions** | | 8 | Required | Experience with **Erwin and ERStudio data modeling tools or equivalent functional toolsets** | | 8 | Required | Strong Communication, analytical and interpersonal skills at all levels | | 8 | Required | Proven ability to work successfully with technical and non-technical groups and manage multiple responsibilities | | 8 | Required | Strong technical writing skills | | 5 | Preferred | Some experience as an **Oracle DBA desired, but not required** | | 5 | Preferred | Experience installing and **configuring Informatica Metadata Manager architecture** | | 5 | Preferred | Experience **architecting Master Data Management solutions** | | 4 | Preferred | Bachelor's degree in Computer Science, Systems Engineering or equivalent experience | **III. TERMS OF SERVICE** Services are expected to start **09/01/2026** and are expected to complete by **08/31/2027** . Total estimated hours per Candidate shall not exceed **2008** hours. This service may be amended, renewed, and/or extended providing both parties agree to do so in writing. **IV. WORK HOURS AND LOCATION**