Lead Data Analytics Engineer
NewBe an early applicantSummary
Lead analytics engineer at HCLTech in London, building and maintaining scalable modular data models with dbt inside Snowflake, migrating complex Teradata views to high-performance Snowflake tables, and implementing data quality testing, Git-based CI/CD pipelines, plus Snowflake warehouse optimization and access controls.
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.