BI Visualisation Developer

This is an exciting time to join the Business Intelligence and Systems Team at the Crown Prosecution Service. We are looking for people who enjoy using data to derive insights and sharing those by creating compelling visualisations. The role involves transforming complex HR, Finance and other datasets, into understandable and actionable insights.

As a BI Visualisation Developer you work with others – both within the team and other stakeholders, to identify areas for improvement in the reporting catalogue and simplify overall reporting processes, while using visualisation technologies to increase efficiency. You adopt a positive approach to keeping your own and your team’s efforts focused on the top priorities, ensuring appropriate resources are available for your team – whether that be technology, support for training or appropriate work plans.

You also regularly monitor your own and team’s work against milestones and act promptly to reassess workloads and priorities when there are conflicting demands to maintain performance. You demonstrate leadership by ensuring colleagues and stakeholders have a clear understanding of objectives, activities and timeframes and encourage joined up teamwork within own Business Intelligence team and across other groups, including Finance and HR Business Partners and other corporate and operational functions.

The Crown Prosecution Service is based in England and Wales. If you’re applying for this role and live in Scotland or Northern Ireland, you must let us know when accepting this offer as you need permission to work from your home address if hybrid working is part of your role. There’s no guarantee that we will grant this approval.

You must be aged 16 or over at the point of starting in this role. The expected start date is approximately 8–12 weeks after the application closing date. You are expected to commence employment as soon as possible following the expiry of your notice period. Requests for significantly later start dates may not be accommodated.

You must complete and pass your Civil Service tests by 23:55 on 24th October 2026 to be able to complete an application for this role.

As part of this role, you are expected to undertake direct line management responsibilities.

Your roles and responsibilities include:

• supporting the Business Intelligence and Systems Team and senior CPS leadership, by developing interactive, user-friendly, visual representations of data using modern visualisation tools like Power BI.
• translate business needs into technical specifications and create visualisations and reports while continuously adapting to emerging technologies and methodologies in data visualisation
• support the business by providing expert advice on the ongoing development of the reporting capabilities of corporate ERP/HCM and planning systems both within and outside of the CPS
• manage the staff and work of reporting and systems specialists within the Business Intelligence and Systems Team, provide expert advice and guidance to colleagues both within and outside of CPS and will make sure standards and targets within Service Level Agreements are met
• ensuring correct procedures are in place for critical finance and HR functions

The role involves analysing data and processes, troubleshooting, improving existing BI systems, and ensuring the accuracy and efficiency of data-driven solutions.

A copy of the full job description is attached.

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)

This vacancy is using Success Profiles (opens in a new window), and will assess your Behaviours, Strengths and Experience.

Recruitment process

The recruitment process consists of an online application, online test and interview.

Behaviours

You are asked to complete a statement of no more than 250 words for each of the following behaviours, setting out how you consider your personal skills, qualities and experience match the specified behaviours and requirements:

• changing and improving - lead behvaiour
• leadership
• working together
• delivering at pace

In addition, you need to demonstrate the following technical skills required for this role:

• advanced Excel skills

You also need to demonstrate the Crown Prosecution Service or Civil Service values.

The panel has the right to assess the lead behaviour ‘changing and improving’ first. If the standard on this behaviour isn’t met, the other behaviours won’t be considered and your application won’t progress. The panel also has the right to raise the minimum standard pass mark. The panel may also refer to the lead behaviour at the interview stage to determine merit order.

CV

You’re not required to upload your CV. However, when submitting your application there is a ‘CV section’. You are required to provide information about your employment and/or academic history for the past three years. The CV section will be used as supporting evidence, it won’t be assessed.

It’s your responsibility to provide the specified information in the requested format to ensure that you're considered for the post.

If you're unable to cover three years through employment or academic history, you must provide a character reference for clearance purposes.

Interview

The interviews are expected to take place on week commencing 16 November and week commencing 23 November 2026.

Your interview takes place online through Microsoft Teams. A member of our recruitment team will be in touch with guidance. If you have any queries about this, contact Daisy.gabriel1@cps.gov.uk

You should keep this week free or notify us if you're not available. We'll make every effort to accommodate your date preferences but we can't guarantee it.

We use behaviours to help us understand your experience, to see if you're a good fit for the role. You are assessed against EO level in the Civil Service success profiles behaviours framework. We are assessing 4 behaviours at interview stage:

• changing and improving – interview
• leadership – interview
• working together – interview
• delivering at pace – interview

Essential Experience - assessed at interview.

Strengths

Strengths are tested at interview stage - the strengths tested are not shared before the interview.

Online tests

Before submitting your application, you’re invited to complete an online numerical reasoning test. You must successfully complete the test to progress to the next stage. Please complete the online test as soon as possible – we recommend within 24-48 hours. The closing date for the test is 24th October 2026.

We send you an invitation to take the test and provide full instructions about how to complete it. The test can’t be taken on mobile phones or tablets.

For more guidance about the online Civil Service tests, please see the GOV.UK website: Civil Service online tests - GOV.UK (www.gov.uk)

Other

This is a full-time post. We do consider requests for flexible, part-time working and job share, always considering the operational needs of the department.

Please note that the CPS is unable to offer visa sponsorship. If you require visa sponsorship to work in the UK, you will not meet the eligibility criteria for this role.

Clearance

If successful, you are required to secure a Security Check clearance, for which you must have a current valid UK address.

If successfully appointed, we ask you to complete a character enquiry form, and nationality and immigration questionnaire, and national security vetting form.

If you're a Crown Prosecution Service member of staff, you won’t need to do a Disclosure and Barring Service check as you already hold this clearance.

The job you’re applying for is covered by Article 3(a) of the Rehabilitation of Offenders Act 1974 (Exceptions) Order 1975, consequently Section 4(2) of that Act doesn’t apply. You’re required to disclose all previous convictions and cautions including spent convictions. Failing to make a full declaration will result in withdrawing your offer of employment if our checks reveal convictions that haven’t been disclosed.

To be cleared to Security Check clearance level, you have to be able to meet the residency requirement in the Cabinet Office guidance. For the Crown Prosecution Service, this is three years within the last five years.

Reserve list

If you're recommended by the selection panel but not appointed to the current vacancy, you’re put on a reserve list for 12 months. You may be offered another BI Visualisation Developer post in the CPS if a vacancy comes up during this period. We may also approach candidates on the waiting list to fill other roles that require similar knowledge and experience.

Civil Service Commission

If you’re dissatisfied with the recruitment process and wish to make a complaint, please contact Strategic.Resourcing@cps.gov.uk with your concerns.

If you remain dissatisfied and wish to make a further complaint, please click on the following link to the Civil Service Commission complaints page Recruitment Complaints - Civil Service Commission

Civil Service Commission Recruitment Principles can be found at https://civilservicecommission.independent.gov.uk/recruitment/

Details of the Civil Service Nationality Rules are located at https://www.gov.uk/government/publications/nationality-rules

Candidates are subject to UK immigration requirements. For the most up-to-date information on the requirements of working in the UK, please go to the UK Visas and Immigration website at https://www.gov.uk/browse/visas-immigration/work-visas

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