DWH Engineer

Gypsy Collective

. Develop and maintain DWH and Data Lake solutions aligned with business requirements .

Posted 10/16/2026full-timeRemote • Ukraine, PolandJuniorMid-LevelWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in developing and maintaining Data Warehouse and Data Lake solutions, with strong capabilities in ETL/ELT processes, data integration, and pipeline optimization. Proficient in SQL, Python, and Apache Airflow, ensuring data quality and reliability in analytics environments.

Highest-signal resume keywords

SQL Query OptimizationETL/ELT Pipeline DevelopmentData Integration from APIsApache Airflow ExperienceData Quality Principles

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLPythonETLELTData Warehouse ConceptsData ModelingIncremental LoadingCDC ProcessesData Quality ChecksQuery Optimization

Tools & Technologies

Apache AirflowGitData LakeAPIsSaaS PlatformsCloud-Based Analytical Platforms

Industry Keywords

Data VaultStar SchemaSnowflake SchemaData Pipeline MonitoringError Handling

Tech Stack

Tools & technologies

AirflowApacheCloudETLPythonSQLVault

About the role

Key responsibilities & impact

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 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 for reliability, stability, and timely data delivery
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 on scalable data solutions
Participate in code reviews and contribute to engineering standards and best practices

Requirements

What you’ll need

Strong SQL skills, including complex queries, CTEs, window functions, analytical queries, and query optimization (2+ years)
Strong experience integrating external data sources, including REST APIs, databases, SaaS platforms, and third-party systems
Experience with Apache Airflow (2+ 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 (2+ 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
Experience with Git

Benefits

Comp & perks

Flexible payment options: choose the method that works best for you
Bonuses for holidays, B-day, work milestones and more
Courses and certifications covered
Opportunities to grow your career
Benefit cafeteria including sports, language courses, therapy sessions, and more
Team-building events and industry conferences, online and offline
New laptops and essential peripherals such as monitors and headphones
Flexible start time at 9, 10, or 11