Informatica MDM Architect (15+)

InnoSoul•Guadalupe, TX

3d•Remote

About The Position

The Department of Information Resources (DIR) requires the services of a senior Master Data Architect, hereafter referred to as Worker, who meets the general qualification of Enterprise Architect 3, Emerging Technologies and the specifications outlined in this document for Health and Human Services Commission (HHSC) Information Technology. All work products resulting from the project shall be considered "works made for hire" and are the property of the HHSC. HHSC may include pre-selection requirements that potential Vendors (and their Workers) submit to and satisfy criminal background checks as authorized by the Texas law. HHSC will pay no fees for interviews or discussions, which occur during the process of selecting a Worker(s). HHSC IT is continuing to develop a Master Data Management (MDM) function under the Performance Management & Analytics System (PMAS) on the Enterprise Information Management (EIM) team. This development effort will utilize an agile methodology based upon the approach currently in use at HHSC for the Performance Management & Analytics System (PMAS). As a lead and member of the EIM team, the worker responsibilities may include: 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.

Requirements

Advanced Informatica and ETL developer skills
Experience and understanding of Enterprise Information Management best practices
Experience designing and implementing Master Data Management solutions
Experience designing and implementing Informatica PowerCenter custom solutions
Experience with Erwin and ERStudio data modeling tools or equivalent functional toolsets
Strong Communication, analytical and interpersonal skills at all levels
Proven ability to work successfully with technical and non-technical groups and manage multiple responsibilities
Strong technical writing skills
Extensive experience in developing MDM solutions for healthcare provider and managed care member domains (using an Informatica tool stack).
Extensive experience in developing extract/transform/load processes for HHS system data into MDM applications (using Oracle, Snowflake and Informatica tools).
Extensive experience in developing, testing, and maintenance of enhancements/upgrades to MDM application layer(s).
Extensive experience 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.
Extensive experience in operational responsibility for metadata loads.
Extensive experience in planning and monitoring MDM/Metadata project lifecycle deployment using agile methods.
Extensive experience in ensuring that the build and deployment of the MDM components are of high quality and comply HHSC IT coding and security standards.
Extensive experience in working with program areas and project sponsor to plan and execute multiple analytics projects asynchronously.
Extensive experience in explaining project findings and data limitations in simple, non-technical language to agency leadership and program staff.
Extensive experience in developing and refining effective AI prompts and query strategies to retrieve and synthesize master data for complex data domains.
Extensive experience in developing a library of standardized prompts and query templates for common reporting needs.
Extensive experience in providing subject matter expertise on validating output from AI, particularly with respect to identifying and mitigating hallucinations.
Extensive experience in ensuring all data outputs adhere to agency reporting standards, data governance, and compliance regulations.
Extensive experience in promoting a data-driven culture by enabling and empowering all staff to effectively utilize data and AI.
Extensive experience in staying up to date on new AI and data analytics tools and techniques to continuously improve program competencies.
Extensive experience in working closely with data engineering, IT, and Program teams to troubleshoot data-related issues and address inconsistencies and mitigation strategies.
Extensive experience in providing expert guidance to program staff on interpreting data trends and answering complex data questions.

Nice To Haves

Some experience as an Oracle DBA desired, but not required
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

Responsibilities

Responsible for translating the client's business requirements into specific systems, applications or process designs with interlocked financial modeling for very large complex technical solutions.
Analyzes customer service requirements and designs service solutions to meet those objectives.
Primary expert to construct the specific solution, scope document, risk profile, and corresponding financials.
Maintains and utilizes detailed industry and internal services knowledge in the construction of industry-leading services solutions, including expert working level knowledge of the processes, technologies, and people components involved in the services arena.
Uses expertise to construct specific and detailed solutions that encompass process, technology, and staffing plans for customer sales opportunities.
Constructs risk assessments and corresponding remediation plans relative to complex services proposals.
Participates in the construction of detailed financial models that align with complex services proposals.
Composes Statement of Work or other documents, using departmental automation tools as available, to craft detailed and accurate deliverables that specify processes, technology, staffing, and project management involved in proposed services solutions.
As needed, provide a "trusted expert advisor" role as a Subject Matter Expert for technical services, to both internal and external customers, ranging from formal advice to internal and external customer presentations.
Follow all organizational Standard Operating Procedures relative to cost modeling, approvals and reviews, and all other associated workflow and deliverables.
Designs and implements master data solutions for a multi-terabyte Master Data Management (MDM) implementation.
Ensures 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.
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.
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.
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.