Lead Data Engineer ( Snowflake + ADF + SQL)

Shashwath Solution; Pune District; On-site; INR 1,800,000 - 3,000,000; Full time

Job summary

Shashwath Solution is seeking a Lead Data Engineer with extensive experience in Snowflake, ADF, and SQL Server to design, build, and optimize data pipelines across the organization.

You will mentor junior engineers, collaborate with cross-functional teams, and drive data initiatives to deliver scalable, high-performance data solutions. The role requires strong cloud data skills and a proactive approach to data governance.

Qualifications

• Experience designing, developing, and managing data pipelines.
• Strong knowledge of Snowflake, ADF, and SQL Server.
• Mentoring and guiding junior data engineers.

Responsibilities

• Design, implement, and maintain data solutions using Snowflake, ADF, and SQL Server to ensure data integrity, scalability, and high performance.
• Lead and contribute to development of data pipelines, ETL processes, and data integration solutions.
• Collaborate with MSBI, SSIS, and Azure Data Lake Storage to optimize data flows and storage solutions.
• Work with business and technical teams to identify project needs and milestones.

Skills

Data management

Data integration

ETL

Business intelligence

SQL proficiency

Mentoring

Cloud data solutions

Tools

Snowflake

Azure Data Factory

SSIS

SSRS

SQL Server

Power BI

Azure Data Lake Storage

Azure Databricks

Job description

We are seeking a skilled Lead Data Engineer with extensive experience in Snowflake, ADF, SQL, and other relevant data technologies to join our team. As a key member of our data engineering team, you will play an instrumental role in designing, developing, and managing data pipelines, working closely with cross‑functional teams to drive the success of our data initiatives.

Key Responsibilities

• Design, implement, and maintain data solutions using Snowflake, ADF, and SQL Server to ensure data integrity, scalability, and high performance.
• Lead and contribute to the development of data pipelines, ETL processes, and data integration solutions, ensuring the smooth extraction, transformation, and loading of data from diverse sources.
• Work with MSBI, SSIS, and Azure Data Lake Storage to optimize data flows and storage solutions.
• Collaborate with business and technical teams to identify project needs, estimate tasks, and set intermediate milestones to achieve final outcomes.
• Implement industry best practices related to Business Intelligence and Data Management, ensuring adherence to usability, design, and development standards.
• Perform in-depth data analysis to resolve data issues and improve overall data quality.
• Mentor and guide junior data engineers, providing technical expertise and supporting the development of their skills.
• Effectively collaborate with geographically distributed teams to ensure project goals are met in a timely manner.

Required Technical Skills

• T-SQL
• SQL Server
• MSBI (SQL Server Integration Services, Reporting Services)
• Snowflake
• Azure Data Factory (ADF)
• SSIS
• Azure Data Lake Storage
• Proficient in designing and developing data pipelines, data integration, and data management workflows.
• Strong understanding of Cloud Data Solutions, with a focus on Azure-based tools and technologies.

Nice to Have

• Experience with Power BI for data visualization and reporting.
• Familiarity with Azure Databricks for data processing and advanced analytics.

Mandatory Key Skills

• data management
• data integration
• ssis
• ssrs
• msbi
• sql server
• azure data factory
• sql server integration services
• power bi
• azure data lake
• azure databricks
• etl
• business intelligence
• t-sql
• bi
• sql*
• microsoft azure*
• snowflake*
• data analysis*
• oracle adf*