Erskine Stewart Melville
DATA AND REPORTING ANALYST
Get notified of more jobs like this · No spam, ever
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Data and Reporting Analyst
Job Reference: schooltalent/TP/11692/2730
Contract Type: Full Time Permanent
Salary: Remuneration is dependant on skills and experience
Working Hours: 36.25
Location: Edinburgh
Closing Date: 09/10/2026
Department: ICT
Region / Division: ESMS
Job Role: Operational/Professional Services
The Role
Erskine Stewart Melville are currently recruiting for a Data and Reporting Analyst to join the ICT Team on a permanent basis as soon as possible (subject to satisfactory pre-employment checks). The role is full-time, working 36.25 hours per week.
The salary range for the role is £34,023 to £37,690 per annum, dependant on skills and experience.
The role is based across the Queensferry Road and Ravelston sites.
Duties
The purpose of the role is to support the school's data systems and reporting processes as well as developing and maintaining reporting tools. The role will include duties such as:
- Supporting collection, storage and management of data
- Analysing data to identify trends, patterns and insights
- Developing and maintaining dashboards, reporting tools and data models.
The successful candidate must have experience of working with large and complex data sets and in developing and maintaining reports and dashboards. The successful candidate should hold a degree in a related field and possess strong analytical and problem solving skills. Experience with cloud-based data platform, familiarity with DPIAs and a relevant qualification in Power BI, SQL or Data Analytics is desirable, but not essential.
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.
To learn more about this role, please access the job description provided.
The closing date for this role is Friday 9th October at 12 noon. We anticipate interviews will be held shortly after.
Eligibility
ESM is unable to sponsor the employment of international workers in this role. International applicants will therefore be unable to apply for and secure a Skilled Worker visa. The successful candidate will only be able to take up this role if they can demonstrate an alternative right to work in the UK.
Benefits
Employees get access to a range of benefits including:
- Fee remission from Nursery to S6
- Free school lunches
- Free Sports’ Club membership, including access to pool and fitness suites
- 25 days annual holiday leave plus 10 days statutory holiday at Christmas and Easter, when the Schools are closed
- Paid moving house day
- Employer pension contributions of up to 8%
- Death in service benefit
- Family friendly policies, including enhanced maternity leave
- Membership of the ESM Discount and Benefits Scheme, including a range of discounts at 130,000 retail and entertainment locations
- Employee Assistance Service
- Cycle to work scheme
- Car leasing salary sacrifice scheme
- Annual professional review process
- Regular salary reviews
- Funding towards professional qualifications
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Values
We are looking for individuals who can embody and promote ESMS values of Kindness, Confidence, Resilience, Integrity, and Curiosity while role modelling behaviours in line with our school pillars of Ambition, Innovation, and Community.
About ESM
Welcome to Erskine Stewart Melville, a school for 3-18 year olds, in the heart of Edinburgh, where innovation thrives. We are committed to the individual ambitions of every student by pushing the boundaries of traditional academia.
Our school cultivates creativity, critical thinking, and collaboration. We empower our learners to dream big and surpass their own expectations, using progressive teaching and learning. Our approach provides an expansive range of academic and extra-curricular opportunities, as well as a dedicated wellbeing programme that supports the whole child.
The people that work for us are passionate, pioneering and strive for excellence in everything they do. We value the incredible contributions they make to school life, we invest in their careers and we support their ambitions so that they flourish professionally and personally.
“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