MARKETING DATA ANALYST
UP TO £50,000
LONDON – HYBRID (2X PER WEEK IN OFFICE)
*Please note, you must be a UK resident and hold full right to work*
ABOUT THE BUSINESS
This is a brand and social impact agency with over 20 years’ experience helping organisations connect meaningfully with young people. A core part of the business focuses on deep engagement with the UK and Ireland education systems, working in partnership with schools and delivering education-led campaigns at scale.
Data sits at the heart of how the agency operates. There is a strong emphasis on data quality, accuracy, and insight-led storytelling, with analytics directly shaping campaign outcomes, forecasts, and strategic decisions.
THE DATA TEAM
You’ll join a close-knit, collaborative team where autonomy, chemistry, and accountability are essential.
The team acts as a central triage point for the wider agency, supporting a broad range of data-driven questions and requests across campaigns, products, and clients. You’ll work alongside analysts and data specialists while partnering closely with senior stakeholders across the business.
THE ROLE
This is a varied, fast-paced, agency-style Data Analyst role combining hands-on analysis, forecasting, CRM insight, and increasing client-facing engagement over time.
You’ll take ownership of incoming data requests, analyse client-provided datasets (often Excel-heavy), and ensure all outputs are accurate, robust, and commercially meaningful. The role directly influences campaign outcomes and business forecasts, making accountability and confidence in methodology critical.
KEY RESPONSIBILITIES
Analysis & Insight
* Act as a triage point for incoming data questions and analysis requests.
* Analyse client-provided datasets in multiple formats, often working with complex Excel files.
* Translate data into clear, insight-led narratives for internal and external stakeholders.
Forecasting & Modelling
* Support campaign forecasting and modelling, including predicting school registrations.
* Advise on channels, timelines, and expected outcomes based on data-led assumptions.
* Contribute to the development of longer-term forecasting capability.
Data Quality & Methodology
* Ensure consistently high standards of data quality, accuracy, and validation.
* Confidently explain methodology and analytical approach for high-impact work.
* Take ownership of outputs that influence campaign delivery and business planning.
Systems & Reporting
* Work with a relational database supporting an education-focused partnership product.
* Use SQL-driven analysis to feed Power BI dashboards and reporting.
* Select appropriate tools and techniques depending on data structure and campaign needs.
SKILLS & EXPERIENCE REQUIRED
Essential
* Advanced Excel skills (VLOOKUP/XLOOKUP, conditional formatting, charts, visualisation).
* SQL experience (joins, selects, data manipulation).
* Comfortable working with relational databases.
* Power BI for reporting and data visualisation.
Nice to Have
* Python or R (interest is sufficient; not essential).
* Exposure to forecasting beyond basic historical analysis.
IDEAL CANDIDATE PROFILE
* Midweight analyst with 3–5 years’ experience and proven delivery capability.
* Strong preference for marketing or agency backgrounds.
* Experience working with CRM or customer databases, campaign selection, and segmentation.
* Comfortable operating in fast-paced, reactive environments.
* Strong data storytelling skills and ability to translate insight into human narratives.
Personal Attributes
* Confident taking ownership and responsibility.
* Comfortable answering questions on methodology and approach.
* Collaborative, pragmatic, adaptable, and a strong cultural fit for a small team.
WHY APPLY?
* Join a purpose-led agency where data directly influences real-world outcomes.
* Take ownership in a business-critical role with visibility and impact.
* Work across analysis, forecasting, CRM insight, and client-facing projects.
* Be part of a growing data function with clear long-term progression and salary growth.