XCM
Junior Data Analyst
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Junior Data Analyst
The Role
XCM is looking for a Junior Data Analyst to join our growing team. This is a great opportunity for someone early in their analytics career to build hands-on experience across SQL, reporting, and campaign insight.
We're looking for someone with some working knowledge of SQL, solid Excel skills, and a genuine interest in using data to understand performance. You'll work across a range of sectors including Retail, Sports, and Gaming, supporting industry-leading brands with clear, actionable insights.
You'll be part of a collaborative and supportive team, working closely with Data Analysts, the Client Team, and wider stakeholders. You'll get hands-on training and mentorship as you help answer business questions, measure campaign performance, and support clients in making data-driven decisions.
This role is ideal for someone who's keen to learn, has great communication skills, enjoys problem-solving with data, and wants to develop their skills in a fast-moving, supportive environment.
What You'll Be Doing
- Supporting end-to-end analysis for client and internal requests, from quick-turn insight to deeper performance reviews — with guidance from senior team members
- Using SQL to extract and work with datasets, building confidence with more complex queries over time
- Helping build and maintain visual reporting and insight outputs using XCM's Horizon BI tool
- Supporting the measurement of performance and ROI across online and offline marketing activity
- Assisting with analysis of customer and campaign behaviour across channels including Email, Web & onsite behaviour, SMS, Direct mail and Social & engagement trends
- Reporting on marketing and customer KPIs such as leads, conversion rate, traffic, engagement, and revenue impact
- Contributing to insight and recommendations that feed into campaign optimisation and planning
- Supporting BAU reporting schedules and helping with ad-hoc analysis requests
- Helping create clear, visually impactful outputs (reports, decks, dashboards)
- Contributing to larger analytical projects and roadmap work as part of the wider team
- Sharing insight with colleagues, with opportunities to build confidence presenting to clients over time
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
What We're Looking For
- Some SQL experience — comfortable writing basic queries, keen to develop this further
- Good Excel skills — familiar with formulas, pivots, and working with spreadsheets
- Willingness to manage multiple priorities and work to deadlines
- Good analytical thinking — an eye for spotting trends and inconsistencies in data
- Able to communicate clearly, including with non-technical colleagues
- Proactive and organised — keen to take ownership and grow into the role
- Collaborative mindset — enjoys working with others and learning from the team
- Exposure to BI / visualisation tools — Superset would be a strong advantage
- Interest or experience in marketing, CRM, ecommerce, or customer analytics
- Any exposure to big data environments, warehouses, or automated reporting
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Why XCM?
- Fully remote working with a strong team support network
- Exposure to high-profile clients across exciting sectors
- Varied work: BAU reporting, campaign insight, and strategic analytics
- Structured support and mentorship to grow your technical skillset and analytical capability
- A team that values collaboration, quality, and continuous improvement
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location