Job Summary
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.
Key Responsibilities
- 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.
Required Qualifications
- 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
Rate:
Not specified
Location:
Remote
IR35 Status:
Outside
Remote Status:
Remote
Industry:
Data & Analytics
Seniority Level:
Mid-Level