We are seeking a skilled Senior Data Integration Engineer to join our dynamic team.The successful candidate will work within a multidisciplinary team, leveraging agile methodologies to develop data models and efficiently integrate diverse data repositories. This role requires a deep understanding of data modeling principles, particularly Kimball Dimensional Modeling, and proficiency in SQL and data warehouse techniques.The remote option applies only to the Candidates who will be working from any location in Ukraine.ResponsibilitiesDesign data models adhering to industry best practices with an emphasis on Kimball Dimensional ModelingCollaborate with data consumers to define requirements, objectives, and interface specificationsCreate robust SQL code to establish data structures based on models and transform data during stagingDevelop unit tests to confirm code accuracyEvaluate data sources, assess quality, and identify optimal integration methodsProduce Source to Target Mappings from data models for data integration (ETL) specificationsFormulate strategies to integrate data from various sources and data warehousesEstablish data models and standards that simplify the integration of large and diverse data repositoriesEngage in requirement checks and design sessions with stakeholdersAssist in the development and deployment of data integration solutionsRequirements3-5 years of experience in data modeling with expertise in dimensional data modelingProficiency in SQL, stored procedure writing, ETL, and SCDProven track record working on Data Warehouse projectsHands-on experience with Amazon Cloud Architecture including AWS S3, DataBricks, AWS RedshiftFamiliarity with SAP Power Designer, Erwin, or similar toolsExposure to DBT (Data Build Tool) developmentStrong attention to detailCompetency in data warehouse concepts, practices, and codingUnderstanding of AirflowExcellent teamwork capabilitiesExperience with databases such as Redshift, Teradata, or OracleUnderstanding of software engineering and testing practices within an Agile environmentProficiency in English, with excellent communication skills including the ability to persuade and negotiateWe offer/BenefitsWITH US YOU CANWork 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) WE FOCUS ON YOUR PROFESSIONAL GROWTHYou 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) WHAT WE OFFERVacation 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' childrenEPAM 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.Why Choose Us
