Note: The job is a remote job and is open to candidates in USA. S2Tech is an IT consulting company supporting Health and Human Services-related projects. The Data/Lakehouse Architect will lead the architecture and engineering design for Missouri’s Integrated Health Data Fabric, developing governed lakehouse layers, AWS ingestion pipelines, and canonical/FHIR-aligned clinical data models. The role also establishes data-quality, metadata, lineage, integration, documentation, and operational practices across a multi-vendor Medicaid environment.
Responsibilities
- Define and implement the lakehouse data architecture across raw/bronze, curated/silver, and reporting/gold layers while preserving source fidelity and auditability
- Design batch, near-real-time, and event-driven ingestion pipelines for clinical, claims, eligibility, social-care, and public-health data using AWS-native services, including AWS Glue
- Map heterogeneous clinical feeds into governed transactional and analytical structures using canonical and FHIR-aligned data models
- Establish data-quality, validation, reconciliation, deduplication, harmonization, schema-evolution, and exception-management controls
- Implement metadata management, lineage, data cataloging, provenance, retention, and traceability from source through downstream reports and APIs
- Coordinate lakehouse integration with the FHIR platform, API layer, master data/patient identity capabilities, analytics, and downstream CMS/state reporting
- Produce architecture decisions, data mappings, interface specifications, runbooks, and knowledge-transfer materials suitable for State operations
- Collaborate with security, integration, FHIR, analytics, and delivery teams in a multi-vendor Medicaid environment
Skills
- 8+ years mapping unstandardized clinical data feeds into cloud-hosted transactional database tables
- 8+ years of data engineering or data architecture experience covering AWS, ingestion pipelines, canonical/FHIR data modeling, and metadata/lineage
- Demonstrated ability to translate healthcare source data into governed, production-grade data models and pipelines
- Ability to perform all work within the United States and support Jefferson City onsite needs as directed
- Deep FHIR R4, US Core, HL7 v2, CDA/C-CDA, healthcare terminology, or implementation-guide experience
- AWS Glue, S3, lakehouse, catalog, orchestration, observability, and data-security experience
- Medicaid, MMIS/MES, state health and human services, claims/eligibility, or public-health data experience
- Experience with master patient index/master data management, consent, data governance, CMS reporting, or HIPAA/MARS-E controls
Benefits
- Remote work in the U.S.
- Medical / Dental / Vision Insurance – insurance premium assistance provided
- Additional Insurance (Life, Disability, etc.)
- Paid Time Off
- 401(k) Retirement Savings Plan & Health Savings Account
- Various training courses to promote continuous learning
- Corporate Wellness Program
- Employees benefit from innovative project exposure and in-house skill development training/courses
- Corporate culture that emphasizes the importance of family and promotes a healthy work-life balance
Company Overview