Data Warehouse Engineer — Flexible Schedule & Growth

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

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.