Snowflake Data Lead

Location: Pune - Client Location

Time Type: Full time

Job Description

Job Title: Snowflake Data Lead

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.

Key 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.

Required 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.

Preferred Qualifications

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

S​YNECHRON’S DIVERSITY & INCLUSION STATEMENT
 

Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer. Our Diversity, Equity, and Inclusion (DEI) initiative ‘Same Difference’ is committed to fostering an inclusive culture – promoting equality, diversity and an environment that is respectful to all. We strongly believe that a diverse workforce helps build stronger, successful businesses as a global company. We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply. We empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs, and more.

All employment decisions at Synechron are based on business needs, job requirements and individual qualifications, without regard to the applicant’s gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law.

Candidate Application Notice