# DWH Engineer

> Gypsy Collective · Ukraine (Remote) · Full-time · Posted 2026-10-15

**Workplace:** remote

**Department:** Analytics

## Description

**We're Gypsy Collective.** The digital world is evolving faster than ever. New opportunities, new challenges, new ambitious goals. That’s why strong businesses need strong people. 

**Gypsy Collective** is an exclusive talent partner for selected brands. We help our partners attract exceptional talent by building long-term relationships and becoming deeply integrated into their business, culture, and growth ambitions.

We are looking for a **DWH Engineer** to design, build, and maintain scalable data warehouse solutions that support analytics and business decision-making. You will work across the full data lifecycle - from data ingestion and transformation to orchestration and optimization - while collaborating with analysts, engineers, and business stakeholders.  

**📅  Your adventures include:**

-   Develop, and maintain DWH and Data Lake solutions aligned with business requirements;
-   Build, optimize, and support ETL/ELT pipelines using Python, SQL, Airflow, and related technologies;
-   Integrate and maintain data flows from APIs, databases, SaaS platforms, and third-party systems;
-   Work with Trino and cloud-based analytical platforms to support reporting and analytics needs;
-   Implement and support incremental loading, CDC processes, backfills, and reprocessing workflows;
-   Monitor, troubleshoot, and improve data pipelines to ensure reliability, stability, and timely delivery of data;
-   Implement data quality checks, validation rules, and automated monitoring processes;
-   Optimize SQL queries, data models, and pipeline performance;
-   Collaborate with analysts, BI developers, engineers, and business stakeholders to deliver scalable data solutions;
-   Participate in code reviews and contribute to engineering standards and best practices.

## Requirements

**🧭 What makes you a great match:**

-   Strong SQL skills, including complex queries, CTEs, window functions, analytical queries, and query optimization (2+ years);
-   Strong experience integrating external data sources, including REST APIs, databases, SaaS platforms, and third-party systems;
-   Experience with Apache Airflow (2+ years);
-   Experience with Python for data processing, integrations, and automation (2+ years);
-   Good understanding of DWH concepts, including ETL/ELT, dimensional modeling, Data Vault, and Star/Snowflake schemas (2+ years);
-   Experience building and supporting production data pipelines with a focus on reliability, stability, monitoring, and error handling;
-   Understanding of data quality principles, including validation, testing, reconciliation, and monitoring;
-   Experience with Git

## Benefits

💸 **Flexible payment options:** choose the method that works best for you;  
🎁 **Financial perks:** Bonuses for holidays, B-day, work milestones and more - just to show we care;  
📈 **Learn & grow:** We cover courses and certifications — and offer real opportunities to grow your career with us;  
🥐 **Benefit Сafeteria:** Choose what suits you — sports, language courses, therapy sessions, and more;  
🎉 **Stay connected:** From team-building events to industry conferences — we bring people together online, offline, and on stage;  
💻 **Modern Equipment:** We provide new laptops along with essential peripherals like monitors and headphones for a comfortable workflow;  
🕘 **Your schedule, your rules:** Start your day at 9, 10, or even 11 — we care about results, not clock-ins.

## Apply

[Apply at Gypsy Collective](https://apply.workable.com/gypsy/j/882F9752E3/apply)

---
Powered by [Workable](https://www.workable.com)