Snowflake Senior Technical Lead (IN)
HCLTech
HCLTech
Seeking a Senior Technical Lead with extensive experience in Snowflake cloud data warehousing and modern ELT development using dbt. This role demands deep proficiency in advanced SQL, dimensional modeling (Kimball/Data Vault), performance tuning, and cost optimization within Snowflake. You'll be responsible for designing scalable ELT pipelines, implementing CI/CD for dbt, integrating orchestration tools, and ensuring data quality through automated testing and observability. A strong grasp of cloud platforms, Snowflake security, Git, and DevOps practices is essential, alongside proven experience in leading technical design reviews and mentoring data engineering teams, including offshore members.
This position specifically targets a dbt Developer skilled in SQL and data modeling to construct and sustain robust data transformation solutions on the Snowflake platform. Your contributions will involve crafting dbt models, tests, macros, and documentation to empower analytics, reporting, and strategic business decisions.
- 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 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 timely resolutions to ensure smooth project execution.
- Strong proficiency in Snowflake for data warehousing and cloud data platforms. - Proven experience with dbt (data build tool) for data transformation and modeling. - Exceptional 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 both technical and non-technical stakeholders. - Strong leadership capabilities to effectively lead and motivate technical teams toward project success. - Experience designing scalable, production-grade ELT pipelines. - Implementation of CI/CD for dbt and integration of orchestration tools. - Enforcement of data quality through automated testing and observability frameworks. - Understanding of cloud platforms and security in Snowflake. - Experience with version control (Git) and DevOps-driven deployment practices.
HCLTech
IT Consulting