Snowflake Data Lead

Expleo Group; Pune District; On-site; INR 3,000,000 - 5,500,000; Full time

Job summary

Expleo Group is seeking a Snowflake Data Lead to architect and optimize scalable data solutions on Snowflake. You will mentor data engineers and guide enterprise data integration, warehousing, and analytics initiatives.

The role demands strong Snowflake, SQL, and Python expertise, plus hands-on experience in data architecture and governance. Collaboration with stakeholders across business units is essential for delivering robust data platforms.

Qualifications

• 6+ years of overall IT experience.
• 4+ years of experience in complex SQL, stored procedures, analytical functions, and query optimization.
• 3+ years of hands-on Snowflake Data Engineering experience.
• Strong experience with Python programming and automation.
• Solid understanding of Data Warehousing, ETL/ELT concepts, dimensional modeling, and data architecture.
• Experience with ETL tools such as Informatica, Talend, Matillion, DBT, or similar.
• Strong knowledge of database design, data modeling, DDL/DML, and data governance principles.
• Experience leading technical teams and managing deliverables across multiple stakeholders.
• Excellent analytical, problem-solving, and communication skills.

Responsibilities

• Lead the design and development of Snowflake-based data warehouse and ETL/ELT solutions.
• Build and optimize data pipelines, stored procedures, tasks, streams, and data transformation frameworks.
• Develop complex SQL queries, analytical functions, and performance-tuned data processing solutions.
• Implement scalable data ingestion frameworks for structured and semi-structured data.
• Drive data modeling, data quality, governance, and performance optimization initiatives.
• Provide technical leadership through design reviews, code reviews, and mentoring of Data Engineers.
• Collaborate with Business Units, Architects, and Product Owners to translate business requirements into technical solutions.
• Support production deployments, troubleshooting, and continuous improvement of data platforms.

Skills

SQL

Python

Data modeling

Data governance

Data warehousing

ETL/ELT

Team leadership

Communication

Analytical thinking

Tools

Informatica

Talend

Matillion

DBT

Job description

As a Snowflake Data Lead, you will lead the design, development, and optimization of scalable data solutions on the Snowflake platform. You will provide technical leadership to data engineering teams while driving enterprise data integration, data warehousing, and analytics initiatives. The role requires strong expertise in Snowflake, SQL, Python, and data architecture, along with the ability to mentor team members and collaborate with business stakeholders.

Responsibilities

• Lead the design and development of Snowflake-based data warehouse and ETL/ELT solutions.
• Build and optimize data pipelines, stored procedures, tasks, streams, and data transformation frameworks.
• Develop complex SQL queries, analytical functions, and performance-tuned data processing solutions.
• Implement scalable data ingestion frameworks for structured and semi-structured data.
• Drive data modeling, data quality, governance, and performance optimization initiatives.
• Provide technical leadership through design reviews, code reviews, and mentoring of Data Engineers.
• Collaborate with Business Units, Architects, and Product Owners to translate business requirements into technical solutions.
• Support production deployments, troubleshooting, and continuous improvement of data platforms.
  

Qualifications

• 6+ years of overall IT experience
• 4+ years of experience in complex SQL, stored procedures, analytical functions, and query optimization
• 3+ years of hands‑on Snowflake Data Engineering experience
• Strong experience with Python programming and automation.
• Solid understanding of Data Warehousing, ETL/ELT concepts, dimensional modeling, and data architecture.
• Experience with ETL tools such as Informatica, Talend, Matillion, DBT, or similar.
• Strong knowledge of database design, data modeling, DDL/DML, and data governance principles.
• Experience leading technical teams and managing deliverables across multiple stakeholders.
• Excellent analytical, problem‑solving, and communication skills.
  

Essential Skills

• SnowPro Certification
• AWS Cloud experience
• GitHub/CI-CD experience
• Agile delivery experience
• Banking, Cards, or Financial Services domain knowledge