Snowflake Senior Technical Lead

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

In short

HCLTech is seeking a Senior Technical Lead with strong expertise in Snowflake cloud data warehousing and dbt for ELT development. The role involves leading technical teams, designing scalable data pipelines, optimizing performance, and mentoring junior members in Chennai or Hyderabad.

Responsibilities

Lead and manage technical teams in the development and implementation of Snowflake data solutions.
Design, build, and optimize data models using Snowflake and dbt for efficient data processing.
Develop and optimize SQL queries for data extraction, transformation, and loading processes.
Utilize Python for scripting and automation of data processes and workflows.
Collaborate with cross-functional teams to understand data requirements and ensure the successful delivery of technical solutions.
Conduct code reviews, provide technical guidance, and mentor team members to enhance overall technical capabilities.
Troubleshoot technical issues and provide resolutions in a timely manner to ensure smooth project execution.
Develop and maintain dbt models on Snowflake.
Build reliable, tested, and documented data transformation pipelines.
Implement data quality checks, lineage, and governance standards.
Optimize SQL queries and dbt models for performance and cost.
Support Git-based development, CI/CD, and deployment processes.

Requirements

Strong SQL and data modeling skills.
Hands-on experience with dbt Core or dbt Cloud.
Experience working with Snowflake.
Knowledge of ELT pipelines, testing, documentation, and version control.
Understanding of analytics engineering and dimensional modeling.
Proficiency in Snowflake for data warehousing and cloud data platform.
Experience with dbt (data build tool) for data transformation and modeling.
Strong command of SQL for querying and manipulating data in databases.
Proficient in Python programming for scripting, automation, and data manipulation.
Excellent problem-solving skills and the ability to communicate effectively with technical and non-technical stakeholders.
Strong leadership skills to effectively lead and motivate technical teams towards project success.
Experience designing scalable, production-grade ELT pipelines.
Experience implementing CI/CD for dbt.
Experience integrating orchestration tools.
Experience enforcing data quality through automated testing and observability frameworks.
Strong understanding of cloud platforms and security in Snowflake.
Experience with version control (Git).
Experience with DevOps-driven deployment practices.
Demonstrated experience leading technical design reviews.
Experience mentoring data engineering teams.
Experience working in an onsite-offshore model mentoring offshore members to drive delivery.

Skills

SnowflakedbtSQLPythonData ModelingELTGitCI/CD

#Data Engineering#Snowflake#dbt#ELT#SQL#Data Modeling#Python#Cloud Data Warehousing#CI/CD#DevOps#Git

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