Data Analyst with MMM & Consumption Data

Job Role/Main Tasks

• Validate, transform and prepare (mostly) sales as well as media and other MMM input datasets.
• Conduct exploratory data analysis (EDA) to identify trends, outliers, inconsistencies and data quality issues.
• Investigate and resolve data discrepancies across markets and multiple data sources.
• Run and troubleshoot Python scripts used for data processing, reporting and MMM delivery.
• Write and execute SQL queries for data extraction and validation.
• Support and maintain automated PowerPoint deck generation and reporting processes.
• Validate and reconcile results across Power BI, PowerPoint outputs and source databases.
• Provide analytical and operational support to MMM SMEs, ensuring timely and accurate delivery of project outputs.

Ideal Experience

• Data Analyst or Analytics Consultant with strong data exploration and validation experience.
• Experience working with sales, consumption, EPOS or retail datasets.
• Experience working with media datasets, including traditional (TV, OOH) and digital channels.
• Strong Python skills for data manipulation, analysis and process support.
• Good SQL skills for data extraction and validation.
• Strong Excel and PowerPoint skills.
• Understanding of Marketing Mix Modelling (MMM) and marketing analytics. MMM - Running base model, supporting MMM or Marketing Analytics projects.
• Desirable: Power BI, Databricks

Personal Skills

• Proactive, independent and self-driven.
• Curious and investigative; enjoys getting to the root cause of issues.
• Strong attention to detail and data quality.
• Able to manage multiple tasks and priorities simultaneously.
• Strong problem-solving skills.
• Comfortable working with both technical teams and business stakeholders.
• Clear communicator with a collaborative mindset.