Data Engineer (Airflow / Snowflake)

emagine Polska; Województwo mazowieckie; Remote; PLN 182,000 - 259,000; Full time

Job summary

emagine Polska is seeking a skilled Data Engineer focused on Apache Airflow and Snowflake. You will design and maintain data pipelines, optimize performance, and ensure data quality, working in a fully remote role.

The ideal candidate has 3+ years of experience, strong Python and SQL skills, and hands-on experience with cloud storage and dbt. You will collaborate with teams across the data platform and implement robust CI/CD.

Qualifications

• 3+ years of experience as a Data Engineer.
• Proficient in Python and SQL with strong data tooling.
• Hands-on experience with Apache Airflow and Snowflake.
• Experience building data pipelines and data modeling.
• Familiarity with dbt, S3 storage, and CI/CD.

Responsibilities

• Design, build, and maintain Airflow DAGs to load data into Snowflake.
• Develop pipelines ingesting data from APIs, databases, and files.
• Model and transform data using dbt and SQL.
• Optimize queries and Snowflake performance and costs.
• Set up monitoring, alerts, and error handling for pipelines.
• Ensure data quality through tests and documentation.

Skills

Python

SQL

Airflow

Data modeling

Testing with Pytest

Tools

Apache Airflow

Snowflake

dbt

AWS S3

Git

CI/CD

Docker

Kubernetes

Iceberg/Delta Lake

Great Expectations

Job description

Industry: IT

Rate: up to 160 pln/h net + VAT, B2B

Location: 100% remote

About role:

We are seeking a skilled and experienced Data Engineer specializing in Apache Airflow and Snowflake. The ideal candidate will have a strong background in designing and maintaining data pipelines, with a focus on performance optimization and data quality. Essential skills include proficiency in Python and SQL, alongside hands‑on experience with data modeling and cloud data storage solutions.

Main Responsibilities:

• Design, build, and maintain Apache Airflow DAGs in Python that load data into the Data Lake (S3) and Snowflake.
• Build pipelines that ingest data from APIs, databases, and files.
• Model and transform data with dbt.
• Tune SQL queries and Snowflake performance and cost.
• Set up monitoring, alerting, and error handling for pipelines.
• Protect data quality through testing and validation, and keep documentation current.

Key Requirements:

• 3+ years of experience as a Data Engineer.
• Apache Airflow: strong knowledge of operators, sensors, hooks, TaskFlow API, XCom, pools, backfills, and idempotent DAG design.
• Python: strong skills, with clean, testable code and pytest.
• SQL: advanced level, including window functions, CTEs, and query optimization.
• Snowflake: hands‑on experience with warehouses, stages, external volumes, COPY INTO.
• dbt: models, tests, macros, snapshots, and incremental models.
• AWS S3: Data Lake organization, partitioning, file formats (Parquet, JSON, CSV), and IAM policies.
• Git and CI/CD experience.
• English at B2 level or higher.

Nice to Have

• Docker and Kubernetes.
• Open table formats: Apache Iceberg or Delta Lake.
• Data quality and observability tools such as Great Expectations or Soda.
• Dimensional modeling (Kimball).