Data Analyst with MMM & Consumption Data

Data Analyst with MMM & Consumption Data
6 Months Contract
Inside IR35
Remote/1 day onsite a month
Bankside

My client a top Global company are currently looking to recruit a Data Analyst with Marketing Mixed Modelling (MMM) experience working with Consumption and Media Data to join their team on a 6-month contract basis. Please note if successful this position will need to set up via an Umbrella Company/PAYE. The MMM project includes all work pertaining to improving media spend coverage of Marketing Mix Modelling from 65% to 80% at our client through availability of Marketing Mix Models (in-house and outsourced to a modelling partner).

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 6+ years. 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.

Guidant, Carbon60, Lorien & SRG - The Impellam Group Portfolio are acting as an Employment Business in relation to this vacancy.