Amazon Marketing Cloud (AMC) & DSP Data Analyst - Barcelona

You’ve built experience, now use it where bold ideas meet real impact. At Opella, we’re challenging how self-care works for millions of people and need leaders and experts ready to shape what’s next. As an Amazon Marketing Cloud & DSP Data Analyst, you’ll bring your skill, your curiosity and your drive to make health simpler, smarter and more human.

About the Job

We are looking for a data-driven technically strong AMC & DSP Data Analyst to support and lead advanced measurement and analytics across our in-house Amazon & Omnichannel DSPs activation in 10+ international markets.

In this role, you will work with large-scale campaign data—primarily through Amazon Marketing Cloud (AMC)—to generate actionable insights on performance, attribution, and incrementality.

This role is heavily focused on:

• SQL-based analysis in Amazon Marketing Cloud (AMC)
• Advanced campaign diagnostics and media effectiveness evaluation
• Attribution modelling and incrementality frameworks
• Structuring data for Marketing Mix Modelling (MMM) inputs

You will work at the intersection of programmatic activation and data science, translating large-scale impression-level and event-level data into strategic recommendations that drive incremental growth and capital efficiency.

Main responsibilities:

• Perform advanced SQL analysis in Amazon Marketing Cloud (AMC) (complex queries, joins, CTEs, window functions)
• Build user-level path-to-conversion analyses and optimize frequency & audience strategies
• Analyze campaign performance, audience overlap, and cross-campaign interactions
• Quantify incrementality, attribution, and halo effects across products and channels
• Support transition from ROAS-based to incrementality-driven measurement frameworks
• Structure and transform data for MMM inputs, scalable datasets, and reporting automation
• Develop data models and dashboards (Power BI / Tableau / Looker) ensuring data quality and cross-market consistency

About You:

• 3–4 years’ experience in digital advertising analytics, programmatic, or retail media environments (agency, AdTech, DSP)
• Strong expertise in SQL and ability to work with large datasets (Python/R as a plus)
• Solid understanding of programmatic ecosystems and auction dynamics (e.g. Amazon DSP, DV360, TTD)
• Experience or exposure to data clean rooms (e.g. AMC) and advanced analytics environments
• Good knowledge of attribution models, incrementality testing, and media measurement frameworks (MMM exposure as a plus)
• Comfortable working with imperfect data, ambiguity, and complex analytical problems
• Analytical, hypothesis-driven, and commercially minded, with the confidence to challenge performance narratives using data

This is more than the next step in your career, it’s a chance to lead change and help reinvent self-care for the world. If you’re ready to challenge, inspire and deliver impact that matters, we’re ready for you. We are challengers. We are Opella.

About Us:

Opella is the self-care challenger with the purest and third-largest portfolio in the Over The Counter (OTC) & Vitamins, Minerals & Supplements (VMS) market globally.  

Our mission is to bring health in people’s hands by making self-care as simple as it should be. For half a billion consumers worldwide – and counting.

At the core of this mission is our 100 loved brands, our 11,000-strong global team, our 13 best-in-class manufacturing sites and 4 specialized science and innovation development centers. Headquartered in France, Opella is the proud maker of many of the world’s most loved brands, including Allegra, Buscopan, Doliprane, Dulcolax, Enterogermina, Essentiale and Mucosolvan.

As a globally certified B Corp company, we are active players in the journey towards healthier people and planet. Find out more about our mission at www.opella.com.

#LI-HYBRID