Snowflake Technical Lead
HCLTech
Job Summary
Key Responsibilities
Data Analysis & Understanding
Perform detailed data analysis to identify trends, patterns, and anomalies. Translate business requirements into scalable data solutions.
Data Modeling & Design
Design, develop, and maintain efficient data models and database structures in Snowflake to support analytics and reporting requirements while ensuring data integrity and scalability.
Data Pipeline Development
Develop and maintain robust ETL/ELT pipelines using SQL and relevant data integration tools to ingest and transform data from multiple source systems.
Snowflake Development & Optimization
Build and optimize Snowflake-based data solutions , including views, stored procedures, and optimized queries to ensure high performance and scalability.
Data Quality & Validation
Implement data quality checks, validation frameworks, and monitoring mechanisms to ensure reliability and consistency of data.
Performance Optimization
Optimize SQL queries, data models, and storage structures to improve data processing efficiency and reduce execution time.
Cross-Team Collaboration
Work closely with BI teams, analysts, and business stakeholders to understand reporting requirements and translate them into data engineering solutions.
Documentation & Standards
Maintain proper documentation for data models, data pipelines, transformations, and data flow architecture.
Continuous Improvement
Stay updated with emerging technologies and best practices in cloud data engineering, Snowflake architecture, and data modeling .
Individual Contribution: Ability to independently drive data engineering tasks as an Individual Contributor, taking end-to-end ownership from requirement understanding to implementation, optimization, and delivery.
Key Responsibilities
1. Lead technical projects involving snowflake, dbt, sql, and python from conception to completion.
2. Provide technical expertise and guidance to team members.
3. Collaborate with stakeholders to understand project requirements and translate them into technical solutions.
4. Develop and maintain database systems using snowflake and sql.
5. Implement data transformation and modeling using dbt (data build tool).
6. Write and optimize python code for data extraction, transformation, and loading (etl) processes.
7. Troubleshoot technical issues and provide timely resolutions.
8. Stay updated on industry trends and technologies related to snowflake, dbt, sql, and python.
Skill Requirements
1. Proficiency in snowflake for database development and management.
2. Experience with dbt for data transformation and modeling.
3. Strong sql skills for querying and managing databases.
4. Advanced knowledge of python for data manipulation and etl processes.
5. Ability to work in a fast paced environment and manage multiple priorities effectively.
6. Excellent problem-solving skills and attention to detail.
7. Strong communication and leadership abilities to guide and mentor team members effectively.
Other Requirements
1.Relevant certifications in Snowflake, DBT, SQL, or Python are a plus.
#body.unify div.unify-button-container .unify-apply-now: focus, #body.unify div.unify-button-container .unify-apply-#body.unify div.unify-button-container .unify-apply-now: focus, #body.unify div.unify-button-container .unify-apply-