DWH Engineer

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.

Visit website

We’re Gypsy Collective — a digital entertainment team that transforms work into an expedition. For five years, we’ve been charting new territories and creating our path instead of following others.

We are a team of 100+ free-spirited professionals thriving in a remote-first environment, where you can work from anywhere and turn every project into an adventure.

At Gypsy, we strip away the corporate fluff to create a place where you can truly make your mark. Our culture is about how we put our principles into action every day.

We're human-powered – placing people at the heart of everything we do, because that's how we thrive together.

We believe in clear connections – speaking honestly, sharing openly, and building trust that fuels real progress.

We stay in growth motion – taking risks, adapting quickly, and turning challenges into stepping stones.

And we're always exploring – pushing boundaries with genuine curiosity to discover what's next.

This isn't just who we want to be — it's who we are. Modern wanderers connect cultures through play, make important decisions, and celebrate our shared journey along the way.

Team up and roam with us.