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 effective 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 effi

📌 Snowflake Senior Technical Lead (Lucknow)
🏢 HCLTech
📍 Lucknow