DWH Engineer

Gypsy Collective; United States; Remote; USD 110,000 - 150,000; Full time

Benefits offered by this job

Holiday bonuses

Birthday bonuses

Career growth programs

Benefit Cafeteria

Team events & conferences

Modern equipment

Flexible start times

Job summary

Gypsy Collective is seeking a DWH Engineer to design, build, and maintain scalable data warehouse solutions that support analytics and business decision-making. You will handle the full data lifecycle—from ingestion and transformation to orchestration—collaborating with analysts, engineers, and business stakeholders to deliver reliable data platforms.

The role emphasizes building robust ETL/ELT pipelines, optimizing queries, ensuring data quality, and integrating data from diverse sources.

Qualifications

• Proficient SQL with complex queries, CTEs, window functions.
• Experience integrating REST APIs, databases, SaaS and third-party data sources.
• Hands-on with Apache Airflow (2+ years).
• Strong Python skills for data processing and automation.
• Solid understanding of DWH concepts: ETL/ELT, Data Vault, Star/Snowflake schemas.
• Experience building production data pipelines with reliability and monitoring.
• Familiarity with data quality principles, validation and reconciliation.
• Git version control experience.

Responsibilities

• Design, build, and maintain scalable DWH/Data Lake solutions.
• Develop and optimize ETL/ELT pipelines using Python, SQL, Airflow.
• Integrate data from APIs, databases, SaaS and third parties.
• Work with Trino and cloud analytics platforms for reporting.
• Implement incremental loading, CDC, backfills, and reprocessing workflows.
• Monitor pipelines for reliability, timing, and errors.
• Apply data quality checks and automated monitoring.
• Tune SQL and data models for performance.
• Collaborate with analysts, BI developers, engineers, and stakeholders.
• Participate in code reviews and engineering standards.

Skills

Strong SQL

REST APIs integration

Apache Airflow

Python for data processing

DWH concepts

Data quality & monitoring

Git

Collaboration with analysts/BI

Tools

Trino

Cloud platforms

Job 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 Collectiveis 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 Engineerto 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.

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

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.