Lead with MS SQL Server and Snowflake

About the Position

We are seeking an experienced Lead Data Integration Engineer with expertise in MS SQL Server and Snowflake to join our team in Ukraine. 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

We Offer

• 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)
• Focus on your professional growth:
  • 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)
• 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