Lead with MS SQL Server and Snowflake

We are looking for an experienced Lead Data Integration Engineer to represent EPAM with our client and oversee the transition of a ~17-person stream from another vendor.

This role combines leadership responsibilities with hands-on work, requiring proficiency in MS SQL, Snowflake, and related technologies to ensure efficient data integration and transformation processes.

Responsibilities

• Lead a new team of ~5-7 EPAM Database Engineers and QAs during the vendor transition process
• Dedicate 50-70% of the time working directly with code and tools
• Design ETL jobs using MSSQL, Snowflake SQL, and Talend to migrate and transform data to Data Lakes
• Develop automated workflows for data cleaning, transformation, and relocation to predefined destinations
• Identify process enhancements to improve automation, scalability, and data delivery efficiency
• Collaborate with data and analytics teams to optimize systems for functionality and user experience
• Streamline data access processes for team consumption and analytics display purposes
• Handle database performance issues on occasion, ensuring smooth operations

Requirements

• 5+ years of experience with MS SQL Server, including extensive knowledge of database development and optimization
• 1+ years of Snowflake experience, including designing and implementing data integration workflows
• 1+ years of leadership experience in related positions
• Proficiency in ETL tools and frameworks such as Talend
• Familiarity with cloud environments like AWS and storage solutions such as S3
• Strong English communication skills, at least at a B2+ level

Nice to have

• Background in Data Warehouse Management with strong knowledge of the data lifecycle
• Proficiency in visualization tools like Microsoft Power BI
• Competency in conducting audits within cloud warehouses
• Understanding of Data Governance Tools such as Oval Edge or similar for metadata profiling and cataloging
• Capability to utilize Change Data Capture Tools for real-time synchronization configuration and management

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