Business Intelligence Analyst

Business Intelligence Analyst

Department: Finance

Employment Type: Full Time

Location: Liphook (Office Based)

Compensation: £45,000 - £55,000 / year

Rocksteady Music School is the UK’s largest rock and pop school. We teach fun and inclusive in‑school band lessons to primary age children. Our mission is simple: to amplify children's self‑belief and remove barriers to music education. We’re currently in thousands of schools in the UK, teaching tens of thousands of children every week – and we’re growing fast. Our beautiful converted manor house in rural Liphook is home to our central office teams.

From there, we all play our part in supporting our band leaders to reach as many children as possible with their lessons. We are a community of music lovers using our individual talents to help give children the self‑belief to succeed. That’s what gets us out of bed in the morning. We are seeking a Business Intelligence Analyst to join our newly formed BI team.

This is an exciting opportunity to own the internal BI agenda in a rapidly growing business, where there is currently limited insight generation. Our primary in‑house operational system holds extensive backend data but has limited user‑facing analytics capabilities. We are now embarking on a strategic data‑transformation programme to unlock insights across the business and enable data‑driven decision‑making. This is a pivotal role in building our analytical capability from the ground up.

• Lead rigorous analysis across five priority business areas:
  • Sales efficiency and effectiveness
  • Customer retention analysis and programme engagement metrics
  • Market penetration and addressable market analysis
  • Staff retention and employee performance analysis
  • Customer performance profiling and ideal customer profile development
• Be instrumental in translating business requirements into analytics, validating data quality, and designing dashboards that drive business decisions.
• Work alongside a third‑party BI implementation partner who will build and maintain the underlying data warehouse infrastructure and semantic model.
• Focus on business partnership, metric definition, data validation, and stakeholder enablement.
• Conduct robust analytical investigations to uncover trends, root causes, and actionable insights, synthesising findings into clear, evidence‑based recommendations supported by high‑quality reporting for senior leaders and cross‑functional teams.
• Drive analytical excellence across the organisation by resolving data quality issues with stakeholders and technical partners, and establishing consistent methodologies, standards, and best‑practice approaches.
• Partner with business teams to define and prioritise reporting needs, designing and building coherent, connected dashboards that present complex data in clear, actionable visual formats while maintaining accuracy, consistency, and a single version of the truth.
• Maintain and evolve dashboards as requirements change, documenting logic and guidance, and supporting the shift toward self‑service BI by empowering users responsibly while upholding robust data governance.
• Define and validate business metrics, KPIs, and acceptance criteria; conduct thorough UAT across the data warehouse, semantic model, and dashboard outputs – ensuring accuracy through reconciliation against source systems, testing complex edge cases, and confirming structures, relationships, and filters behave as intended.
• Sign off data releases by confirming they meet business objectives, and document all data definitions, assumptions, and standards to ensure consistent interpretation and reliable use of metrics across the organisation.
• Partner closely with business teams to understand their analytical needs, explain data definitions and methodologies, present insights in clear, non‑technical language, and support stakeholders in interpreting and acting on findings.
• Serve as the primary contact for analytical queries, championing data quality and consistency while gathering feedback to iterate and improve reports, dashboards, and analytical outputs as the business scales.