DWH Engineer

This is a fully remote position, open to applicants in Ukraine, +1 more country.

📋 Description

• Design and maintain Data Warehouse (DWH) and Data Lake solutions that meet business needs.

• Construct, enhance, and support ETL/ELT pipelines utilizing Python, SQL, Airflow, and associated technologies.

• Integrate and sustain data flows from APIs, databases, SaaS platforms, and external systems.

• Collaborate with Trino and cloud-based analytical platforms to fulfill reporting and analytics requirements.

• Implement and manage incremental loading, Change Data Capture (CDC) processes, backfills, and reprocessing workflows.

• Monitor, diagnose, and enhance data pipelines to ensure reliability, stability, and prompt data delivery.

• Establish data quality checks, validation rules, and automated monitoring systems.

• Optimize SQL queries, data models, and the performance of data pipelines.

• Work alongside analysts, BI developers, engineers, and business stakeholders to create scalable data solutions.

• Engage in code reviews and contribute to the establishment of engineering standards and best practices.

⛳️ Requirements

• Proficient in SQL, including complex queries, Common Table Expressions (CTEs), window functions, analytical queries, and query optimization (2+ years).

• Significant experience in integrating external data sources, such as REST APIs, databases, SaaS platforms, and third-party systems.

• Experience with Apache Airflow (2+ years).

• Proficient in Python for data processing, integrations, and automation (2+ years).

• Strong understanding of DWH concepts, including ETL/ELT, dimensional modeling, Data Vault, and Star/Snowflake schemas (2+ years).

• Experience in building and supporting production data pipelines, emphasizing reliability, stability, monitoring, and error handling.

• Familiarity with data quality principles, including validation, testing, reconciliation, and monitoring.

• Experience with Git.

🏝️ Benefits

• Flexible payment options: choose the method that works best for you.

• Bonuses for holidays, birthdays, work milestones, and more.

• Courses and certifications covered.

• Opportunities for career growth.

• Benefit cafeteria including sports, language courses, therapy sessions, and more.

• Team-building events and industry conferences, both online and offline.

• Provision of new laptops and essential peripherals such as monitors and headphones.

• Flexible start times at 9, 10, or 11 AM.