Marketing Analyst

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.

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.

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

• 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.
• Python or R (interest is sufficient; not essential).
• Exposure to forecasting beyond basic historical analysis.

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.