Enterprise Architect for HHSC, Austin, Tx

Pedigo Staffing Services•Austin, TX

4d•Remote

About The Position

The Enterprise Architect 3 position at the Texas Health and Human Services Commission (HHSC) is a remote role open to candidates within the State of Texas. This role is part of the Enterprise Information Management (EIM) team, focusing on developing a Master Data Management (MDM) function under the Performance Management & Analytics System (PMAS). The architect will design and implement master data solutions for a multi-terabyte MDM implementation, aiming to make HHS master data visible, accessible, understandable, trusted, and uniformly governed to support data quality and integrated data analytics. The position involves utilizing an agile methodology and collaborating with various teams to ensure data-driven decision-making across the HHS system. The role requires a strong understanding of MDM principles, goals, and tools, and their relation to HHS data quality and cross-program data integrations. The architect will be responsible for developing and implementing new MDM capabilities using Informatica's application tool stack in IDMC, working with EIM program staff, HHSC 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 role also includes developing extract/transform/load processes, enhancing MDM application layers, working with data architects and subject matter experts, managing metadata loads, planning and monitoring MDM/Metadata project lifecycles using agile methods, and ensuring build and deployment quality comply with HHSC IT standards. Additionally, the architect will serve as a strategic liaison, explaining project findings and data limitations to leadership, developing AI prompts and query strategies, validating AI output, and promoting a data-driven culture. Collaboration with data engineering, IT, and Program teams for troubleshooting and providing expert guidance on data interpretation is also a key aspect of this role.

Requirements

8 years Required - Advanced Informatica and ETL developer skills
8 years Required - Experience and understanding of Enterprise Information Management best practices
8 years Required - Experience designing and implementing Master Data Management solutions
8 years Required - Experience designing and implementing Informatica PowerCenter custom solutions
8 years Required - Experience with Erwin and ERStudio data modeling tools or equivalent functional toolsets
8 years Required - Strong Communication, analytical and interpersonal skills at all levels
8 years Required - Proven ability to work successfully with technical and non-technical groups and manage multiple responsibilities
8 years Required - Strong technical writing skills
Must be US Citizen, Green Card, EAD. No H1B

Nice To Haves

5 years Preferred - Some experience as an Oracle DBA desired, but not required
5 years Preferred - Experience installing and configuring Informatica Metadata Manager architecture
5 years Preferred - Experience architecting Master Data Management solutions
4 years Preferred - Bachelor's degree in Computer Science, Systems Engineering or equivalent experience

Responsibilities

Translate client's business requirements into specific systems, applications, or process designs with interlocked financial modeling for very large complex technical solutions.
Analyze customer service requirements and design service solutions to meet those objectives.
Act as the primary expert to construct the specific solution, scope document, risk profile, and corresponding financials.
Maintain and utilize detailed industry and internal services knowledge in the construction of industry-leading services solutions.
Use expertise to construct specific and detailed solutions that encompass process, technology, and staffing plans for customer sales opportunities.
Construct risk assessments and corresponding remediation plans relative to complex services proposals.
Participate in the construction of detailed financial models that align with complex services proposals.
Compose Statement of Work or other documents to craft detailed and accurate deliverables that specify processes, technology, staffing, and project management involved in proposed services solutions.
Provide a 'trusted expert advisor' role as a Subject Matter Expert for technical services, to both internal and external customers.
Follow all organizational Standard Operating Procedures relative to cost modeling, approvals and reviews, and all other associated workflow and deliverables.
Design and implement master data solutions for a multi-terabyte Master Data Management (MDM) implementation.
Develop and implement new MDM capabilities using the Informatica application tool stack in IDMC.
Work collaboratively with EIM program staff, 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.
Develop MDM solutions for healthcare provider and managed care member domains (using an Informatica tool stack).
Develop extract/transform/load processes for HHS system data into MDM applications (using Oracle, Snowflake and Informatica tools).
Develop, test, and maintain enhancements/upgrades to MDM application layer(s).
Work 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.
Plan and monitor MDM/Metadata project lifecycle deployment using agile methods.
Ensure that the build and deployment of the MDM components are of high quality and comply HHSC IT coding and security standards.
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.
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.
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.