Senior Technical Lead (IN)

HCL TechnologiesIN

Senior

Posted 5 days agoStill open, checked 34m ago

About the job

Job Summary

Job Summary

We are looking for an experienced Data Modeler to design and govern enterprise data models for a large-scale GCP-based Unified Data Platform (UDP) in the Insurance domain. The role will drive data architecture, canonical modeling, data products, analytics, and governance initiatives across the enterprise data landscape.

Key Responsibilities

  • Design and maintain conceptual, logical, and physical data models across Customer, Policy, Claims, Lead, Campaign, and Finance domains.
  • Develop dimensional models, data marts, fact and dimension structures, and analytical data products.
  • Define canonical, conformed, and reusable enterprise data models.
  • Create and maintain source-to-target mappings, transformation rules, and data lineage documentation.
  • Collaborate with Business Analysts, Architects, and Data Engineers to translate business requirements into scalable data solutions.
  • Establish and enforce enterprise data modeling standards and governance practices.
  • Support Bronze, Silver, Gold, and Data Product layer design and implementation.
  • Conduct model reviews, impact assessments, and change analysis for source systems and reporting solutions.
  • Drive data quality, metadata management, master data, and lineage initiatives.
  • Support regulatory, operational, and analytical reporting requirements.
  • Mentor team members on data modeling best practices.

Skill Requirements

  • Strong expertise in Conceptual, Logical, and Physical Data Modeling.
  • Hands-on experience with Dimensional Modeling (Kimball Methodology).
  • Proficiency in ER Studio, Erwin, Lucidchart, or similar modeling tools.
  • Strong understanding of Data Warehousing, Lakehouse, and Enterprise Analytics architectures.
  • Experience with BigQuery, GCP Data Platforms, or cloud-based analytics solutions.
  • Strong SQL and database design skills.
  • Knowledge of Data Governance, Metadata Management, Data Lineage, and Data Quality frameworks.
  • Experience designing canonical and conformed data models.
  • Excellent stakeholder management, communication, and problem-solving skills.
  • Very good at prompt engineering using AI tools. Should be able to demonstrate how business requirements can be converted to technical artifacts

Preferred Skills

  • Experience in Insurance, Healthcare, or Financial Services domains.
  • Knowledge of ACORD and/or FHIR data standards.
  • Understanding of Customer 360, Policy, Claims, Lead, and Campaign data domains.
  • Familiarity with Data Products, Data Mesh, and Modern Lakehouse architectures.
  • Experience supporting enterprise-scale cloud transformation programs.

Key Competencies

  • Enterprise Data Architecture
  • Data Modeling & Governance
  • Analytical and Problem-Solving Skills
  • Stakeholder Management
  • Leadership and Mentoring
  • Cross-functional Collaboration
  • Business-to-Data Translation

Other Requirements

Similar jobs