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.

• 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 Postgre
  
  SQL, Trino, and Big Query.
• 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.

• 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:
  Big Query, Snowflake, Redshift, Click House, 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).

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

• Flexible payment options: choose the method that works best for you.
• Financial perks:
  Bonuses for holidays, birthdays, 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.
• Cafeteria benefits:
  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.