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

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.

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

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

Location: Barcelona – Spain (Hybrid)
Team: E-commerce
Reports to: Head of Amazon DSP Strategy

Why us?

At Opella, you will enjoy doing challenging, purposeful work, empowered to develop consumer brands with passion and creativity. This is your chance to grow new skills and be part of a bold, collaborative, and inclusive culture where people can thrive and be at their best every day.

We Are Challengers.

We are dedicated to making self-care as simple as it should be. That starts with our culture. We are challengers by nature, and this is how we do things:

All In Together: We keep each other honest and have each other's backs.

Courageous: We break boundaries and take thoughtful risks with creativity.

Outcome-Obsessed: We are personally accountable, driving sustainable impact and results with integrity.

Radically Simple: We strive to make things simple for us and simple for consumers, as it should be.

Opella values diversity in all its forms and is committed to fostering a workplace where everyone can belong and excel. We welcome and encourage applications from people of all backgrounds.

Join us on our mission.

Health.

In your hands.

www.opella.com/en/careers

LI-HYBRID