Snowflake Senior Technical Lead
HCLTech
Date: 2 weeks ago
City: Lucknow, Uttar Pradesh
Contract type: Full time
Lucknow, Uttar Pradesh
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 and manage technical teams in the development and implementation of snowflake data solutions.
2. Design, build, and optimize data models using snowflake and dbt for efficient data processing.
3. Develop and optimize sql queries for data extraction, transformation, and loading processes.
4. Utilize python for scripting and automation of data processes and workflows.
5. Collaborate with cross functional teams to understand data requirements and ensure the successful delivery of technical solutions.
6. Conduct code reviews, provide technical guidance, and mentor team members to enhance overall technical capabilities.
7. Troubleshoot technical issues and provide resolutions in a timely manner to ensure smooth project execution.
Skill Requirements
1. Proficiency in snowflake for data warehousing and cloud data platform.
2. Experience with dbt (data build tool) for data transformation and modeling.
3. Strong command of sql for querying and manipulating data in databases.
4. Proficient in python programming for scripting, automation, and data manipulation.
5. Excellent problem-solving skills and the ability to communicate effectively with technical and nontechnical stakeholders.
6. Strong leadership skills to effectively lead and motivate technical teams towards project success.
#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-
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 and manage technical teams in the development and implementation of snowflake data solutions.
2. Design, build, and optimize data models using snowflake and dbt for efficient data processing.
3. Develop and optimize sql queries for data extraction, transformation, and loading processes.
4. Utilize python for scripting and automation of data processes and workflows.
5. Collaborate with cross functional teams to understand data requirements and ensure the successful delivery of technical solutions.
6. Conduct code reviews, provide technical guidance, and mentor team members to enhance overall technical capabilities.
7. Troubleshoot technical issues and provide resolutions in a timely manner to ensure smooth project execution.
Skill Requirements
1. Proficiency in snowflake for data warehousing and cloud data platform.
2. Experience with dbt (data build tool) for data transformation and modeling.
3. Strong command of sql for querying and manipulating data in databases.
4. Proficient in python programming for scripting, automation, and data manipulation.
5. Excellent problem-solving skills and the ability to communicate effectively with technical and nontechnical stakeholders.
6. Strong leadership skills to effectively lead and motivate technical teams towards project success.
#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-
How to apply
To apply for this job you need to authorize on our website. If you don't have an account yet, please register.
Post a resumeSimilar jobs
Business Development Manager ( Hotel Acquisition )
Treebo Hospitality Ventures,
Lucknow, Uttar Pradesh
2 weeks ago
About TreeboTreebo is India’s most loved brand and one of the largest chains in the budget segment of hospitality. With a network of 850+ hotels across 100+ cities, Treebo offers travelers the unprecedented value proposition of high-quality stays at affordable prices wherever they go. We are proud of putting dignity back into budget travel where earlier the traveler was forced...
Clinical Nurse - Nursing
Apollo Hospitals,
Lucknow, Uttar Pradesh
2 weeks ago
Job Purpose
Qualification:
Graduate; 1st division in 10th, 12th and GNM Nursing/BSc Nursing/M.Sc Nursing
Relevant Experience:
3 months – 5 years of experience in field of Nursing assessing patient’s health problems, providing care to sick, disabled, recovering or injured patients, maintaining important medical records, implementing a nursing care plan and advising patients about maintaining health.
Responsibilities
Recording medical history and...
Track Lead - Change Management, ServiceNow
HCLTech,
Lucknow, Uttar Pradesh
3 weeks ago
Lucknow, Uttar Pradesh
Job Summary
Global Change Manager Role Overview: The IT Change Management team is responsible for delivering robust and effective IT Change Management across the IT Ecosystem resulting in the provision of stable and reliable IT Services to the business. This role will focus on ownership of all changes requested for the IT Services and driving thorough risk-based...