Customer Insights Analyst

LEAD DATA ANALYST (Marketing/Agency)

UP TO £60,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 the UK and Ireland education systems!

THE ROLE

This is a varied, fast-paced, agency-style Lead 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
• SQL experience (joins, selects, data manipulation)
• Comfortable working with relational databases
• Power BI for reporting and data visualisation
• Exposure to forecasting beyond basic historical analysis
• Mentoring experience

WHY APPLY?

• Salary up to £60,000
• Join a purpose-led agency where data directly influences real-world outcomes.
• Hybrid working