About the company
MediaRadar equips marketing, sales, and analytics leaders with intelligence on ad strategy, media spend, creative assets, and brand messaging across 30+ media channels and five million brands.
Responsibilities
- Design, build, and optimize robust ETL/ELT pipelines that move and transform millions of daily data points reliably and efficiently.
- Build and maintain production data workflows using tools such as dbt, ClickHouse, and open-source orchestration frameworks (Airflow, Dagster, or similar).
- Write and optimize complex SQL — schema design, indexing, performance tuning, query optimization, and root-cause analysis.
- Contribute to the migration away from Azure Databricks toward an AWS-based stack.
- Help build proofs-of-concept to benchmark new tools and patterns.
- Use AI coding assistants to accelerate pipeline development, SQL generation, debugging, testing, and documentation.
- Implement testing, validation, monitoring, observability, and CI/CD practices.
- Understand upstream and downstream systems to ensure clean, end-to-end data delivery.
- Partner with engineers in North America and India, participate in code reviews.
Requirements
- 4-7+ years in data engineering / ETL with a strong track record as a hands-on engineer.
- Strong SQL and RDBMS skills with experience in schema design, performance tuning, and complex query optimization.
- Hands-on experience with dbt, ClickHouse, and open-source pipeline/orchestration tools (Airflow, Dagster).
- Strong proficiency in Python for building and automating data pipelines.
- Hands-on experience using AI coding assistants (GitHub Copilot, Claude, ChatGPT) with judgment to verify and refine AI-generated code.
- Hands-on experience with a major cloud platform; AWS strongly preferred.
- Comfortable with Git, code reviews, and writing tested, maintainable code.
- Bachelor's or Master's degree in Computer Science or related field, or equivalent experience.
Conditions
- Remote-based in Madrid with periodic in-person collaboration at a local WeWork space.
- Equal Opportunity Employer.