Lead Analytics Engineer: Snowflake & dbt Expert

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 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