Senior Data Engineer — Real-Time AdTech & AI Pipelines

MWDN; Madrid; On-site; EUR 60,000 - 90,000; Full time

Benefits offered by this job

29 days PTO

Free English classes

HR support for contractors

Flexible working hours

Job summary

MWDN seeks a Senior Data Engineer to design and build high‑performance data systems for programmatic advertising. You will process millions of ad transactions in real time, architect scalable pipelines, and collaborate with a global engineering team.

You'll work across data sources, data models, and analytics to optimize yield, latency, and accuracy, while ensuring GDPR/CCPA compliance and clean data infrastructure for partners.

Qualifications

• 5+ years of professional data engineering experience.
• 2+ years working with programmatic advertising or ad-tech data.
• Strong proficiency in Python and SQL.
• Experience with streaming data platforms (Kafka, Kinesis, Pub/Sub).
• Hands-on with data warehouses (BigQuery, Snowflake, Redshift, ClickHouse).
• Experience with batch processing frameworks (Spark, dbt, Airflow).
• Understanding of ad-tech data structures: bid requests, impressions, OpenRTB schemas, log-level data.
• Experience with cloud platforms (AWS, GCP) and infrastructure-as-code.

Responsibilities

• Design and build scalable data pipelines for processing bid stream, impression, and revenue data from programmatic sources.
• Ingest and normalize data from multiple SSPs, DSPs, ad servers (GAM), and third-party reporting APIs.
• Build real-time and batch processing systems for auction analytics, win rate analysis, and bid landscape modeling.
• Develop ETL/ELT workflows to transform raw programmatic data into analytics-ready datasets.
• Create data models for yield optimization, floor price analysis, and demand partner performance.
• Build and maintain data warehouses and lakes optimized for ad-tech query patterns.
• Implement data quality monitoring, validation, and anomaly detection for programmatic data streams.
• Support BI and analytics teams with clean, documented, and performant data infrastructure.
• Ensure data privacy compliance (GDPR, CCPA) in data collection, storage, and processing.

Skills

Python

SQL

Data engineering

Programmatic advertising

Streaming data

Kafka

Kinesis

Pub/Sub

BigQuery

Snowflake

Redshift

ClickHouse

Spark

dbt

Airflow

AWS

GCP

IaC

OpenRTB

log-level data

Tools

Kafka

Kinesis

Pub/Sub

BigQuery

Snowflake

Redshift

ClickHouse

Spark

dbt

Airflow

AWS

GCP

Job description

MWDN seeks a Senior Data Engineer to design and build high‑performance data systems for programmatic advertising. You will process millions of ad transactions in real time, architect scalable pipelines, and collaborate with a global engineering team.

You'll work across data sources, data models, and analytics to optimize yield, latency, and accuracy, while ensuring GDPR/CCPA compliance and clean data infrastructure for partners.