Medicaid Data Warehouse Architect

Medicaid Data Warehouse Architect:

Total Required Experience in Years: 15%2B Years

Mode of Work: 100% Onsite Austin, TX (Local Candidates Only)

Job Description:

The ideal candidate must possess deep expertise in Medicaid claims, encounters, eligibility, provider data, clinical assessments, Medicaid Data Warehouses, Master Data Management (MDM), metadata management, and enterprise data governance.

Key Responsibilities:

Data Architecture & Data Strategy

• Design and implement enterprise Medicaid Data Warehouse solutions.

• Develop and maintain Medicaid data architecture aligned with Texas Data Management Framework (TDMF).

• Architect multi-terabyte integrated data hubs and analytics platforms.

• Develop enterprise Medicaid analytics and reporting strategies.

• Define enterprise data standards, policies, and governance frameworks.

• Create data models, architecture standards, and governed data structures.

• Design data acquisition, integration, and harmonization strategies.

Data Governance & Data Management

• Support enterprise data governance initiatives.

• Develop metadata management and reference data management standards.

• Establish data quality frameworks, controls, and monitoring processes.

• Define systems of record and authoritative data sources.

• Support Master Data Management (MDM) initiatives.

• Perform root cause analysis on data quality and governance issues.

• Establish metrics for measuring data quality and metadata maturity.

Medicaid Analytics & Healthcare Data

• Serve as subject matter expert for Medicaid data domains including:

  • Provider Claims

  • Encounters

  • Eligibility

  • Client Movements

  • Clinical Assessments

  • Healthcare Analytics

• Support enterprise Medicaid reporting and performance management initiatives.

• Collaborate with business owners, data stewards, and analytics teams.

AI & Data Innovation

• Develop AI-assisted reporting and analytics strategies.

• Create standardized AI prompts and query templates.

• Validate AI-generated outputs and mitigate hallucination risks.

• Promote AI-driven analytics adoption across business units.

• Evaluate emerging AI and data technologies.

Leadership & Stakeholder Engagement

• Partner with executives, program leadership, architects, and data governance teams.

• Drive adoption of enterprise data management best practices.

• Lead initiatives supporting data-driven organizational transformation.

• Communicate technical concepts to executive and non-technical audiences.

• Build business cases supporting enterprise MDM and analytics initiatives.

Required Skills:

• 15%2B years of Data Architecture experience.

• 8%2B years of experience building and maintaining Medicaid Data Warehouses (Mandatory).

• Extensive experience with:

  • Medicaid Claims Data

  • Provider Data

  • Encounter Data

  • Eligibility Data

  • Clinical Assessment Data

• Strong expertise in:

  • Enterprise Data Architecture

  • Data Governance

  • Data Quality

  • Metadata Management

  • Reference Data Management

  • Master Data Management (MDM)

• Experience designing enterprise data acquisition and integration solutions.

• Experience developing Data Warehouse and Performance Management systems.

• Experience leading enterprise data strategy initiatives.

• Experience implementing data quality standards and controls.

• Strong knowledge of healthcare and insurance business domains.

• Experience creating enterprise data standards and governance policies.

• Excellent communication, stakeholder management, and leadership skills.

• Proven ability to work with both technical and business stakeholders.

Preferred Skills:

• Cloud Data Architecture (Azure, AWS, GCP).

• Healthcare Analytics Platforms.

• AI-Assisted Analytics and Reporting.

• Enterprise Data Catalog Solutions.

• Data Fabric or Data Mesh Architecture.

• Medicaid Modernization Programs.

• Public Sector Healthcare Systems.

Qualifications:

• Bachelor's Degree in Computer Science, Systems Engineering, Information Systems, Data Management, or related field.

• Equivalent professional experience may be considered.

Education:

• Bachelor's Degree Required.

• Master's Degree Preferred.

Certifications:

• Certified Data Management Professional (CDMP) DAMA (Highly Preferred)

• TOGAF Certification preferred.

• Azure Data Architect Certification preferred.

• AWS Data Analytics Certification preferred.

• DAMA Data Governance Certification preferred.

Mandatory Requirements:

15%2B Years of IT / Data Architecture Experience

8%2B Years Building & Maintaining Medicaid Data Warehouses

Extensive Medicaid Claims & Encounter Data Experience

Data Governance, Metadata Management & Data Quality Expertise

Austin, TX Local Candidates Only

Face-to-Face Interview Required

Additional Information:

• Location: Austin, Texas

• Work Arrangement: 100% Onsite

• Interview Process: Face-to-Face

• Medicaid domain expertise is mandatory.

• Candidates without Medicaid Data Warehouse architecture experience will not be considered.

• CDMP Certification from DAMA is highly preferred.

• Healthcare, Insurance, and Public Sector experience strongly preferred.