Technical Lead (Pune)

Technical Lead (Pune)

19 Nov
|
HCLTech
|
Pune

19 Nov

HCLTech

Pune

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

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: technical lead (pune) / pune