Job Summary
Data Modeler – Healthcare Databricks Environment.Location: Bangalore / Pune / Noida / GurugramExperience: 6+ years in Data ModelingPostion-1Client is transforming its legacy Oracle enterprise data warehouse into a modern, governed Databricks Lakehouse (the EDL), built on a medallion architecture (Bronze Silver UDL (Gold) Platinum Consumption). We are looking for a Data Modeler to own the logical and physical data models that underpin the reusable UDL foundational marts and the domain-specific Platinum data products.He/She will translate payer business requirements and legacy OnPrem Oracle Enterprise Data warehouse logic into clean, reusable, well-governed models that multiple health care business domainsKey responsibilitiesDesign and maintain the Gold foundational data model — grain, keys, history (SCD), and relationships — for core payer entities: Member, Coverage/Eligibility, Claims/Claim Line, and Provider.Design Platinum (serving) models — dimensional facts and dimensions, fit-for-purpose views and metric views — aligned to specific business use cases.Define reference-data and identity-resolution patterns in partnership with the client teamsPartner with data engineers on transformation and load patterns, and validate models through reconciliation and data-quality checks.Work with the team to avail available AI accelerators to draft models, mappings, and documentation — always with human review and validation.Collaborate with LTHC data modeling/architecture leads, business SMEs, governance, and the Migration workstream to keep models demand-driven and reusable across waves.Required qualification6+ years in data modeling, with hands-on conceptual, logical, and physical modeling across both normalized/3NF (or Data Vault) foundational layers and dimensional (Kimball) serving layers.Strong healthcare payer data experience — claims, enrollment/eligibility, member, provider, and benefits — and the data-quality and identity challenges they bring.Expert SQL; solid experience with Databricks / Lakehouse (Delta) and medallion architectures.Experience modeling against a legacy Oracle EDW and migrating to a modern platform is preferred.Knowledge in data governance concepts — metadata, lineage, business glossary, and PHI/PII handling under HIPAA.Ability to engage business and technical stakeholders and translate requirements into durable, reusable models.
Key Responsibilities
Data Modeler – Healthcare Databricks Environment.Location: Bangalore / Pune / Noida / GurugramExperience: 6+ years in Data ModelingPostion-1Client is transforming its legacy Oracle enterprise data warehouse into a up-to-date, governed Databricks Lakehouse (the EDL), built on a medallion architecture (Bronze Silver UDL (Gold) Platinum Consumption). We are looking for a Data Modeler to own the logical and physical data models that underpin the reusable UDL foundational marts and the domain-specific Platinum data products.He/She will translate payer business requirements and legacy OnPrem Oracle Enterprise Data warehouse logic into clean, reusable, well-governed models that multiple health care business domainsKey responsibilitiesDesign and maintain the Gold foundational data model — grain, keys, history (SCD), and relationships — for core payer entities: Member, Coverage/Eligibility, Claims/Claim Line, and Provider.Design Platinum (serving)
models — dimensional facts and dimensions, fit-for-purpose views and metric views — aligned to specific business use cases.Define reference-data and identity-resolution patterns in partnership with the client teamsPartner with data engineers on transformation and load patterns, and validate models through reconciliation and data-quality checks.Work with the team to avail available AI accelerators to draft models, mappings, and documentation — always with human review and validation.Collaborate with LTHC data modeling/architecture leads, business SMEs, governance, and the Migration workstream to keep models demand-driven and reusable across waves.Required qualification6+ years in data modeling, with hands-on conceptual, logical, and physical modeling across both normalized/3NF (or Data Vault) foundational layers and dimensional (Kimball) serving layers.Strong healthcare payer data experience — claims, enrollment/eligibility, member, provider, and benefits — and the data-quality and identity challenges they bring.Expert SQL; solid experience with Databricks / Lakehouse (Delta) and medallion architectures.Experience modeling against a legacy Oracle EDW and migrating to a modern platform is preferred.Knowledge in data governance concepts — metadata, lineage, business glossary, and PHI/PII handling under HIPAA.Ability to engage business and technical stakeholders and translate requirements into durable, reusable models.
Skill Requirements
Data Modeler – Healthcare Databricks Environment.Location: Bangalore / Pune / Noida / GurugramExperience: 6+ years in Data ModelingPostion-1Client is transforming its legacy Oracle enterprise data warehouse into a modern, governed Databricks Lakehouse (the EDL), built on a medallion architecture (Bronze Silver UDL (Gold) Platinum Consumption). We are looking for a Data Modeler to own the logical and physical data models that underpin the reusable UDL foundational marts and the domain-specific Platinum data products.He/She will translate payer business requirements and legacy OnPrem Oracle Enterprise Data warehouse logic into clean, reusable, well-governed models that multiple health care business domainsKey responsibilitiesDesign and maintain the Gold foundational data model — grain, keys, history (SCD), and relationships — for core payer entities: Member, Coverage/Eligibility, Claims/Claim Line, and Provider.Design Platinum (serving) models — dimensional facts and dimensions, fit-for-purpose views and metric views — aligned to specific business use cases.Define reference-data and identity-resolution patterns in partnership with the client teamsPartner with data engineers on transformation and load patterns, and validate models through reconciliation and data-quality checks.Work with the team to avail available AI accelerators to draft models, mappings, and documentation — always with human review and validation.Collaborate with LTHC data modeling/architecture leads, business SMEs, governance,
and the Migration workstream to keep models demand-driven and reusable across waves.Required qualification6+ years in data modeling, with hands-on conceptual, logical, and physical modeling across both normalized/3NF (or Data Vault) foundational layers and dimensional (Kimball) serving layers.Strong healthcare payer data experience — claims, enrollment/eligibility, member, provider, and benefits — and the data-quality and identity challenges they bring.Expert SQL; solid experience with Databricks / Lakehouse (Delta) and medallion architectures.Experience modeling against a legacy Oracle EDW and migrating to a modern platform is preferred.Knowledge in data governance concepts — metadata, lineage, business glossary, and PHI/PII handling under HIPAA.Ability to engage business and technical stakeholders and translate requirements into durable, reusable models.
Must Have Skill
Data Lakehouse,Data Warehouse Systems,HIPAA (Healthcare),MS SQL
Good to Have Skill
Other Requirements
Data Modeler – Healthcare Databricks Environment.Location: Bangalore / Pune / Noida / GurugramExperience: 6+ years in Data ModelingPostion-1Client is transforming its legacy Oracle enterprise data warehouse into a modern, governed Databricks Lakehouse (the EDL), built on a medallion architecture (Bronze Silver UDL (Gold) Platinum Consumption). We are looking for a Data Modeler to own the logical and physical data models that underpin the reusable UDL foundational marts and the domain-specific Platinum data products.He/She will translate payer business requirements and legacy OnPrem Oracle Enterprise Data warehouse logic into clean, reusable, well-governed models that multiple health care business domainsKey responsibilitiesDesign and maintain the Gold foundational data model — grain, keys, history (SCD), and relationships — for core payer entities: Member, Coverage/Eligibility, Claims/Claim Line, and Provider.Design Platinum (serving) models — dimensional facts and dimensions, fit-for-purpose views and metric views — aligned to specific business use cases.Define reference-data and identity-resolution patterns in partnership with the client teamsPartner with data engineers on transformation and load patterns, and validate models through reconciliation and data-quality checks.Work with the team to avail available AI accelerators to draft models, mappings, and documentation — always with human review and validation.Collaborate with LTHC data modeling/architecture leads, business SMEs, governance, and the Migration workstream to keep models demand-driven and reusable across waves.Required qualification6+ years in data modeling, with hands-on conceptual, logical, and physical modeling across both normalized/3NF (or Data Vault) foundational layers and dimensional (Kimball) serving layers.Strong healthcare payer data experience — claims, enrollment/eligibility, member, provider, and benefits — and the data-quality and identity challenges they bring.Expert SQL; solid experience with Databricks / Lakehouse (Delta) and medallion architectures.Experience modeling against a legacy Oracle EDW and migrating to a modern platform is preferred.Knowledge in data governance concepts — metadata, lineage, business glossary, and PHI/PII handling under HIPAA.Ability to engage business and technical stakeholders and translate requirements into durable, reusable models.
📌 Technical Lead (Pune)
🏢 HCLTech
📍 Pune