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 Apa