Lead Data Engineer ( Snowflake + ADF + SQL)

Shashwath Solution; Pune District; On-site; INR 4,000,000 - 6,000,000; Full time

Job summary

Shashwath Solution is seeking a Lead Data Engineer to design, develop, and manage enterprise data pipelines using Snowflake, ADF, and SQL Server. You will mentor junior engineers and collaborate with cross-functional teams to ensure data integrity, scalability, and performance across storage and analytics platforms.

The role emphasizes strong data integration, MSBI, and Azure data services, with focus on building robust data architectures in a fast-paced environment.

Qualifications

• Proven experience designing and maintaining data pipelines.
• Strong knowledge of Snowflake, ADF, SQL Server, and MSBI.
• Experience with data integration and data management workflows.
• Ability to mentor junior data engineers.
• Collaborates with cross-functional teams across distributed locations.

Responsibilities

• Design, implement, and maintain data solutions using Snowflake, ADF, and SQL Server.
• Lead and develop data pipelines, ETL processes, and data integration.
• Work with MSBI, SSIS, and Azure Data Lake Storage to optimize data flows.
• Collaborate with business and technical teams to plan milestones.
• Apply BI and data management best practices.
• Perform data quality analysis and issue resolution.
• Mentor junior data engineers.
• Coordinate with distributed teams to meet goals.

Skills

Data management

Data integration

ETL

T-SQL

SQL Server

MSBI (SSIS/SSRS)

Power BI

Azure Data Factory

Snowflake

Azure Data Lake Storage

Azure Databricks

Tools

Snowflake

Azure Data Factory (ADF)

SSIS

SSRS

Azure Data Lake Storage

Azure Databricks

Power BI

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*