Senior Technical Lead

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

In short

We are looking for a skilled Data Modeler to design and implement dimensional data structures for efficient reporting and analytics. The role involves translating business requirements into conceptual, logical, and physical models, ensuring high-performance, scalable, and accurate data marts. Key responsibilities include designing data marts, knowledge of ETL, performance tuning, and maintaining data governance.

Responsibilities

Create conceptual, logical, and physical data models using dimensional modeling techniques (Kimball methodology) optimized for data mart performance.
Design, develop, and maintain data warehouse/data mart structures.
Collaborate with stakeholders and business analysts to translate business requirements into technical data structures.
Define data ingestion, transformation, and load pipelines using ETL.
Tune SQL queries, indexes, and database schemas for maximum efficiency.
Maintain comprehensive documentation of data models, lineage, and data definitions.
Ensure data consistency, quality, and security within the data mart.

Requirements

Strong proficiency in relational, dimensional (star schema), and NoSQL modeling.
Expert-level SQL skills.
Experience with ETL/data integration tools.
Familiarity with modern data platforms (Snowflake, Azure Databricks, Redshift).

Benefits

Consolidated revenues as of 12 months ending June 2026 totaled $14.8 billion.
Global technology company with over 223,000 people across 60 countries.
Industry-leading capabilities centered around digital, engineering, cloud and AI.
Work with clients across all major verticals including Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services.

Skills

SQLETLData ModelingDimensional ModelingStar SchemaNoSQLSnowflakeAzure DatabricksRedshift

#Data Mart#Data Warehouse#Dimensional Modeling#ETL#SQL#Performance Optimization#Data Governance#Snowflake#Azure Databricks#Redshift

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