Medicaid Data Warehouse Architect

Job ID: TX-529701741R

Onsite/Local Medicaid Data Warehouse Architect (CDMP/15+) with data management/Quality/Metadata/Governance, clinical assessments, PMAS, SME, AI and public healthcare experience

Location: Guadalupe, TX (HHSC)
Duration: 12 Months
Position is ONSITE at the location listed above (NO REMOTE WORK). Program will only accept LOCAL ONLY candidates for this position.
Please do not submit candidates who are currently out of state and are planning to move to Texas. Candidates must already reside in Texas.

Skills:
12 Required Excellent understanding of Data Architecture principles, capabilities, and best practices with the proven ability to define, document and apply standards and best practices
12 Required Experience with business processes, data management, data flows, data relationships, data quality standards and processes, and proficiency with data analytical and quality tools
10 Required Extensive experience in working with Medicaid data; specifically in the areas such as provider claims & encounters as well as client movements and clinical assessments.
8 Required Experience in building and maintaining a Medicaid Data Warehouse.
8 Required Extensive architecture experience and knowledge in the areas of Reference Data, Data Quality, Metadata Management
8 Required Experience leading and evolving corporate culture to a data driven organization
8 Required Communication, analytical and interpersonal skills at all levels
5 Preferred Experience designing/implementing data acquisitions for Master Data Management, Data Warehouse or other Performance Management system.
5 Preferred Experience with public health care or Insurance business domain
5 Preferred Proven ability to work successfully with technical and non-technical groups and manage multiple responsibilities
4 Preferred Bachelor s degree in Computer Science, Systems Engineering or equivalent experience
1 Preferred Certified Data Management Professional (CDMP) from DAMA

Description:
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.

The Department of Information Resources (DIR) requires the services of a senior Medicaid 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 an Integrated Continuum of Care Analytics (ICCA) function under the Performance Management & Analytics System (PMAS). This development effort will utilize a hybrid agile/waterfall methodology based upon the approach currently in use at HHSC for the Performance Management & Analytics System (PMAS). As a lead and member of the PMAS Medicaid team, the worker responsibilities may include:

Overview:
The Medicaid Data Architect position is an Information Technology (IT) position and will be a part of the PMAS Medicaid sprint 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 integrated data solutions for a multi-terabyte data integration hub implementation. The mission of PMAS is to ensure HHS curated data is visible, accessible where appropriate, understandable in context, trusted by users, and uniformly governed in order to support integrated data analytics in the Integrated Continuum of Care Analytics initiative. This enables data-driven decision making across the HHS system.

The Medicaid Data Architect position is an Information Technology (IT) position and will be a part Performance Management and Analytics System (PMAS) team under the Office of Chief Data Architect in Health and Human Services System s IT domain. This position is required to create data architecture(s) related to Texas Medicaid data in compliance with Texas Data Management Framework (TDMF) and HHS Data Governance (DG) policies.

The Enterprise Architect position:
Collaborates with the Office of the Chief Data Architect on initiatives related to performance analytics and data governance.
Architects cloud data hub integrations with Medicaid data and other data domain platforms.
Develops best practices and methodologies to mature TDMF best practices and capability maturities.
Develops enterprise data policy and standards that support the development of an enterprise data governance framework.
Serves as Data Architecture and Data Management expert for the HHS system, Medicaid.
Develops a detailed knowledge of the underlying HHS data assets and data products and provides subject matter expert on content, current and potential future uses of data.
Assists in development and implementation of data quality processes and metrics.
Responsible for consulting with the business owners of data assets, providers of enterprise analytics, and Information Technology leadership to develop enterprise Medicaid analytics strategy for future funding, design, and implementation
Provides expertise in data harmonization, master data development and governance, data quality, and metadata management.
Provides guidelines on creating data models and various standards relating to governed data.
Reviews changes to technical and business metadata, realizing their impacts on enterprise applications, and ensures the impacts are communicated to appropriate parties.
Establishes measures to chart progress related to the completeness and quality of metadata for enterprise information to support reduction of data redundancy and fragmentation and elimination of unnecessary movement of data; and to improve data quality.
Assists in selecting data management tools and developing the standards, usage guidelines, and procedures for using those tools.
Assists in identifying appropriate data sourcing and extraction processes, and in identifying and nominating sources as systems of record for data usage in various applications.
Assists in performing root cause analyses related to information issues and non-conformance to published data standards based on review of technical metadata of various source systems.
Builds business cases to support collaborative HHS MDM efforts and adoption.
Works with CTO office, CDA architecture team, and MCS program stakeholders to come up with Medicaid data and analytics strategy considering long term goals/objectives.

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