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