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., 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

Seeking a Grafana/ClickHouse Developer with 4-6 years of experience in building scalable analytics and observability solutions. The ideal candidate will have hands-on expertise in …