Technical Lead (IN)

HCL TechnologiesIN

Posted 3 hours agoStill open, checked 3h ago

About the job

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 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.

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.

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.

Similar jobs