ETL Developer

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