O pozici
Gypsy Collective is looking for a DWH Engineer to join our team and help build scalable, reliable, and high-performance data warehouse solutions that support analytics and business decision-making. We are looking for an experienced and proactive engineer who can work across the full data lifecycle - from ingestion and modeling to optimization, monitoring, and automation - while collaborating closely with analysts, developers, and business stakeholders.
Co budeš dělat
- Designing, building, and maintaining scalable Data Warehouse architectures aligned with business needs;
- Developing and optimizing ETL/ELT pipelines using Python, Airflow, and custom solutions;
- Working with DWH/Data Lake technologies including PostgreSQL, Trino, and BigQuery;
- Implementing incremental loads, CDC, backfills, and reprocessing strategies;
- Optimizing query performance, data models, and pipeline execution;
- Ensuring data quality through validation, automated testing, monitoring, and alerting;
- Integrating new data sources (APIs, third-party systems, raw data) without disrupting existing pipelines;
- Collaborating with analysts, engineers, BI teams, and business stakeholders to translate requirements into scalable data solutions;
- Reviewing code, mentoring engineers, and contributing to data engineering standards and best practices.
