Senior Technical Lead

Technology, Data & Digital · Data, AI & Analytics · Data Engineering · Software Engineering · Data Analysis

In short

We are seeking an experienced Data Modeler to design and govern enterprise data models for a large-scale GCP-based Unified Data Platform within the Insurance sector. This role will lead data architecture, canonical modeling, data products, analytics, and governance initiatives across the enterprise data landscape.

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.

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

Desired Qualifications

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.

Benefits

Supercharge your potential.
Find your career.
Find your spark.

Skills

Data ModelingGCPSQLBigQueryER StudioErwinLucidchartData WarehousingLakehousePrompt EngineeringACORDFHIR

#Data Modeler#GCP#Unified Data Platform#Insurance#Data Architecture#Canonical Modeling#Data Products#Analytics#Data Governance

About HCLTech

Supercharging progress through technology and innovation

HCLTech is a global technology company, home to 219,000+ people across 54 countries, delivering industry-leading capabilities centered around digital, engineering and cloud, 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 2022 totaled $12.1 billion. To learn how we can supercharge progress for…

See all open jobs at HCLTech Read more about HCLTech Website