At a Glance
- Tasks: Analyse data, forecast trends, and create impactful insights for clients.
- Company: Purpose-driven agency with over 20 years of experience in education.
- Benefits: Salary up to £60,000, hybrid working, and a chance to make a difference.
- Why this job: Join a team where your data skills can shape real-world outcomes.
- Qualifications: Advanced Excel, SQL, and Power BI skills required.
- Other info: Dynamic role with opportunities for mentoring and professional growth.
The predicted salary is between 43200 - 72000 £ per year.
ABOUT THE BUSINESS
This is a brand and social impact agency with over 20 years’ experience helping organisations connect meaningfully with 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.
Customer Insights Analyst in London employer: Harnham
Contact Detail:
Harnham Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Customer Insights Analyst in London
✨Tip Number 1
Network like a pro! Reach out to people in the industry, attend events, and connect on LinkedIn. We can’t stress enough how personal connections can open doors that applications alone can’t.
✨Tip Number 2
Prepare for interviews by practising common questions and showcasing your analytical skills. We recommend using real data examples from past experiences to demonstrate your expertise in Excel and SQL.
✨Tip Number 3
Don’t just apply; follow up! After submitting your application through our website, drop a quick email to express your enthusiasm. It shows initiative and keeps you on their radar.
✨Tip Number 4
Tailor your approach for each role. Research the company’s values and mission, and align your insights with their goals. We want to see how you can contribute to their success!
We think you need these skills to ace Customer Insights Analyst in London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV speaks directly to the role of Customer Insights Analyst. Highlight your advanced Excel skills, SQL experience, and any relevant forecasting work you've done. We want to see how your background aligns with our needs!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to tell us why you're passionate about data analysis and how you can contribute to our mission. Be sure to mention your experience with data storytelling and client engagement.
Showcase Your Analytical Skills: In your application, don’t just list your skills—show us how you've used them in real-world scenarios. Whether it's through past projects or specific achievements, we want to see your analytical prowess in action!
Apply Through Our Website: We encourage you to apply directly through our website for the best chance of getting noticed. It’s the easiest way for us to keep track of your application and ensure it reaches the right people!
How to prepare for a job interview at Harnham
✨Know Your Data Inside Out
Before the interview, make sure you’re familiar with the types of data analysis mentioned in the job description. Brush up on your Excel skills and SQL knowledge, as you might be asked to demonstrate your ability to manipulate data or explain your analytical approach.
✨Prepare Insightful Narratives
Practice translating complex data into clear, actionable insights. Think about how you would present your findings to both technical and non-technical stakeholders. Being able to tell a compelling story with data will set you apart from other candidates.
✨Showcase Your Forecasting Skills
Be ready to discuss your experience with forecasting and modelling. Prepare examples of how you've predicted outcomes based on data-led assumptions in previous roles. This will demonstrate your ability to contribute to campaign forecasting effectively.
✨Familiarise Yourself with Reporting Tools
Since the role involves using Power BI for reporting, it’s a good idea to have a basic understanding of how it works. If you can, create a simple dashboard or visualisation to showcase during the interview. This hands-on experience will show your enthusiasm and readiness for the role.