Data Engineer

About MediaRadar MediaRadar , equips marketing, sales and analytics leaders with the intelligence they need to stay ahead. Our platform delivers always-on, AI-enabled Creative, Competitive, Commercial and Market Intelligence—spanning ad strategy, media spend, creative assets and brand messaging across 30+ media channels and five million brands. With deep insights into more than 35 million ad and campaign assets and $280 billion in media spend, MediaRadar provides a single, interoperable source of truth that plugs seamlessly into enterprise analytics and AI systems. The result: faster, cleaner and more actionable intelligence that drives competitive advantage. About The Role We are looking for a Data Engineer who can join our Madrid-based team and help build the next generation of our data delivery platform, working closely with senior and principal engineers and engineering leadership across North America and India to design, build, and operate the pipelines that move and transform millions of data points every day. We are deliberately moving away from a locked-in, vendor-heavy stack toward a flexible, largely open-source architecture that keeps our options open. You will be in the engine room of that re-architecture — writing code, designing schemas, tuning queries, and helping prove out new tools before we adopt them at scale. What You've Done: 4-7+ years in data engineering / ETL, with a strong track record as a hands-on engineer building and operating production data pipelines Strong SQL and RDBMS skills with solid, hands-on experience schema design, performance tuning, complex query optimization Hands-on experience with tools such as dbt, ClickHouse, and open-source pipeline / orchestration tools (e.g., Airflow, Dagster), with the judgment to choose the right tool for the job Strong proficiency in Python (or a similar language) for building and automating data pipelines Hands-on experience using AI coding assistants and effective prompting techniques (e.g., GitHub Copilot, Claude, ChatGPT), with the judgment to verify, test, and refine AI-generated code and queries Hands-on experience with a major cloud platform; AWS strongly preferred, as we are standardizing on AWS as we move off Azure Databricks Comfortable with Git, code reviews, and writing tested, maintainable, well-documented code Bachelor's or Master's degree in Computer Science, Engineering, or a related field, or equivalent practical experience What You'll Do: 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 hands-on migration away from Azure Databricks toward a more open, flexible, AWS-based stack, minimizing disruption to high-volume daily data delivery Help build proofs-of-concept to benchmark new tools and patterns, and feed clear results back into the team's adoption decisions Use AI coding assistants and well-crafted prompts to accelerate pipeline development, SQL generation, debugging, testing, and documentation — always reviewing and validating output before it ships Implement testing, validation, monitoring, observability, and CI/CD practices so data stays accurate and pipelines stay healthy at scale Understand the systems upstream and downstream of your pipelines, from ingestion through to client-facing platforms, to ensure clean, end-to-end data delivery Partner with engineers in North America and India, participate in code reviews, and learn the nuances of the Advertising and Market Research domain Bonus Points (Nice to Haves) Experience with cloud data warehouses or lakehouse patterns (Snowflake, BigQuery, Redshift, or similar) Experience with streaming / real-time data technologies such as Kafka Familiarity with containerization (Docker, Kubernetes) and infrastructure-as-code (e.g., Terraform) Previous experience in Advertising, Media, or Market Research This is a hands-on builder role rather than a pure-architecture one — the deep platform-architecture and strategy ownership sits with our Senior / Principal Data Engineers, whom you will work alongside. You will spend your time building and operating production pipelines, tuning databases, and helping prove out the open-source tools that will shape our platform going forward. This role is remote-based in Madrid, with the expectation that you'll join the team in person at a local WeWork space periodically to collaborate closely with our Madrid-based tech team. At MediaRadar, we are committed to creating an inclusive and accessible workplace where everyone can thrive. We believe that diversity of backgrounds, perspectives, and experiences makes us stronger and more innovative. We are proud to be an Equal Opportunity Employer and make employment decisions without regard to race, color, religion, sex (including pregnancy, sexual orientation, or gender identity), national origin, age, disability, genetic information, or any other legally protected status. In accordance with the EEO-1 reporting requirements, we collect demographic data as part of our efforts to ensure fair and equitable hiring practices across all levels of our organization. A final compensation offer will ultimately be based on the candidate's location, skill level and experience, and the Company's pay equity. We are also committed to ensuring our recruitment process is accessible to all applicants. If you need a reasonable accommodation during the application or interview process, please contact us at [email protected] . We’re excited to meet people who share our values and want to build the future with us.