Lead Data Engineer ( Snowflake + ADF + SQL)

Shashwath Solution; Dadri; On-site; INR 2,500,000 - 4,500,000; Full time

Job summary

Shashwath Solution seeks a skilled Lead Data Engineer in India to design, develop, and manage data pipelines using Snowflake, Azure Data Factory, and SQL Server. You will lead a data engineering team, drive ETL initiatives, and ensure scalable, high-performance data solutions for cross-functional projects.

Ideal candidates bring hands-on experience with MSBI, SSIS/SSRS, Azure Data Lake Storage, and Power BI, and communicate effectively with distributed teams to deliver on milestones.

Qualifications

• Extensive experience implementing Snowflake, ADF, and SQL Server solutions for scalable data platforms.

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.
• 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 and 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.

Skills

Data pipeline design

Data integration

Data analysis

Mentor junior engineers

Tools

Snowflake

Azure Data Factory

SQL Server

MSBI

SSIS

SSRS

Azure Data Lake Storage

Power BI

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*