Business Intelligence Reporting Lead
Position: Business Intelligence Reporting Lead
Hours: Full-time (35 hours a week)
Contract: Permanent
Location: Office-based in London, with flexibility to work remotely
Total salary package: Starting from £53,707 per annum (base salary of £45,226, plus a Recruitment and Retention Allowance of £8,481), plus excellent benefits
Salary Band and Job Family: Band 3, Profession/Technical
Your base salary will start at £45,226 per annum, increasing to £48,053 after 6 months’ service and satisfactory performance and to £50,879 after a further 6 months. The Recruitment and Retention Allowance is paid in addition to your base salary.
About us
We make sure people living with MS are at the centre of everything we do. And it’s this commitment that unites us across the UK.
Our strategy is based on what people affected by MS have told us is important to them. It gives us a clear and determined focus.
Our work is based on the hopes and aspirations of our MS community. Together we campaign at all levels, fund ground-breaking research and provide award-winning support and information.
Our people are our greatest asset and the key to our success. We offer a vibrant, progressive working environment where you’ll be able to make a difference.
About this job
We’re in a pivotal moment in how we use data at the MS Society. Following investment in a new CRM and data infrastructure, we’re strengthening our reporting capability so that reliable, accessible insight supports better decisions across the organisation.
We’re looking for a Business Intelligence Reporting Lead to be our leading expert in Power BI and other reporting tools. You’ll shape organisation-wide standards, lead the full lifecycle of reports and dashboards, and ensure our BI platforms remain effective, secure and responsive to changing user needs.
Working closely with colleagues across Data, Technology and the wider organisation, you’ll develop and optimise reporting solutions, resolve complex data and performance issues, and help build confidence in data-led decision-making. You’ll also contribute to our wider data, digital and technical strategy, including the future use of Microsoft Azure and Fabric.
What you’ll be doing
- Leading the development and implementation of organisation-wide best practice, standards and governance for Power BI and other BI tools
- Owning the full lifecycle of reports and dashboards, from requirements gathering and development through to deployment, maintenance, optimisation and archiving
- Developing, maintaining and improving strategic and operational Power BI reports using advanced data modelling, DAX, Power Query and complex visualisations
- Creating and delivering a Power BI roadmap that provides timely, user-focused reporting solutions aligned with organisational priorities
- Working with IT and Data colleagues to extract, transform and load complex datasets into BI systems in line with technical and data standards
- Monitoring platform performance, identifying and resolving complex reporting, data quality and process issues, and maintaining high system availability
- Building strong relationships with BI users, gathering new requirements and providing expert technical support, guidance and training
- Promoting data maturity, innovation and consistent reporting through a hub-and-spoke approach across the organisation
- Managing external suppliers and coordinating staff resources for projects and significant pieces of work
- Monitoring performance against agreed objectives and KPIs, ensuring timely action is taken where improvement is needed
What we’re looking for
- Proven experience and expert knowledge of leading the development and rollout of BI tools across a broad range of teams and disciplines
- Extensive hands-on experience with Power BI, including report and dashboard development, DAX and Power Query
- Strong proficiency in SQL and advanced experience of data modelling, integration and ETL processes
- Excellent analytical and problem-solving skills, including experience of applying advanced analytical techniques to complex issues
- Knowledge of data governance and data quality principles
- Experience of managing change effectively and improving reporting services, processes and user adoption
- Excellent interpersonal and communication skills, with the ability to influence a wide range of technical and non-technical stakeholders
- Strong organisational and workload management skills, with experience of managing third-party suppliers
- Advanced Power BI knowledge or equivalent experience; knowledge of Microsoft Azure and Fabric would be an advantage
If you’re excited by the opportunity to shape reporting across the MS Society and help colleagues make better use of data, we’d love to hear from you.
Closing date for applications: 5PM on 27 November 2026
Interested?
PLEASE PRESS THE 'HOW TO APPLY' BUTTON FOR MORE INFORMATION.
We particularly welcome applications from disabled people and or people from minoritised ethnic backgrounds.
We’d be grateful if you downloaded and completed the equality and diversity monitoring form and submit it with your application.
Disability Confident Employer
We’re a Disability Confident Employer and we’re committed to promoting equality and diversity.
You can ask for reasonable adjustments as part of both our recruitment and new starter on-boarding processes.
If you need any help or adjustments to apply for this role, please contact us. You can also ask for the application materials to be sent to you in a different format. Such as for them to be sent to you by email or in a larger word format.
Your right to work in the UK
You must have the right to work in the UK to work in paid employment with us. You’ll need to share documents showing you’re eligible to work in the UK if we offer you employment.
We currently don’t have a Sponsor Licence agreement with the Home Office and aren’t able to support you with visa applications.
Safeguarding
We’re committed to safe and responsible recruitment and to protecting the wellbeing of children, young people and vulnerable adults. We expect all staff and volunteers to support this commitment.
A Disclosure and Barring Service check will not be required for this role.
We have a wide range of employee benefits, including:
Encouraging work-life balance
- 39 days’ paid annual leave, including bank holidays, pro rata for part-time employees
- Additional annual leave entitlement based on length of employment
- Smart working and flexible working options
Caring for you and your family
- Generous sick pay and enhanced leave for new parents
- Opportunity to buy and sell annual leave
- Free 24/7 access to a virtual GP and a confidential support helpline
- Special leave, disability leave and carers’ leave options
- Cycle to work and death in service schemes
Thinking about your finances
- Enhanced salary sacrifice pension scheme
- Discounted season ticket loan and interest-free emergency loans
- Give as you earn and access to lifestyle savings and wellbeing offers
Enriching your life at work
- Personalised development plans and a wide range of training opportunities
- Yearly internal apprenticeship opportunities
- Modern offices designed for in-person and remote collaboration
- Supportive employee networking groups and opportunities to influence how we work
- Four days’ paid volunteering leave each year across MS Society and other charity activities
No agencies please.
To fund world-leading research, share the latest information and campaign for everyone's rights. Together we are a community. Together we can stop MS
