Senior Analyst (BI & Analytics Developer)

Job summary

We are recruiting a Senior Analyst to play a key role in developing data and analytics for one of the most significant transformation programmes in the history of the Family Justice System.

Cafcass’ Private Law Reform programme is reshaping how services are delivered to children and families, supporting the creation of Child Focused Courts across the Family Justice System in England. In this role, you will provide the technical data capability to underpin the reform, designing and developing robust data architecture, scalable reporting solutions, and high-quality analytical products that directly inform delivery and decision-making.

Job description

This is a hands-on senior technical build role, requiring strong expertise in data architecture, data modelling, SQL development, Power BI and advanced Excel within a complex, multi-source data environment.

You will take ownership of the design, build and optimisation of data pipelines, data models and reporting products, ensuring solutions are robust, scalable and aligned to programme needs, whilst complementing existing organisational data products and standards. This is not a pure insight role you will operate across the full technical stack, from raw data through to production-ready reporting.

You will bring substantial experience (typically 5+ years) in a data analyst, BI developer or similar technical role.

As a Senior Analyst in the Data & Analytics team your key responsibilities will include:

- Design, build and maintain end-to-end data solutions from ingestion through to reporting.

- Develop and optimise SQL-based data pipelines and transformations.

- Lead development of Power BI solutions, including data models (DAX) and performance optimisation.

- Apply advanced Excel techniques to support modelling and analytical validation.

-- Integrate and model data from multiple systems ensuring governance, documentation and quality.

- Develop automated, scalable reporting products.

- Identify trends, risks and variation through advanced technical analysis.

- Provide technical leadership and assurance on solution design.

Person specification

Who we are looking for

The importance of this strategic programme of work to Cafcass and the wider sector in which we operate cannot be overstated. Reflecting this, we have some clear requirements:

- Substantial technical experience (typically 5+ years).

- Strong technical background in data architecture, modelling and reporting development.

- Advanced SQL skills.

- Strong Power BI development expertise (including DAX).

- Advanced Excel skills including complex modelling and data manipulation.

- Experience across the full data lifecycle.

- Ability to translate complex operational requirements into robust, scalable analytical and data solutions.

- Working knowledge of modern data platforms and architectures (e.g. cloud-based data warehousing, Fabric or equivalent technologies).

- Awareness of AI and automation capabilities within Microsoft environments (e.g. Copilot, Power Platform, AI Builder or equivalent) and their application to analytical workflows.

- Experience of developing or supporting automated data pipelines, reporting processes or workflow automation.

- It may be an advantage if you have experience of working in the public sector and even better if you have experience of working within the Family Justice System.

- Experience working within a significant transformation programme is desirable, but not essential.

We are expecting a lot of interest in this role, so we encourage you to please ensure the above – and any of the other key requirements we have (please refer to the job description, which is a ‘vacancy document’) – is clearly demonstrated in your CV and/or application form.

Benefits

Where will you work?

There will be some travel - we have 30+ offices across England – and you can also expect to meet with your manager and team at regular intervals in-person, especially during your induction, as we know the value of this for colleagues. However, you can also expect to work remotely too, and we provide excellent equipment and technical support for you to do this. We can discuss what this might look like if we have the chance to speak with you.

As an organisation, we’re proud of the extensive wellbeing support available for colleagues, as well as excellent benefits, all of which we hope encourages you to work within our dedicated team.

Things you need to know

Artificial intelligence

Artificial intelligence can be a useful tool to support your application, however, all examples and statements provided must be truthful, factually accurate and taken directly from your own experience. Where plagiarism has been identified (presenting the ideas and experiences of others, or generated by artificial intelligence, as your own) applications may be withdrawn and internal candidates may be subject to disciplinary action. Please see our candidate guidance (opens in a new window) for more information on appropriate and inappropriate use.

Selection process details

Applications

If you’re preparing to apply, we encourage you not to rely heavily on AI tools when creating your application. While we recognise the benefits AI can offer, your application should reflect your own experience, insights, and motivations. This helps us genuinely understand what you will bring to the role.

Applications that appear to contain generalised or inauthentic content may limit our ability to assess your suitability, and where it is clear that AI has been used, it may affect our decision-making during the screening process.

Please ensure your application clearly demonstrates your technical capability and experience.

Next steps / timelines

We have given you an indication of a timetable we are hoping to work towards, although dates are subject to change.

Closing date:

Sunday 28th June

Initial interviews:

9th & 10th July 2026

Final Interview:

16th & 17th July 2026

Please note the following:

• We only plan to advertise this vacancy for a short period. If once we’ve done an initial, informal review of applicants we may decide to extend the advert to allow more people to apply. This will not mean anyone that’s already applied has been discounted. If we extend, this may mean the above timeline has to change.
• Initial and final interviews are likely to take place remotely via MS Teams.

Feedback will only be provided if you attend an interview or assessment.

Security

Successful candidates must undergo a criminal record check.People working with government assets must complete baseline personnel security standard (opens in new window) checks.

Medical

Successful candidates will be expected to have a medical.

Nationality requirements

This job is broadly open to the following groups:

• UK nationals
• nationals of the Republic of Ireland
• nationals of Commonwealth countries who have the right to work in the UK
• nationals of the EU, Switzerland, Norway, Iceland or Liechtenstein and family members of those nationalities with settled or pre-settled status under the European Union Settlement Scheme (EUSS) (opens in a new window)
• nationals of the EU, Switzerland, Norway, Iceland or Liechtenstein and family members of those nationalities who have made a valid application for settled or pre-settled status under the European Union Settlement Scheme (EUSS)
• individuals with limited leave to remain or indefinite leave to remain who were eligible to apply for EUSS on or before 31 December 2020
• Turkish nationals, and certain family members of Turkish nationals, who have accrued the right to work in the Civil Service

Further information on nationality requirements (opens in a new window)

Working for the Civil Service

Please note this Post is NOT regulated by the Civil Service Commission.The Civil Service embraces diversity and promotes equal opportunities. As such, we run a Disability Confident Scheme (DCS) for candidates with disabilities who meet the minimum selection criteria.

Diversity and Inclusion

The Civil Service is committed to attract, retain and invest in talent wherever it is found. To learn more please see theCivil Service People Plan (opens in a new window) and the Civil Service Diversity and Inclusion Strategy (opens in a new window).

Apply and further information

This vacancy is part of the Great Place to Work for Veterans (opens in a new window) initiative.The Civil Service welcomes applications from people who have recently left prison or have an unspent conviction. Read more about prison leaver recruitment (opens in new window).Once this job has closed, the job advert will no longer be available. You may want to save a copy for your records.

Contact point for applicants

Job contact :

• Name : Ben Rolfe
• Email : ben.rolfe@cafcass.gov.uk

Recruitment team

• Email : hrresourcing@cafcass.gov.uk

Further information

www.cafcass.gov.uk