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

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

Job summary

BCP Council is seeking an Experts at Hand Transformation Specialist on a 14-month fixed-term basis. Starting salary is £45,529, pro rata for part-time staff, with a clear pay band and opportunities for progression.

The role focuses on SEND reform, data tooling, and in-house reporting development within Education and Skills. You will develop trusted datasets, semantic models and user-friendly dashboards, training analysts and expanding reporting for Inclusion and Alternative Provision.

Qualifications

• Advanced knowledge of Microsoft Fabric and Power BI.
• Ability to develop trusted datasets and semantic models.
• Experience presenting findings in reports to support decision making.
• Ability to plan and deliver work and manage priorities.
• Experience mentoring others to build technical capability.

Responsibilities

• Review existing Education and Skills reporting datasets and identify opportunities for improvement.
• Clean, transform and prepare data into trusted gold layer datasets.
• Build semantic models to support EXperts at Hand, Inclusion and Alternative Provision reporting.
• Design and develop Power BI reports and dashboards for operational and strategic oversight.
• Develop digital tools for Experts at Hand, Inclusion and Alternative Provision.
• Expand Inclusion reporting to cover permanent exclusions, suspensions and attendance.
• Support development of Alternative Provision reporting within the Education and Skills reporting app.
• Train, mentor and support team members to strengthen in-house reporting skills.

Skills

Microsoft Fabric

Power BI

T-SQL

Data analysis

Dashboard design

Stakeholder communication

Education

Degree or work experience relevant to the service area

Tools

Power BI

Microsoft Fabric

Job description

The following content displays a map of the jobs location - BCP Council, Civic Centre, Bourne Avenue, Bournemouth

Experts at Hand Transformation Specialist - 14 months fixed term

Dynamics Position No. and Role Profile Code 114918 / MUL101

Number of Positions:

1

Contract Type:

Fixed Term

14 months fixed term

Working Hours:

37

Location:

BCP Council, Civic Centre, Bourne Avenue, Bournemouth

Closing Date:

01/11/2026

Job Category:

Children's Services

Region / Division:

Children's Services

Business Unit:

Quality,Improvement & Children's Governance and Governance

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 .

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

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’show 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.

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.

Be the difference - Join an organisation that values you

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.