Data Engineer

This is a fully remote position, open to applicants in Europe.

📋 Description

• Construct and oversee ingestion pipelines (REST APIs, SFTP, database replication) into Snowflake.

• Create dbt models across bronze/silver/gold layers adhering to established standards.

• Collaborate with third-party ESPs (DotDigital, Adestra, FastTrack): transferring segments, retrieving campaign events (opens, clicks, bounces, conversions).

• Design and maintain AWS Lambda functions for data extraction and reverse ETL processes.

• Develop data models for identity resolution, segmentation, and attribution purposes.

• Set up and manage Airflow DAGs for orchestration tasks.

• Execute data quality checks, monitoring, and alert systems.

• Oversee Snowflake and AWS infrastructure using Terraform.

• Investigate and address data incidents (pipeline failures, data quality challenges, PII exposure).

⛳️ Requirements

• Minimum of 4 years of experience in developing and deploying data pipelines using Python in a production environment (including testing, CI/CD, and error handling).

• At least 4 years of experience in crafting complex SQL queries, performance optimization, and Snowflake-specific tuning.

• In-depth experience with Snowflake: SnowPipe, external stages, RBAC, masking policies, and warehouses.

• Proficient with dbt Core for data transformation, testing, and incremental model creation.

• Familiarity with data warehouse design principles: star schemas, snowflake schemas, dimensions, facts, and slowly changing dimensions.

• Experience in developing and deploying ETL/ELT pipelines using Airflow or similar orchestration tools.

• Engaged in AI-native development workflows: regular use of AI coding tools (Copilot, Cursor, Claude Code, Kiro) for code generation, review, and debugging.

🏝️ Benefits

• Competitive salary.

• Flexible working environment and a supportive team culture.