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