Rocksteady Music School Limited

Business Intelligence Analyst Department: Finance Employment Type: Full Time Location: Liphook (Office Based) Compensation: £45,000 - £55,000 / year Description 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. As Business Intelligence Analyst you will: 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. As a Business Intelligence Analyst you'll need: Essential Experience in BI or data analysis, with strong SQL, advanced Excel, hands on dashboard development (Power BI/Tableau), and a proven track record of effective stakeholder collaboration. Solid understanding of relational databases, data validation, reconciliation, QA, and core ETL/data pipeline concepts. Strong problem solver with rigorous, evidence based thinking, able to structure complex problems and spot anomalies. Comfortable with ambiguity and translating business questions into clear analytical requirements. Ability to understand business context, define KPIs/metrics, and translate needs into analytical solutions. Confident engaging non technical stakeholders and prioritising work by business impact. Clear communicator who can explain technical concepts simply; collaborative, proactive, and able to manage multiple priorities. Ownership mentality and comfort working in a scaling, less structured environment. Desirable Experience in SaaS, education, or B2B services; implementing BI in early stage analytics environments. Knowledge of data governance, UAT, cloud platforms (Azure/AWS/GCP), semantic models, and self service BI. Benefits Hybrid Remote (3 days in office, 2 days remote) Salary £45,000-£55,000 per annum (depending on experience) 35 hours per week 28 days holiday plus bank holidays Free onsite parking Personal development opportunities Comprehensive benefits package including discounts on everyday purchases, free 24/7 GP service Enhanced maternity and paternity pay. Employee discount at nationwide music instrument retailers. Celebratory staff away days, Christmas parties and social events. Opportunities to work with the Rocksteady Foundation, reaching children and young people in charities and support groups across the UK. This role offers genuine growth potential. A successful candidate who delivers impact on the priority insight areas and demonstrates ownership of the BI agenda will have the opportunity to progress toward a senior or lead role within the BI function as we scale. Every once in a while, you get the chance to be part of something really special. When you join Rocksteady, you know immediately that you've found it. We might be growing fast but we pay special attention to protecting our unique working culture and ensuring everyone feels comfortable to be themselves at work. We look out for each other, welcome new colleagues as friends and stay true to our small company roots; rolling up our sleeves if a job needs doing, solving problems together and, most importantly, always putting the children first. Likeminded people are joining us and we're reaching more and more children with our lessons every week. We keep growing because we're driven by our passion for the life changing nature of music. Join us and use your skills for good. Your Passion. Their Future. Additional Information We are committed to safeguarding and promoting the welfare of all children and expect all our staff to share this commitment. As this role involves regular work with children and young people, and meets the definition of regulated activity, it is exempt from the Rehabilitation of Offenders Act 1974. Under the Rehabilitation of Offenders Act 1974 (Exceptions) Order 1975 you must disclose all unprotected unspent and spent cautions and convictions. Further details on what convictions must be declared can be found in the Government's Guidance on the Rehabilitation of Offenders Act 1974 and the Exceptions Order 1975. If you are offered this position, Rocksteady will ask you to complete an enhanced DBS check with a children's barred list check. It is an offence for an individual who has been barred from working with children to apply for regulated activity. Providing false information is also an offence and could result in the rejection of the applicant, summarily dismissal if selected, and possible referral to the police. Rocksteady Music School is an equal opportunity employer. We are committed to the fair treatment of staff, potential staff, and of our services, regardless of race, gender, religion, sexual orientation, responsibilities for dependents, age, physical/mental disability, or offending background. To find out more about Rocksteady, check out our website. View our Privacy Policy for details on how we manage your personal data.