Lead Data Engineer ( Snowflake + ADF + SQL)

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.