Senior Healthcare Data Modeler, EDW/Cloud Modernization
Core
Designing and modernizing enterprise data warehouse architectures for Medicaid, Medicare, and commercial healthcare data, transitioning from legacy Teradata to cloud platforms.
Role type
Senior Healthcare Data Modeler (EDW/Cloud Modernization)
Builds
Scalable enterprise data models, dimensional schemas, and cloud data lakehouse architectures for healthcare analytics.
Domain
Healthcare (Medicaid/Medicare) + Data Engineering/Architecture
Required skills
Data modeling (conceptual, logical, physical), Dimensional modeling (Star, Snowflake, Data Vault), SQL (expert-level), Data governance, Data quality, Metadata management, HIPAA/PHI compliance, ERD creation, Data migration
Preferred skills
Medicaid EDW/MMIS experience, Teradata Vantage modernization, Azure (Data Lake, Factory, Synapse), Snowflake, Databricks, Delta Lake, Power BI/Tableau, Python/R
Technologies
Azure, Snowflake, Databricks, Teradata, Erwin, Informatica, Power BI, Tableau, Python, SQL, Delta Lake
Responsibilities
Develop long-term data architecture strategies and roadmaps; translate business requirements into scalable enterprise data models; define primary/foreign keys, indexes, and referential integrity rules; oversee source-to-target mapping and data movement; support modernization of legacy Teradata models to Azure/Snowflake; maintain ERDs and model documentation; collaborate with Data Architects and ETL engineers.
Seniority
Senior, hands-on IC