DWH Engineer

Location: Remote from Ukraine or Poland

Company

hirify.global is a talent partner that helps selected brands attract and develop exceptional professionals.

What you will do

• Develop and maintain data warehouse and data lake solutions for analytics and business decision-making.
• Build, optimize, and support ETL/ELT pipelines using Python, SQL, Airflow, and related technologies.
• Integrate data from APIs, databases, SaaS platforms, and third-party systems.
• Work with Trino and cloud-based analytical platforms to support reporting and analytics.
• Implement incremental loading, CDC, backfills, reprocessing, data quality checks, and automated monitoring.
• Collaborate with analysts, BI developers, engineers, and business stakeholders while contributing to code reviews and engineering standards.

Requirements

• At least 2 years of experience with complex SQL, analytical queries, CTEs, window functions, and query optimization.
• At least 2 years of experience with Apache Airflow and Python for data processing, integrations, and automation.
• At least 2 years of experience with DWH concepts, ETL/ELT, dimensional modeling, Data Vault, and Star/Snowflake schemas.
• Experience integrating external data sources and supporting production data pipelines with monitoring, error handling, and reliability practices.
• Understanding of data quality principles, including validation, testing, reconciliation, and monitoring.
• Experience with Git.

Culture & Benefits

• Flexible payment options.
• Bonuses for holidays, birthdays, work anniversaries, and other milestones.
• Courses and certifications are covered, with opportunities for professional growth.
• Benefit cafeteria including sports, language courses, therapy sessions, and other options.
• Online and offline team-building events, industry conferences, and modern equipment including a laptop, monitor, and headphones.
• Flexible start time from 9:00 to 11:00, with focus on results rather than clock-ins.