Lead Data Analytics Engineer

HCLTech; Greater London; On-site; GBP 90,000 - 130,000; Full time

Job summary

HCLTech is seeking a Lead Analytics Engineer to design and optimize data models in Snowflake using dbt, with a strong SQL engineering mindset and CI/CD practices.

You will transition Teradata views to high-performance Snowflake structures, implement data quality tests, and manage warehouse performance and security controls in a global analytics environment.

Qualifications

• Expert level Snowflake and dbt experience required.
• Strong SQL engineering mindset with CI/CD testing.
• Experience with version control and automated testing.

Responsibilities

• Build and maintain scalable data models in Snowflake using dbt.
• Migrate Teradata views to optimized Snowflake tables.
• Implement data quality tests and CI/CD for analytics code.
• Manage Snowflake warehouses, access controls, and query tuning.

Skills

Snowflake expertise

dbt Core/Cloud

SQL programming

Git workflows

Automated testing

Tools

Git

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.
• **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.

**Skills:** Software engineering mindset applied to SQL; git workflows, and