Lead Data Integration Engineer; MS SQL, Snowflake

Position: 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

Requirements5+ years of working experience with MS SQL Server, including in-depth knowledge of database development and optimization1+ years of working experience with Snowflake, including design and implementation for data integration workflows1+ 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 BIExperience 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

We offer

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 EPAMGain 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 Linked In 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

Kindly be advised that the set of benefits, including learning, certification, and other opportunities, may vary depending on the role you apply for. Our recruiter will be able to share more details about the specific opportunity during your general interview.

EPAM strives to provide its global team of over 62,350 professionals in more than 55 countries with opportunities for professional growth from day one of collaboration. Our colleagues are the source of EPAM's success, so we value cooperation, strive to always understand our clients' business and aim for the highest quality standards. No matter where you are, you will join a dedicated, diverse community that will help you realize your potential to the fullest.
#J-18808-Ljbffr