Data Engineer (AWS, dbt, Redshift)

Cyclad cooperates with top international IT companies, delivering cutting-edge technology solutions. The project involves IT Services with a remote work model from Poland.

• Strong hands-on experience with Amazon S3, Amazon Redshift, dbt, and Apache Airflow
• Advanced SQL skills including 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), and ETL architecture best practices
• Working knowledge of Kimball Dimensional Modeling
• Experience with Cloudera, MinIO, and Apache Iceberg
• ELT/Data Pipeline Development experience
• Very good English skills

• 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

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