DWH Engineer

🔥 1 hour ago

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Gypsy Collective

WebsiteLinkedInAll Job Openings

11 - 50 employees

Founded 2020

🎯 Recruiter

🏪 Marketplace

📣 Marketing

Recruitment • Marketplace • Marketing

Gypsy Collective is a roaming talent and partnerships collective that connects independent digital and performance-focused talent with brands and companies across 20+ markets. They position themselves as a performance-first partner that builds digital teams, facilitates brand partnerships, and runs events to create real-world connections and market access. Born to close the gap between businesses and the people who scale them, Gypsy emphasizes speed, partnership, and outcomes over volume, and has operated consistently for five years.

📋 Description

• **📅 Your adventures include:** • - design, 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 PostgreSQL, 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.

🎯 Requirements

• **🧭 What makes you a great match: ** • - strong SQL skills, including complex queries, CTEs, window functions, analytical queries, and query optimization (3+ years); • - strong experience integrating external data sources, including REST APIs, databases, SaaS platforms, and third-party systems; ability to design, develop, troubleshoot, and maintain reliable data ingestion processes in production environments (3+ years); • - experience with Apache Airflow or similar workflow orchestration tools (3+ 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 (3+ 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; • - hands-on experience with PostgreSQL and Trino in production environments; • - experience with modern analytical databases or cloud data warehouses (such as BigQuery, Snowflake, Redshift, ClickHouse, Vertica, Athena, or similar platforms.); • - experience with Git and collaborative development workflows (pull requests, code reviews, rebasing, merge conflict resolution). • **⭐ Nice to Have** • - experience with Change Data Capture (CDC) tools and incremental loading strategies; • - experience with cloud platforms such as AWS, GCP, or Azure; • - familiarity with Docker and containerized environments; • - experience with streaming or near real-time data pipelines (Kafka); • - familiarity with dbt or similar data transformation frameworks; • - experience with data cataloging, lineage, or governance tools.

🏖️ Benefits

• - 💸 **Flexible payment options:** choose the method that works best for you. • - 🧾 **Tax assistance included: **we handle part of your taxes and provide guidance on the local setup. • - 🎁 **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.