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.

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

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

Diversity & Inclusion

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.

#J-18808-Ljbffr

📌 Amazon Marketing Cloud (AMC) & DSP Data Analyst - Barcelona
🏢 Talent
📍 Barcelona