Lead Data Engineer ( Snowflake + ADF + SQL)

Shashwath Solution; Dadri; On-site; INR 3,000,000 - 5,000,000; Full time

Job summary

Shashwath Solution is seeking a Lead Data Engineer with deep expertise in Snowflake, Azure Data Factory and SQL Server. You will design, build, and optimize data pipelines, ensuring data quality and scalable performance across diverse sources.

You will mentor junior engineers, collaborate with cross‑functional teams, and help enforce best practices in data management and BI. Prior experience in MSBI, SSIS/SSRS and Azure storage is highly valued.

Qualifications

• Proven experience with Snowflake, ADF and SQL Server in data engineering roles.
• Hands-on use of MSBI tools including SSIS and SSRS for ETL and reporting.
• Strong data modeling, pipeline design and data quality practices.

Responsibilities

• Design, implement and maintain data solutions using Snowflake, ADF and SQL Server.
• Lead development of ETL pipelines and data integration across sources.
• Optimize data flows with MSBI tools and Azure storage services.
• Collaborate with cross‑functional teams to define tasks and milestones.
• Enforce BI and data management standards for usability and quality.
• Perform data analysis to resolve issues and improve quality.
• Mentor junior data engineers and share technical expertise.
• Coordinate with distributed teams to meet project goals.

Skills

T-SQL

SQL Server

MSBI

Snowflake

Azure Data Factory

SSIS

Azure Data Lake Storage

Power BI

Tools

SSIS (SQL Server Integration Services)

SSRS (SQL Server Reporting Services)

Azure Databricks

MSBI tooling

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*