DWH Engineer — Flexible Hours, Data Pipeline Expert

Gypsy Collective; Polska; On-site; PLN 120,000 - 190,000; Full time

Benefits offered by this job

Flexible schedule

Learning & growth

Certification support

Tech equipment

Team events

Cafeteria benefits

Job summary

Gypsy Collective is seeking a DWH Engineer to design, build, and maintain scalable data warehouse solutions for analytics and decision-making. You will manage data lifecycle from ingestion to orchestration, collaborating with analysts, engineers, and business stakeholders.

You will develop ETL/ELT pipelines using Python, SQL, Airflow, and related technologies; integrate data from APIs, databases, and SaaS platforms; and work with Trino and cloud analytics platforms to drive reliable, timely data

Qualifications

• Strong SQL skills with complex queries, CTES, window functions and optimization.
• Experience integrating external data sources including REST APIs, databases, SaaS platforms, and third-party systems.
• Experience with Apache Airflow (2+ years) and data pipelines.
• Proficiency in Python for data processing, integrations, and automation.

Responsibilities

• Design, build, and maintain scalable DWH and Data Lake solutions aligned with business needs.
• Develop, optimize, and support ETL/ELT pipelines using Python, SQL, Airflow and related tech.
• Ingest data from APIs, databases, SaaS platforms, and third-party systems.
• Work with Trino and cloud analytics platforms to support reporting and analytics.
• Implement incremental loading, CDC, backfills, and reprocessing workflows.
• Monitor, troubleshoot, and improve data pipelines for reliability and timeliness.
• Implement data quality checks, validation rules, and automated monitoring.
• Optimize queries, data models, and pipeline performance.
• Collaborate with analysts, BI developers, engineers, and stakeholders.

Skills

SQL

ETL/ELT

Airflow

Python

Data Warehousing

Data Modeling

Git

Performance Tuning

Tools

Trino

Cloud platforms

REST APIs

Data Vault

Job description

Gypsy Collective is seeking a DWH Engineer to design, build, and maintain scalable data warehouse solutions for analytics and decision-making. You will manage data lifecycle from ingestion to orchestration, collaborating with analysts, engineers, and business stakeholders.

You will develop ETL/ELT pipelines using Python, SQL, Airflow, and related technologies; integrate data from APIs, databases, and SaaS platforms; and work with Trino and cloud analytics platforms to drive reliable, timely data