Data Modeler - Healthcare Databricks Environment (Fully Remote)

We are seeking an experienced Data Modeler with strong Healthcare Payer expertise to support the modernization of a legacy Oracle Enterprise Data Warehouse into a Databricks Lakehouse environment. The ideal candidate will design scalable, governed data models that support enterprise healthcare analytics, reporting, and data products across Member, Claims, Eligibility, Provider, and Benefits domains., * Design and maintain logical and physical data models for Databricks Lakehouse (Gold/UDL and Platinum layers).

• Model core healthcare payer entities including Member, Eligibility, Coverage, Claims, Claim Lines, and Provider.
• Design dimensional models (Facts & Dimensions) to support reporting and analytics.
• Define data relationships, keys, history tracking (SCD), and reference data strategies.
• Partner with Data Engineers to implement scalable Delta Lake data solutions.
• Validate data models through reconciliation, data quality, and governance processes.
• Collaborate with business stakeholders, architects, and SMEs to translate requirements into reusable data products.
• Ensure compliance with HIPAA, PHI/PII handling, metadata, lineage, and governance standards.

• 6+ years of Data Modeling experience.
• Strong Healthcare Payer domain experience with Claims, Member, Eligibility, Provider, and Benefits data.
• Hands-on experience with conceptual, logical, physical, and dimensional data modeling.
• Strong SQL skills and experience with Databricks, Delta Lake, and Medallion Architecture.
• Experience with Data Vault, 3NF, and Kimball dimensional modeling methodologies.
• Knowledge of data governance, metadata management, lineage, and HIPAA compliance.
• Ability to work with both business and technical stakeholders.

Preferred Qualifications

• Experience migrating Oracle EDW environments to Databricks Lakehouse.
• Familiarity with Unity Catalog, Data Quality frameworks, and MDM/Identity Resolution.
• Experience in large Healthcare Payer organizations.

Must-Have Skills

• Healthcare Payer Data Modeling
• Databricks & Delta Lake
• SQL
• Claims & Eligibility Data
• Kimball Dimensional Modeling
• Data Vault / 3NF Modeling
• Oracle EDW Migration
• HIPAA & Data Governance

Depends on Experience