Data Engineer (AWS, dbt, Redshift)

In Cyclad we work with top international IT companies in order to boost their potential in delivering outstanding, cutting-edge technologies that shape the world of the future. We are seeking an experienced Data Engineer to design, build, and maintain scalable ELT pipelines and enterprise data warehouse solutions within a cloud-based analytics environment. This role requires expertise in data warehousing, Amazon Redshift, Amazon S3, dbt, Apache Airflow, and dimensional modeling principles.

Project information:

• Type of project: IT Services

• Office location: Poland

• Work model: Remote from Poland

• Budget: 110 - 130 PLN net/ h - b2b

• Project length: till the end of 2027, possible to extend it

• Only candidates with citizenship in the European Union and residence in Poland

• Start date: ASAP

Project scope:

• Develop and maintain ELT pipelines from source systems (Cloudera/MinIO) to Amazon S3 and Amazon Redshift

• Build and maintain data warehouse layers, including Staging, Intermediate, Business View, and Dimensional Models

• Implement fact tables (Transactional, Accumulating Snapshot, and Periodic Snapshot) and Type 1 & Type 2 Slowly Changing Dimensions based on established data models

• Develop data transformations using dbt and orchestrate workflows using Apache Airflow

• Write, optimize, and troubleshoot SQL queries, including inner, self, and outer joins

• Work with Amazon Redshift for data loading, transformation, and performance optimization

• Manage and process data stored in Amazon S3 and Apache Iceberg tables on the MinIO platform

• Support the migration of data pipelines from Cloudera to the MinIO platform

• Collaborate with architects, data modelers, and business teams to deliver reliable and high-quality data solutions

Competence demands:

• Strong hands-on experience with Amazon S3, Amazon Redshift, dbt and Apache Airflow

• Advanced SQL (Inner, Self, Left, Right, and Full Outer Joins)

• Strong understanding of Data Warehousing concepts, Fact and Dimension implementation, Slowly Changing Dimensions (Type 1 & Type 2), ETL architecture best practices

• Working knowledge of Kimball Dimensional Modeling

• Experience with Cloudera, MinIO, and Apache Iceberg

• ELT/Data Pipeline Development

• Very good English skills

We offer:

• Remote working model

• Dynamic and innovation-driven engineering environment

• Full-time job agreement based on b2b

• Private medical care with dental care (covering 70% of costs)

• Multisport card (also for an accompanying person)

• Life insurance