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:

AMC Advanced SQL Analytics

• Write complex SQL queries in AMC (joins, nested queries, window functions, CTEs)
• Build user-level path-to-conversion analyses
• Conduct frequency distribution and optimal frequency modelling
• Analyze audience overlap and cross-campaign interaction
• Quantify halo effects and cross-product impact
• Perform tentpole and time-series event analysis
• Create reusable query frameworks for multi-market scalability

Attribution, Incrementality & Measurement Frameworks

• Support transition from platform-reported ROAS to incrementality-informed performance evaluation
• Contribute to multi-touch attribution thinking within AMC limitations
• Structure DSP outputs for MMM ingestion (clean data structuring, channel harmonization)
• Support test & learn roadmap (holdouts, audience exclusions, bid strategy experiments)

Strong understanding of:

• Last-touch vs multi-touch limitations
• Causality vs correlation

Data Engineering & Visualization

• Transform AMC outputs into scalable datasets
• Build structured data models for reporting automation
• Develop dashboards in Power BI / Looker / Tableau
• Ensure consistency across markets and brands
• Validate data integrity and detect anomalies

About You:

• 3–4 years’ experience in digital advertising analytics, retail media, or programmatic environments
• Experience working in media agency, DSP, AdTech, or Retail Media Network
• Exposure to data clean room environments
• Understanding of programmatic auction mechanisms

• Advanced SQL, Python or R for statistical analysis

• Strong working knowledge of programmatic media/ Amazon DSP ecosystem
• Hands-on experience with Amazon Marketing Cloud (AMC) as a strong plus
• Experience analyzing large datasets
• Strong understanding of attribution models and media KPIs
• Comfort working with imperfect data and ambiguity
• Experience contributing to or building Marketing Mix Models (MMM)
• Knowledge of incrementality testing methodologies

The profile we’re looking for is:

• Analytical and hypothesis-driven
• Commercially aware - understands business impact, not just statistical output
• Structured thinker with strong documentation habits
• Comfortable challenging performance narratives with data
• Curious and intellectually rigorous

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