Experts at Hand Transformation Specialist - Fixed term to 30 Sept 2027

BCP Council; Christchurch; On-site; GBP 41,000 - 50,000; Full time

Benefits offered by this job

A Place to Thrive

Enhanced benefits

Pay and Reward package

Be the difference

More About us

Job summary

BCP Council is seeking an Expert at Hand Transformation Specialist to support SEND reform. You will craft trusted datasets and semantic models, delivering practical reporting tools for educational outcomes and policy impact.

You will work with Education and Skills teams to monitor delivery, inform decisions, and share knowledge with analysts to strengthen in-house reporting capabilities. The role includes mentoring colleagues and advancing BI maturity.

Qualifications

• Degree or work experience relevant to the service area.
• Advanced knowledge of Fabric and Power BI.
• Detailed knowledge of the SEND/Inclusion services data domain.
• Ability to communicate clearly with stakeholders.
• Ability to analyse and present statistical data and reports.
• Developing dashboards and reporting tools for operations and strategy.
• Supporting and mentoring others to build technical capability.

Responsibilities

• Review Education and Skills reporting datasets and identify improvement opportunities.
• Clean, transform and prepare data into gold layer datasets.
• Build semantic models to support reporting.
• Design and develop Power BI reports and dashboards for oversight.
• Develop digital tools translating reporting needs into practical solutions.
• Expand Inclusion reporting to cover exclusions, suspensions and attendance.
• Support development of Alternative Provision reporting in the reporting app.
• Train and mentor team members in Power BI, Fabric, and semantic modelling.

Skills

Degree/Experience

Data analysis

Stakeholder comms

Dashboards reporting

Mentoring others

Education

Degree or equivalent experience

Tools

Power BI

Microsoft Fabric

T-SQL

Job description

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.

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.

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.