Senior Analyst (BI & Analytics Developer)
This is a {Advertised Permanent / Temporary}, {Advertised Full Time / Part Time} vacancy that will close in {x} days at {xx:xx} BST.
The Vacancy
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.
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.
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.
Although this is a permanent role within Cafcass, we welcome applications from candidates seeking a long-term secondment from public sector partner organisations. This opportunity may particularly suit individuals with experience of working within, or alongside, the Family Justice System, who are looking to contribute their expertise to a nationally significant reform programme while further developing their technical and analytical capability in a complex, multidisciplinary environment.
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.
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: | 29/06/2026 12:00 |
| 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.
If you wish to informally discuss the vacancy, please contact Ben Rolfe (Head of Business Analysis) on 07795 641971 / ben.rolfe@cafcass.gov.uk. However, if you are waiting to speak with Ben and the closing date is imminent, please apply whilst you can and if you later decide you do not wish to be considered, you can withdraw your application.
In anticipation of your successful application, we encourage you to review our offer and pre-employment checks process. You are welcome to raise any questions or concerns about these checks during your application, with the assurance that this information will remain confidential.
Be Their Voice
We are Cafcass – the Children and Family Court Advisory and Support Service – and we represent children in family court cases in England.
Independently advising the family courts about what is safe for children and in their best interests, we speak up for over 130,0000 children every year when the family court makes critical decisions about their futures, ensuring their needs, wishes and feelings are heard.
Watch our video to find out we don’t just listen to children’s voices but we can be their voice.
If our purpose resonates with you, and you share our ambitions for children - exceptional experiences, for every child, everywhere and every time - then if you join us, you will work alongside like-minded people in a diverse, inclusive and supportive organisation.
You will be trusted to work flexibly and independently using outstanding technology (e.g. touchscreen laptops, iPhone, all with first class support, including IT Trainers) with access to substantial resources (e.g. Cafcass Library has over 27,000 resources on social work, child protection and related topics). You will also have opportunities to develop, whatever team you join, wherever you are in the country and at whatever stage you are at in your career.
Whether you join us in one of our social work roles that work directly with children and families or our corporate and business services teams who provide technology, support and expertise, you will have the chance to make a difference for children and families. You can also find out more at www.cafcass.gov.uk/careers.
Wellbeing
The wellbeing of our colleagues is something we are truly passionate about, as demonstrated by everyone having four dedicated, additional days per year when they are encouraged to spend time focusing on their health and wellbeing.
Colleagues can also have a health and wellbeing cash plan, for which Cafcass pays the basic premium (you can upgrade to include family members), which allows them to claim back some costs of routine health expenses, including dental check-ups, eye tests, physiotherapy sessions and more.
Overall, we foster a holistic approach to supporting our colleagues, benefitting physical, mental and financial health. This is led by a dedicated in-house team, the benefits of which include meaning support is targeted and specific to what colleagues need. Our team can also offer support and guidance when it comes to specific health conditions, such as neuro-diverse conditions, cancer and the menopause.
Our wellbeing offer is further strengthened by an external Employee Assistance Provider (EAP) which provides a free confidential support service 24 hours a day. This means access to clinical and professional expertise which gives you a chance to talk about all kinds of work and personal issues.
If this wasn’t enough, we are especially proud that over 125 colleagues have completed training and receive ongoing support to act as Health and Wellbeing Champions. Furthermore, we have nearly 100 people that have trained to be Mental Health Allies.
Diversity
We represent children and families from diverse backgrounds and having a diverse workforce helps us to fulfil this responsibility authentically.
It also helps us to grow, evolve and innovate, so we particularly welcome applications from individuals from diverse backgrounds as we strive to ensure our workforce reflects the diversity of the children and families we work with.
We are proud to be a disability confident leader, we invite you to join our team, we are committed to actively attract and recruit individuals with disabilities including “non-visible” disabilities and mental health conditions. Our inclusive and accessible recruitment process means we aim to accommodate reasonable adjustments as needed. This commitment highlights our dedication to employing, training, retaining, and developing the careers of our colleagues with disabilities.
Our Diversity Networks provide a safe space for colleagues with shared aspects of identity and lived experience – supported by allies across the organisation. The networks help ensure we provide an inclusive working environment and a service which promotes the diversity and uniqueness of children and families from all backgrounds.
For more information watch our video here.
Our current networks include:
Kaleidoscope Network
Colleagues from Black Asian and Minority Ethnic backgrounds.
Mental Health Network
Colleagues who experience, or have an interest in, Mental Health issues.
Pride
Network
Colleagues who identify as Lesbian, Gay, Bisexual and Trans – LGBT+.
Neurodiversity Network
Colleagues who are neurodivergent, or support someone who is.
Together
‘Together with Children and Families’ (which we just call ‘Together’) is the name of our relationship-based practice framework. It applies to the work of every individual in Cafcass, from Social Workers to Leaders and includes our Corporate and Business Support teams.
It is at the heart of what we do and is made up of our values, how these values work in practice, the tools to use to incorporate these values in our work and the impact this will have on the children and families we serve.
This framework encourages us to be pro-active and to look for the strengths in ourselves and others. It also enables us to build positive relationships with our colleagues, our partners and most importantly, with the children and families with whom we work.
We look forward to telling helping you learn more about Together should you join us.
Benefits
We know if you join us you want to be rewarded in a variety of ways, including time away from work to spend time with those important to you, manage your financial present and future, whilst also be trusted to manage your work/life balance.
Therefore, in addition to our unique, holistic approach to supporting your health and wellbeing we also provide:
Generous holidays
28 days holiday (including three for Christmas) rising to 33 days with five years continuous service, which could include your current employment. You can also sell any you do not need.
This list is just a selection of main benefits and we have a range of policies and processes that allow us to support our colleagues - and their families – and we look forward to providing you with further information about these in due course.
Documents
Alternatively, please sign in with...
Published
Not PublishedClosing
in X days