Lead Data Analytics Engineer

HCLTech; Slough; On-site; GBP 90,000 - 120,000; Full time

Job summary

HCLTech invites a Lead Analytics Engineer to design and optimize analytics data models within Snowflake, applying dbt Core/Cloud to deliver reliable, scalable solutions. You will transition complex Teradata-derived workflows to high-performance Snowflake constructs, implement data quality tests, version control, and CI/CD processes to accelerate analytics delivery across the organization.

Strong collaboration with data engineering, analytics stakeholders, and IT security to ensure governance and

Qualifications

• Expert Snowflake knowledge with advanced dbt (Core/Cloud) experience.
• Strong modelling skills: semantic, dimensional (Kimball), logical/physical.
• SQL-centric engineering mindset; experience with Git workflows and automated testing.

Responsibilities

• Build and maintain scalable modular data models using dbt inside Snowflake.
• Transition complex, unoptimised Teradata views into high-performance Snowflake tables.
• Implement data quality testing, version control (Git), and CI/CD pipelines for analytics code.
• Manage Snowflake warehouse optimization, access controls, and query performance tuning.

Skills

Snowflake

dbt Core/Cloud

Semantic Modelling

Dimensional Modelling (Kimball)

SQL

Git workflows

Automated testing

CI/CD pipelines

Tools

Git

dbt

CI/CD tools

Job description

HCLTech is a global technology company, home to more than 220,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.

Job Title/Role:

Lead Analytics Engineer

Mandatory Required Skills

Expert Snowflake knowledge and advanced dbt (Core/Cloud) experience.

Modelling Concepts: Semantic Modelling, Dimensional Modelling (Kimball), Business/Logical/Physical Modelling.

Skills: Software engineering mindset applied to SQL; git workflows, and automated testing.

Detailed Job Description

Key Responsibilities

• Build and maintain scalable modular data models using dbt inside Snowflake.
• Transition complex, unoptimised Teradata views into high-performance Snowflake tables.
• Implement data quality testing, version control (Git), and CI/CD pipelines for analytics code.
• Manage Snowflake warehouse optimization, access controls (ABAC), and query performance tuning.

Technical Requirements

Core Platforms:

Expert Snowflake knowledge and advanced dbt (Core/Cloud) experience.

Modeling Concepts:

Semantic Modeling, Dimensional Modeling (Kimball), Business/Logical/Physical Modelling.

Skills:

Software engineering mindset applied to SQL; git workflows, and automated testing.