Business Intelligence Reporting Lead
- Position:
- Business Intelligence Reporting Lead
- Location:
- Office-based in London, with flexibility to work remotely
- Salary:
- Total salary package £53,707 per annum (base salary of £45,226, plus a Recruitment and Retention Allowance of £8,481), plus excellent benefits*
- Closing date:
- 5pm on 27 November 2026
*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
Download more information
How to apply
To apply for this role, please submit:
- an up to date CV
- a supporting statement. This should show how you meet the essential criteria in the person specification of the job description
Please email completed applications to [email protected]
If you'd like to discuss the role in confidence first, please contact our HR team by email at: [email protected]
We’d be grateful if you downloaded and completed the equality and diversity monitoring form and submit it with your application.
We particularly welcome applications from disabled people and/or people from minoritised ethnic backgrounds.
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.
You can find the UK visas and permits granting you the right to work in the UK on the UK Government website. We currently don’t have a Sponsor Licence agreement with the Home Office and aren’t able to support you with your visa applications.
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 email [email protected]
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.
More about our recruitment and selection process
- The HR team will anonymise your CV and supporting statement before forwarding to the shortlisting panel. This is done as part of our commitment to equality, diversity and inclusion.
- The first round of our recruitment and selection process includes an interview with competency-based questions.
- Our recruitment and selection process might also include extra tasks. For example, a written or Microsoft Excel test or making a presentation.
- We’ll let you know what the selection process will include when we invite you to interview. You can ask for any more reasonable adjustments for the interview as part of the invitation.
- You might also be invited for a second interview. We’ll let you know about this during the selection process.
More about our employee benefits:
We have a wide range of employee benefits including (but not limited to):
Encouraging work life balance
- 38 days paid annual leave (including bank holidays), pro-rata for part-time
- More annual leave entitlement, based on length of employment
- Smart working options (with the opportunity to work remotely and find a smart working pattern that suits both you and us)
- Flexible working options
Caring for you and your family
- Generous sick pay entitlement
- More sick pay entitlement, based on length of employment
- Opportunity to buy and sell annual leave in each calendar year
- Free access to a GP virtually 24 hours a day/7 days a week allowing you unlimited advice, reassurance and where appropriate, diagnosis
- Enhanced leave for new parents
- Free access to a confidential 24 hours a day/7 days a week helpline service for both you and your family with a specialist range of support and information
- Special leave options (such as up to 5 days paid leave for domestic or personal emergencies a year)
- 10 days paid disability leave a year, pro-rata for part-time
- 10 days paid carers’ leave a year, pro-rata for part-time
- New family-friendly benefits, including paid leave in the event of miscarriage/stillbirth, to support fertility treatments and for antenatal appointments for both parents
- Cycle to work scheme
- Death in service scheme
Thinking about your finances
- Enhanced salary sacrifice pension scheme
- Discounted season ticket loan and interest-free emergency loans
- Give as you earn to support other charities of your choice before tax
- New employee portal including lifestyle savings vouchers and personal wellbeing
Enriching your life at work
- Personalised development plans with a wide range of training courses and opportunities to source additional training options with your line manager
- Yearly internal apprenticeship opportunities
- New, modern offices that embrace working together both in-person and remotely
- Various opportunities to influence how we internally operate (including surveys, and focus and committee groups)
- Active and supportive internal employee networking groups for collaboration and peer support
- 2 days paid leave a year for volunteering for MS Society activities during normal working hours (such as fundraising events, or campaigning in the local community)
- 2 days paid leave a year for volunteering with other charities during normal working hours
Safeguarding
We’re committed to safeguarding and promoting the welfare of everyone who uses our services and we come into contact with.
This is regardless of:
- age
- disability
- trans and non-binary identities.
- marriage and civil partnership status
- pregnancy and maternity status
- race (by race we mean colour, nationality, ethnic and national origin)
- religion or belief (including no religion or belief)
- sex or gender identity and expression
- sexual orientation
- socio-economic status or class
- geographic background
- caring responsibilities. This includes caring for a disabled person, older person or child and parental leave.
- mental health status
- menopause and periods
We recognise our particular responsibility to make sure vulnerable adults and children are protected.
We have measures in place to protect everyone we come into contact with from abuse and maltreatment of all kinds.