Quick overview
Job description
Role: Senior Data Architect & SME
Location: USA (Remote)
Domain: Healthcare Data platforms, Medicaid/T-MSIS Domain expertise
Duration: 4 months (possibility of extension)
Role Summary
Senior architecture role focused on modern healthcare data platforms, Medicaid/T-MSIS domain expertise, and large-scale modernization using AWS Databricks.
Roles & Responsibilities
- Define scalable data architecture patterns using AWS Databricks, PySpark, Spark SQL, Delta Lake, and lakehouse / medallion architecture principles.
- Design canonical/conformed data models, metadata-driven transformation patterns, reusable rule frameworks, and governed reference-data structures.
- Translate T-MSIS and Medicaid business requirements into technical architecture and data-model decisions.
- Guide modernization of legacy ETL and batch solutions into cloud-native Databricks implementations.
- Provide architectural guidance for source-to-target mapping, state-specific rules, validation, reconciliation, lineage, audit, and data governance.
- Review technical designs, data models, transformation logic, and engineering standards.
- Work closely with business SMEs, mapping analysts, data engineers, QA, and platform teams to resolve complex data and domain issues.
- Mentor engineering teams and provide technical leadership on performance, scalability, maintainability, and security.
Required Skills & Experience
- 10+ years of data engineering / architecture experience, including 3+ years in a senior or lead architect role.
- Strong hands-on experience with AWS Databricks, PySpark, Spark SQL, Delta Lake, Databricks Workflows, and lakehouse / medallion architectures.
- Strong understanding of AWS data-platform services and integration patterns, including S3, IAM, networking/security concepts, and cloud data movement.
- Strong data modeling experience covering raw, conformed, curated, and regulatory-reporting data layers.
- Experience designing metadata-driven / configuration-driven transformation and business-rules frameworks.
- Experience with Unity Catalog, data lineage, access controls, auditability, and governed reference data.
- Strong SQL and experience with Oracle, SQL Server, DB2, flat files, and enterprise source systems.
- Experience modernizing legacy ETL platforms such as DataStage, SSIS, Informatica, C/Linux, COBOL, or custom batch frameworks.
- Experience with Git, CI/CD, code review, automated testing, and deployment practices for Databricks.
- Strong communication skills and ability to convert complex business and regulatory requirements into practical architecture.
Domain Knowledge
- Strong Medicaid / MMIS domain knowledge is required.
- Hands-on T-MSIS experience is highly preferred.
- Understanding of T-MSIS domains including Eligibility, Provider, Managed Care, TPL, Inpatient Claims, Long-Term Care, Other Services, Pharmacy, and Financial Transactions.
- Experience interpreting CMS specifications, source-to-target mappings, validation rules, crosswalks, valid values, and state-specific reporting logic.
- Knowledge of healthcare payer data, claims and encounter processing, provider data, eligibility/enrollment, and regulatory reporting.
- Understanding of PHI-sensitive data environments, state-level data isolation, and healthcare data-governance expectations.
Similar jobs
- AE

Senior Data ArchitectRecently posted
Aerospace Corporation · El Segundo, CA · Remote · Posted 11 Nov 2026 🇺🇸
MongoDBNeo4jSQL+13Technology$120.3k - $202.8k/yr - S&
AWS Data Architect with P&C MandatoryRecently posted
Syntrux & Co · Erie, PA · On-site · Posted 11 Nov 2026 🇺🇸
Stakeholder ManagementDynamoDBAWS+5TechnologySalary not listed - JT
Senior Data Architect with strong AI expertiseRecently posted
JBS Technologies · United States · Hybrid · Posted 11 Nov 2026 🇺🇸
MicroservicesAWSETL+5TechnologySalary not listed - SC

senior Data ModelerRecently posted
S3 Connections LLC · McLean, VA · On-site · Posted 11 Nov 2026 🇺🇸
Stakeholder ManagementMongoDBSQL+2Salary not listed - CS
Data Architect – Mortgage & Capital MarketsRecently posted
Crossword Staffing Solutions LLC · United States · Hybrid · Posted 11 Nov 2026 🇺🇸
SQLMicrosoft ExcelAWS+12TechnologySalary not listed - PD

Master Data Management ManagerRecently posted
PY DATA, INC. · Middletown, PA · Hybrid · Posted 11 Nov 2026 🇺🇸
TechnologySalary not listed - IT
Senior AWS Data ArchitectRecently posted
isolve technology inc · United States · Remote · Posted 11 Nov 2026 🇺🇸
SQLApache SparkAWS+10TechnologySalary not listed - AP
Databricks ArchitectRecently posted
AptoNet Inc · Washington, DC · On-site · Posted 10 Nov 2026 🇺🇸
Stakeholder ManagementSQLScala+19Salary not listed - RY
Data ArchitectRecently posted
RyanBPM · Cary, NC · Hybrid · Posted 10 Nov 2026 🇺🇸
SQLScalaApache Spark+17TechnologySalary not listed - MU

Data ArchitectRecently posted
MphasiS Corporation USA · Alpharetta, GA · Hybrid · Posted 10 Nov 2026 🇺🇸
OracleSQLAWS+8TechnologySalary not listed - FT

Senior Data Architect
Fixity Technologies · Dallas, TX · On-site · Posted 4 Nov 2026 🇺🇸
Stakeholder ManagementSQLApache Spark+7TechnologySalary not listed - EX

Data ArchitectRecently posted Auto Apply
EXL · Pittsburgh · Hybrid · Posted 11 Nov 2026 🇺🇸
OracleETLSnowflake+5TechnologySalary not listed