Lead Data Integration Engineer (MS SQL, Snowflake)

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.

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
• Experience with visualization tools such as Microsoft Power BI
• Experience conducting audits in cloud warehouses
• Familiarity with Data Governance Tools like Oval Edge or similar for cataloging and metadata profiling
• Capability to implement Change Data Capture Tools for configuration, management, and support of real-time data synchronization

Benefits

With us you can:

• Work on a flexible schedule remotely or from any of our comfortable offices or coworking spaces in Ukraine
• Receive the necessary equipment to perform your work tasks
• Change projects and technology stacks within EPAM
• Gain experience in various business domains (Insurance, E-commerce, Healthcare, Finance, Travelling, Media, Artificial Intelligence, and more)
• Relocation opportunities may be available for eligible candidates, depending on the role and openings at other EPAM locations
• Participate in volunteer, charity programs and communities (both technical and interest-based)

We focus on your professional growth:

• You can plan your individual career path together with your manager
• Receive regular feedback from colleagues
• Improve your English for free with certified teachers (Speaking Clubs, client interview preparation courses, etc.)
• Get the opportunity to undergo free training and certification in AWS, GCP, or Azure Clouds
• Use the internal E-learn training program (18,200+ specialized training and mentoring programs)
• Access corporate accounts on LinkedIn Learning, Get Abstract and other partner resources
• Study at EPAM Solution Architecture School with the instructors who are practicing architects
• Develop as a leader, join Delivery Management, Resource Management, Leadership Essentials school and more
• Participate in internal communities (500+ meetups, technical discussions, brainstorming sessions, online events and conferences annually)

What we offer:

• Vacation and sick leave (including a sick leave without a medical certificate)
• A wide range of Voluntary Medical Insurance programs providing both medical treatment and various preventive options (including sports activities)
• Medical insurance for family members at corporate rates
• Company support during significant life events (childbirth or adoption, marriage, etc.)
• Support for psychological comfort: discounts on services from mental health specialists or coaches, thematic training
• E-kids program - a free programming language training program for EPAMers' children