Remote Middle Data Engineer

Description:

• We are hiring a Middle Data Engineer to build and operate reliable ELT/ETL pipelines on Snowflake and Airflow.
• You will consolidate data from databases, REST APIs, and files into trusted, documented datasets with clear SLAs and ownership.
• Responsibilities include ingesting data from RDBMS/APIs/files into Snowflake using batch/incremental methods and CDC when applicable.
• You will build modular SQL/Python transformations, handle semi-structured JSON, and publish consumer-read tables/views.
• You will orchestrate Airflow DAGs, managing dependencies, retries, backfills, and SLAs, along with monitoring and alerting.
• Ensuring idempotent re-runs/backfills, maintaining runbooks, and performing root cause analysis for incidents will be part of your duties.
• You will tune performance and cost in Snowflake, focusing on warehouse sizing, pruning, and clustering when justified.
• Partnering with BI/Analytics to refine definitions and SLAs for delivered datasets is also expected.

Requirements:

• You should have 2–4 years of experience building production ETL/ELT, with strong SQL skills (including joins and window functions) and Python for data tooling.
• Hands-on experience with Snowflake is required, including knowledge of Streams, Tasks, Time Travel, and performance and cost basics, as well as JSON handling.
• Proficiency in Airflow is necessary, including the ability to create reliable DAGs, manage retries/backfills, and set up SLAs, monitoring, and alert routing.
• A solid understanding of data warehousing/modeling (Kimball/3NF), schema evolution, and API integrations (including authentication, pagination, rate limits, and idempotency) is essential.
• Experience with Git-based CI/CD, clear written English communication skills, and a basic understanding of privacy/GDPR are required.

Benefits:

• You will have direct cooperation with an already successful, long-term, and growing project.
• Flexible work arrangements are offered to accommodate your needs.
• The position includes 20 days of vacation.
• A truly competitive salary will be provided.
• You will receive help and support from our caring HR team.