Lead Snowflake Developer with MS SQL Server

Описание

We are seeking an experienced Lead Snowflake Developer with expertise in MS SQL Server to spearhead the transition of a significant data engineering stream to EPAM.This pivotal role requires strong technical abilities and leadership skills to guide a new team of Database Engineers and QAs while maintaining a hands-on approach to development and collaboration. The role will involve working directly with clients and driving a successful transition process.ResponsibilitiesDesign and develop ETL jobs using MS SQL Server, Snowflake SQL, and Talend to move and transform data from OLTP databases to Data LakesCreate automated processes for data cleaning, transformation, and relocation to defined destinationsIdentify and implement performance optimizations for automation, scalability, and efficient data deliveryCollaborate effectively with data and analytics teams to enhance core functionalities within existing data systemsDevelop streamlined data consumption solutions for internal teams or external end-user applicationsOccasionally oversee and troubleshoot database processes to ensure seamless operationsRequirements5+ years of hands-on experience with MS SQL Server1+ years of practical experience with Snowflake, including production environmentsProficiency in ETL development, specifically integrating MS SQL Server and SnowflakeBackground working with Talend, or similar ETL tools, for robust data pipeline creationFamiliarity with cloud-based data solutions and architecturesFluent English communication skills at a B2+ levelNice to haveKnowledge of Amazon Web Services and S3 integration, demonstrated experience with data warehousing solutionsSkills in Microsoft Power BI and Talend Cloud, or similar toolsFamiliarity with data governance tools, such as Oval Edge, including metadata profiling and lifecycle managementUnderstanding of change data capture (CDC) tools for real-time synchronization configuration and supportWe offerWork on a flexible schedule remotely or from any of our comfortable offices or coworking spaces in UkraineReceive the necessary equipment to perform your work tasksChange projects and technology stacks within EPAMGain experience in various business domains (Insurance, E-commerce, Healthcare, Finance, Travelling, Media, Artificial Intelligence, and more)Consider relocation options in over 30 countries worldwideParticipate in volunteer, charity programs and communities (both technical and interest-based)You can plan your individual career path together with your manager.Receive regular feedback from colleaguesImprove 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 CloudsUse the internal E-learn training program (18,200+ specialized training and mentoring programs)Access corporate accounts on LinkedIn Learning, Get Abstract and other partner resourcesStudy at EPAM Solution Architecture School with the instructors who are practicing architectsDevelop as a leader, join Delivery Management, Resource Management, Leadership Essentials school and moreParticipate 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 ratesCompany support during significant life events (childbirth or adoption, marriage, etc.)Support for psychological comfort: discounts on services from mental health specialists or coaches, thematic trainingE-kids program - a free programming language training program for EPAMers' childrenThe remote option applies only to the Candidates who will be working from any location in Ukraine.EPAM strives to provide its global team of over 52,800+ 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.