Job description

Austin, TX Enterprise Architect - Solicitation# 529701740R Texas Health and Human Services Commission (HHSC) Overview The MDM Architect position is an Information Technology (IT) position and will be a part of the Enterprise Information Management (EIM) team working in collaboration with the Office of Data Analytics & Performance (DAP) within the Health and Human Services System’s business domain. This architect designs and implements master data solutions for a multi-terabyte Master Data Management (MDM) implementation. The mission of EIM is to ensure HHS master data is visible, accessible where appropriate, understandable in context, trusted by users, and uniformly governed in order to advance data quality and support integrated data analytics in the Integrated Continuum of Care Analytics initiative. This enables data-driven decision making across the HHS system. The worker: • Has an excellent understanding of MDM principles, goals, and tools and how these relate to overall HHS 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 HHSC 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 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. Position is 100% Remote. **Subject to change per the hiring team** 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. Actual Years Experience Years Experience Needed Required/ Preferred Skills/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 I need Three References Reference Name ( Required ): Title (Optional) Company Name ( Required ): Phone Number ( Required include area code): E-mail address (Optional): Professional Relationship (Optional): Peer Co-Worker Supervisor Customer End-User Subordinate Reference Name ( Required ): Title (Optional) Company Name ( Required ): Phone Number ( Required include area code): E-mail address (Optional): Professional Relationship (Optional): Peer Co-Worker Supervisor Customer End-User Subordinate Reference Name ( Required ): Title (Optional) Company Name ( Required ): Phone Number ( Required include area code): E-mail address (Optional): Professional Relationship (Optional): Peer Co-Worker Supervisor Customer End-User Subordinate

Requirements

Must-haves

Enterprise Architect - Solicitation# 529701740R
Texas Health and Human Services Commission (HHSC)
Has an excellent understanding of MDM principles, goals, and tools and how these relate to overall HHS 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.
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 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.

Nice-to-haves

Skills/Experience
Experience installing and configuring Informatica Metadata Manager architecture
Experience architecting Master Data Management solutions
Bachelor's degree in Computer Science, Systems Engineering or equivalent experience
I need Three References

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

agileai

Platform: catsone
Effort: medium