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 HHSC 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.
CANDIDATE SKILLS AND QUALIFICATIONS
| 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 implementing 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 |