Lead Data Integration Engineer (MS SQL, Snowflake)

About this role

We are seeking a highly skilled and experienced
Lead Data Integration Engineer
who will play a critical role in representing EPAM with our client and leading the transition of a ~17-person stream from another vendor. This is a hands-on position requiring expertise in MS SQL, Snowflake, and related technologies to drive seamless data integration and transformation processes.

Kindly note that this role supports remote work, but only from within Ukraine.

Responsibilities

• Build and lead a new team of ~5-7 EPAM Database Engineers and QAs to transition responsibilities from another vendor
• Work with code and tools 50-70% of the time in a hands-on capacity
• Design and develop ETL jobs using MSSQL, Snowflake SQL, and Talend to move and transform data from OLTP databases to Data Lakes
• Create automated jobs for data cleaning, transformation, and relocation to designated destinations
• Identify, design, and implement process optimizations for automation, scalability, and efficient data delivery
• Collaborate with data and analytics teams to enhance functionality and usability within data systems
• Simplify and streamline data consumption processes for internal teams and end-user analytics display
• Monitor occasionally database processes and resolve performance issues as needed

Requirements

• 5+ years of working experience with MS SQL Server, including in-depth knowledge of database development and optimization
• 1+ years of working experience with Snowflake, including design and implementation for data integration workflows
• 1+ years of leadership experience in relevant roles
• Expertise in ETL and data transformation tools such as Talend or similar frameworks
• Familiarity with cloud environments such as AWS and storage solutions like S3
• Strong verbal and written communication skills in English, at least at a B2+ level

Nice to have

• Background in Data Warehouse Management, with an understanding of end-to-end data lifecycle processes
• Exp...