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
Experience with Python
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/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

Data Integration & 8 others