# DWH Engineer

**Company:** [Gypsy Collective](http://jobs.workable.com/companies/sHyNyhRNufeViFLJ4SdfEv.md)
**Location:** Remote
**Workplace:** remote
**Employment type:** Full-time
**Department:** Analytics

[Apply for this job](http://jobs.workable.com/view/9fbcb50b-2c53-49e3-9be1-2cffe74f8292)

## Description

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.

**📅 Your daily adventures include:  
**

-   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.

## Requirements

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

-   Strong SQL skills: complex queries, CTEs, window functions, analytical queries (5+ years experience);
-   Knowledge of Python or other scripting languages for data transformations (4+ years experience);
-   Deep understanding of DWH concepts: ETL/ELT, Data Vault, Kimball, Star/Snowflake schemas (5+ years experience);
-   Experience with Airflow or other data pipeline orchestrators (5+ years experience);
-   Hands-on experience with modern DWH and query engines: BigQuery, Snowflake, Redshift, ClickHouse, Vertica, AWS Athena, Trino (5+ years experience);
-   Confident use of Git; experience with team workflows (pull requests, rebasing, merge conflict resolution (5+ years experience);
-   Understanding of server and cloud infrastructure: basic skills in configuration, maintenance, monitoring, and load control (3+ years experience).  
    

**⭐ Nice to have:  
**

-   Experience with CDC tools and streaming data sources;
-   Knowledge of Docker, Kubernetes, and Infrastructure as Code (Terraform);
-   Experience with cloud platforms such as AWS, GCP, or Azure;
-   Familiarity with data governance, data cataloging, and lineage tools.

## 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.  
      
    _If this role sounds like a good fit for you, we’d love to hear from you — apply and tell us a bit about yourself._