At a Glance
- Tasks: Analyse data to shape insights and influence marketing campaigns.
- Company: Dynamic agency at the intersection of marketing, data, and social impact.
- Benefits: Salary up to £50,000, hybrid working, and strong career progression.
- Why this job: Make a real impact on campaign strategies and business performance.
- Qualifications: Strong Excel and SQL skills; experience with Power BI is a plus.
- Other info: Collaborative culture with autonomy and opportunities for growth.
The predicted salary is between 36000 - 60000 £ per year.
This is an excellent opportunity to join a growing data function where you will play a central role in shaping analysis, forecasting and insight for a fast paced, mission led organisation. If you enjoy variety, autonomy and real ownership, this position gives you the chance to influence campaigns, data quality and business decision making from day one.
The Company
They are an established agency working at the intersection of marketing, data and social impact. With a close knit data team and a highly collaborative culture, they deliver insight driven work that directly supports large scale programmes across the UK and Ireland. They operate in a fast moving environment where quality, accuracy and clarity of insight are essential. Their data team acts as a central hub for the business, supporting stakeholders with forecasting, CRM insight, reporting and ad hoc analysis.
The Role
- Act as a triage point for incoming data requests from across the business
- Analyse client provided data, often Excel based, to extract insight and support campaign planning
- Support forecasting projects including expected registrations, channel mix and campaign outcomes
- Work with relational databases and contribute to SQL driven analysis feeding into Power BI dashboards
- Ensure data accuracy, quality and consistency across all outputs
- Provide clear explanations of methodology and approach for high impact analyses
- Build confidence and credibility with internal teams and gradually increase client facing work
- Take ownership of workloads, deliver to deadlines and support key business decisions
Your Skills And Experience
- Strong commercial experience working with Excel including lookups, pivot tables and visualisation
- Confident SQL skills including joins, selection and manipulation of relational data
- Experience using Power BI to build dashboards and data visualisation
- Ability to work with CRM and customer datasets in a campaign or marketing context
- Strong analytical thinking with the ability to translate insight into clear narratives
- Comfortable working in fast paced, agency style environments
- Exposure to forecasting techniques or an interest in developing this capability
- Python or R experience is beneficial but not essential
- Familiarity with the UK education landscape or an understanding of how schools operate is advantageous
- Confident communicator who can explain methods and take ownership of decisions
What They Offer
- Salary up to 50000
- Hybrid working with a minimum of two days per week in their London office
- Opportunity to work in a growing data function with strong long term progression
- Impactful work with real influence on campaign strategy and business performance
- Supportive, collaborative culture with a strong focus on autonomy
How To Apply
If this sounds like your next step, apply today to find out more.
Data Analyst - CRM and Customer employer: Harnham
Contact Detail:
Harnham Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Analyst - CRM and Customer
✨Tip Number 1
Network like a pro! Reach out to people in the industry, attend events, and connect on LinkedIn. We all know that sometimes it’s not just what you know, but who you know that can help you land that dream job.
✨Tip Number 2
Prepare for interviews by practising common questions and showcasing your analytical skills. We recommend using real-life examples from your experience with Excel or SQL to demonstrate your expertise. Show them you’re the perfect fit!
✨Tip Number 3
Don’t forget to follow up after interviews! A quick thank-you email can go a long way in keeping you top of mind. We suggest mentioning something specific from your conversation to make it personal.
✨Tip Number 4
Apply through our website for the best chance at landing the role. We’ve got all the latest openings, and applying directly shows your enthusiasm for the position. Let’s get you that Data Analyst gig!
We think you need these skills to ace Data Analyst - CRM and Customer
Some tips for your application 🫡
Tailor Your CV: Make sure your CV speaks directly to the skills and experiences mentioned in the job description. Highlight your Excel, SQL, and Power BI skills, and don’t forget to showcase any relevant experience with CRM datasets.
Craft a Compelling Cover Letter: Use your cover letter to tell us why you’re excited about this role and how your background aligns with our mission. Share specific examples of your analytical work and how it has influenced decision-making in past roles.
Showcase Your Analytical Skills: In your application, include examples of how you've used data to drive insights or support campaigns. We love seeing how you can translate complex data into clear narratives that impact business decisions.
Apply Through Our Website: We encourage you to apply directly through our website for a smoother process. It helps us keep track of your application and ensures you don’t miss out on any important updates!
How to prepare for a job interview at Harnham
✨Know Your Data Tools
Make sure you brush up on your Excel, SQL, and Power BI skills before the interview. Be ready to discuss how you've used these tools in past projects, especially in a CRM or marketing context. This will show that you can hit the ground running!
✨Understand the Company’s Mission
Take some time to research the company and its mission-driven approach. Be prepared to explain how your skills and experiences align with their goals, particularly in delivering insight-driven work that supports social impact. This will demonstrate your genuine interest in the role.
✨Prepare for Scenario Questions
Expect questions that ask you to solve hypothetical data challenges or analyse case studies. Practise articulating your thought process clearly, as this will showcase your analytical thinking and ability to translate insights into actionable narratives.
✨Showcase Your Communication Skills
Since the role involves building confidence with internal teams and potentially client-facing work, be ready to discuss how you've effectively communicated complex data insights in the past. Use examples that highlight your ability to explain methodologies and take ownership of decisions.