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 - 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.