Job Introduction
Starting salary for this role is £45,529 (pro rata for part-time colleagues)
This role sits within a well defined pay band, offering clear progression as you grow your career at BCP. Without exception all new starters begin at the entry point of the band, ensuring fairness and consistency across the organisation. Be part of a forward thinking workplace where you’re supported to grow and you can truly #BeTheDifference at BCP.
Learn more in our ‘More than just a job’ brochure on our careers site.
Role Purpose:
Use your analytical expertise to turn complex data into clear insight that supports better outcomes for children and young people. We are looking for an Expert at Hand Transformation Specialist to support BCP Council’s special educational needs and disabilities (SEND) reform, with a focus on the Experts at Hand transformation programme, Inclusion and Alternative Provision.
Working with the Education and Skills Performance and Intelligence Team, you will develop trusted datasets, semantic models and practical reporting tools. Your work will help colleagues understand delivery, monitor impact and make informed operational and strategic decisions.
A key part of the role will be sharing your knowledge with existing analysts, building on the team’s existing expertise to strengthen and sustain in-house reporting.
Main Responsibilities:
- Review existing Education and Skills reporting datasets, including gold layer datasets and semantic models, and identify opportunities for improvement.
- Clean, transform and prepare data into trusted, business-ready gold layer datasets.
- Build semantic models to support Experts at Hand, Inclusion and Alternative Provision reporting.
- Design and develop Power BI reports and dashboards to support operational and strategic oversight.
- Develop digital tools for Experts at Hand, Inclusion and Alternative Provision, working with colleagues to translate reporting needs into practical solutions.
- Expand Inclusion reporting to cover key areas such as permanent exclusions, suspensions and attendance, including child-level data where available.
- Support the development of Alternative Provision reporting within the Education and Skills reporting app.
- Train, mentor and support existing team members to strengthen internal skills in Microsoft Fabric, T-SQL, semantic modelling and Power BI development.
The Ideal Candidate:
You will bring advanced knowledge and strong practical experience of Microsoft Fabric and Power BI, with the skills to develop trusted datasets, semantic models and clear, user friendly dashboards. You will be confident analysing complex information, and presenting findings in reports that support service improvement and decision making.
You will be able to plan and deliver work, manage competing priorities and assure the quality of your outputs. Clear communication and a collaborative approach will help you work with analysts, service leads and transformation colleagues, explain technical information and share your expertise.
You will bring experience in:
- Degree or work experience relevant to the service area.
- Advanced knowledge of fabric and power bi.
- Detailed knowledge of the relevant service area or specialism (ie Children’s Services in particular SEND and Inclusion).
- Ability to communicate clearly and persuasively with a range of stakeholders.
- Ability to analyse and present information, including statistical data, and prepare reports.
- Developing dashboards and reporting tools for operational and strategic use.
- Supporting and mentoring others to build technical capability.
Experience of working with education, inclusion, SEND or children’s services data would be helpful, but is not essential.
Additional information
The role is full time and offered on a 14 month fixed-term basis.
Closing Date: 1st November 2026
Interviews: Week commencing 9th November 2026
Please note, this role is not eligible for visa sponsorship and we can only consider applicants with existing right to work in the UK.
At BCP Council, inclusion is more than a promise – it’s how we work.
We’re committed to providing a fully inclusive recruitment process ensuring every candidate and colleague has the support and reasonable adjustments they need to thrive.
From the moment you apply, through the recruitment process and throughout your career with us, we’ll be here to listen and provide the help and support you need.
It’s why we’re proud to be a Disability Confident Employer – and why you can trust that we’ll always do our best to make your experience positive and accessible.
If you require any reasonable adjustments or support during the recruitment process, please let us know when you apply or contact us directly – we’re here to help. For further information on the accessibility support we can offer please see here: Preparing for your interview | Working for BCP
About BCP Council
BCP Council provides services to a diverse community of 400,000 residents and employs more than 5,000 people. Our area includes over 15 miles of beautiful world-renowned coastline. We can offer career defining roles to transform and improve services. By working with us, you can help deliver a vision of a thriving, world-class, prosperous and inclusive place for generations to come.
Our Benefits
A Place to Thrive – Join BCP Council
At BCP Council, we’re not just building a workforce— we’re transforming how we recognise and reward our people.
Check out our attractive enhanced benefits and find out more about the new Pay and Reward package at Employee benefits | Working for BCP
Be the difference - Join an organisation that values you
More About us | Working for BCP
Basic DBS
BCP Council is committed to safeguarding and promoting the welfare of the community and expects all staff and volunteers to share the same commitment. Applicants to this post will be required to complete the appropriate level of Disclosure & Barring Service Check.
