Business Intelligence Data Consultant

Job summary

This is an exciting opportunity for someone who wants to further develop their skills in data management and analysis. You work closely with stakeholders from across the business, focusing on data extracted from the Oracle system, which includes HR and Finance data.

The post involves sourcing/extracting data, transforming and formatting the data to help present the information using the most suitable tools.

The post supports the corporate Business Intelligence function and responsibilities include supporting the background processes that help the BI systems function correctly.

This is an ideal opportunity for someone looking to pursue a career in data analysis and visualisation, helping the business to get greater insights from its data.

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 before starting in this role. The start date is expected to be 8-12 weeks after the application deadline.

If you’re a current Crown Prosecution Service employee, you remain based at your permanent office location throughout the post. You’re expected to travel to the temporary office at least 40% of your contracted hours over a four-week period – travel and subsistence may be applicable.

Job description

Your roles and responsibilities include:

• Working in the Business Intelligence and Systems section of the team
• Being responsible for a wide variety of systems & processes that ensure that Management Information and Business Intelligence dashboards get produced accurately and in line with Service Level Agreements.
• Meeting the needs of ad hoc or scheduled reporting. This will include using database reporting tools, visualisation tools such as Oracle and SharePoint, and database/spreadsheet skills to extract & manipulate data from a variety of systems.
• Creating new ways to obtain, extract & deliver data in an environment of continuous development, ensuring it is done in the most accurate and efficient way, as well as being required to offer advice & guidance to our stakeholders in relation to data, whether you are in the CPS or external

A copy of the full job description is attached.

Person specification

The following skills and experience are essential for this role:

• Advanced Excel

The following skills and experience are desirable for this role:

• Oracle transactional Business Intelligence - OTBI
• BI Publisher
• PowerBI
• Structured Query Language

Behaviours

We'll assess you against these behaviours during the selection process:

• Changing and Improving
• Working Together
• Managing a Quality Service

Benefits

Alongside your salary of £30,700, Crown Prosecution Service contributes £8,893 towards you being a member of the Civil Service Defined Benefit Pension scheme. Find out what benefits a Civil Service Pension provides (opens in a new window).

Join the Crown Prosecution Service and find your purpose.

The Crown Prosecution Service is passionate about ensuring that we're a top performing organisation and a great place to work. We're a committed equal opportunities employer, creating a culture where you can bring your whole self to work, and individuality is truly appreciated.

This culture of inclusion is underpinned by our staff networks covering disability, faith and belief, LGBTQI+, race, social mobility alongside our mental health first aiders programme and wellbeing sessions.

The Crown Prosecution Service commits to offer its employees the following experience.

• You can do impactful, purposeful work that’s making a difference to your local communities.
• You are able to learn and grow, with access to the right opportunities and resources.
• We care about your wellbeing.
• We want you to feel valued, trusted and included.

We also offer the following range of benefits:

• Civil Service contributory pension of up to 28.9%
• 25 days’ leave, increasing to 30 days after 5 years
• £350 each year to spend on personal development
• lawyer training programme for all new prosecutors
• an extra privilege day to mark the King's birthday
• competitive maternity, paternity and parental leave
• flexible working including flexitime, and a family friendly approach to work
• Cycle2Work scheme, employee savings.

Diversity at the Crown Prosecution Service is about inclusion, embracing differences and ensuring our workforce truly reflects the communities we serve. We want you to feel that you belong and can thrive, whatever your background, identity or culture. As a Disability Confident employer, we're happy to support requests for reasonable adjustments and improve your recruitment experience. If you'd like any reasonable adjustments made to our recruitment process, let us know within your application or contact [email removed]

The Crown Prosecution Service has fixed rates for its Executive Officer grade – a developing rate (the starting salary) and a spot rate (the maximum salary). Applicants typically join us on the developing rate and, after completing a 15-month development period, move to the spot rate if your line manager confirms you’re performing the role to a satisfactory standard.

If you’re joining the Crown Prosecution Service on a lateral transfer from another government department, you should contact us about the impact on your salary and the implications of any time you’ve already spent at that grade before applying or accepting an employment offer. Your salary may be adjusted if your location changes when you join us. This adjustment also takes into account any existing allowances that may have previously been consolidated into your basic pay – there’s no guarantee that you can retain these when you transfer.

We want to ensure our employees can thrive at work and home and offer a range of support to achieve a balance. This includes flexibility of working hours, flexibility to support caring responsibilities and a flexible approach to deployment. We offer a hybrid working policy. You must spend at least 40% of your contracted hours over a four-week period at court, in an office or another official workplace depending on business need and the kind of work you're doing.

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

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

Recruitment Process

The recr