Data Integration Engineer (Remote)

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.

Responsibilities

• Design data models adhering to industry best practices with an emphasis on Kimball Dimensional Modeling
• Collaborate with data consumers to define requirements, objectives, and interface specifications
• Create robust SQL code to establish data structures based on models and transform data during staging
• Develop unit tests to confirm code accuracy
• Evaluate data sources, assess quality, and identify optimal integration methods
• Produce Source to Target Mappings from data models for data integration (ETL) specifications
• Formulate strategies to integrate data from various sources and data warehouses
• Establish data models and standards that simplify the integration of large and diverse data repositories
• Engage in requirement checks and design sessions with stakeholders
• Assist in the development and deployment of data integration solutions

Requirements

• 3-5 years of experience in data modeling with expertise in dimensional data modeling
• Proficiency in SQL, stored procedure writing, ETL, and SCD
• Proven track record working on Data Warehouse projects
• Hands-on experience with Amazon Cloud Architecture including AWS S3, DataBricks, AWS Redshift
• Familiarity with SAP Power Designer, Erwin, or similar tools
• Exposure to DBT (Data Build Tool) development
• Strong attention to detail
• Competency in data warehouse concepts, practices, and coding
• Understanding of Airflow
• Excellent teamwork capabilities
• Experience with databases such as Redshift, Teradata, or Oracle
• Understanding of software engineering and testing practices within an Agile environment
• Proficiency in English, with excellent communication skills including the ability to persuade and negotiate

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)
• Consider relocation options in over 30 countries worldwide
• Participate 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 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

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.