Data Engineer (m/f/n)

SHIMI Sp. z o.o.

• Experience with Amazon S3 and Amazon Redshift.
• Proficient with dbt and Apache Airflow.
• Advanced SQL skills including inner, self, left, right, and full outer joins.
• Knowledge of data warehousing concepts.
• Experience implementing fact and dimension tables.
• Understanding of Type 1 & Type 2 Slowly Changing Dimensions.
• Working knowledge of Kimball Dimensional Modeling.
• Familiarity with Cloudera, MinIO, and Apache Iceberg.
• Experience in ELT/Data Pipeline Development.

• 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, Periodic Snapshot) and Type 1 & Type 2 Slowly Changing Dimensions as per 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.
• Load, transform, and optimize performance on Amazon Redshift.
• Manage data stored in Amazon S3 and Apache Iceberg tables on the MinIO platform.
• Support migration of data pipelines from Cloudera to MinIO.
• Collaborate with architects, data modelers, and business teams to deliver reliable data solutions.