Technical Lead

India
Job Description

Technical Lead

Pune, Maharashtra

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.

Information at a Glance

Why HCLTech?

At HCLTech, you'll supercharge your potential. You'll find your career. And you'll find your spark. All at a place that knows that helping its customers stay on top starts by putting its people first.

HCLTech is a global technology company, home to more than 230,000 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of 12 months ending September 2026 totaled $14.8 billion.