84297 - Business Intelligence Developer

The national salary is £32,827 - £35,678, London salary is £37,174 - £40,403. Your salary will be dependent on your base location
1
12 Months
National
National
NATIONAL
Please note: Some of our MoJ Office locations, such as our Liverpool Justice Collaboration Centre, require higher levels of National Security Vetting. The MoJ is working to open more Justice Collaboration Centres and Justice Satellite Offices over time. Click here to learn more about where our currently open Justice Collaboration Centres and Justice Satellite Offices are, to identify where you may be based and understand National Security Vetting requirements of each location.
HEO
HEO
Permanent
Full Time, Flexible Working
Analytical, Business Management & Improvement, Intelligence

Job Title:                 

Business Intelligence Developer (Senior Administrator)

Job Grade:            

HEO

New entrants are expected to join on the pay minimum.

Reporting to:        

Business Intelligence Manager

Job Location:       

National

Contract Type:      

Permanent

Business Area:     

MoJ – Commercial & Contract Management Directorate

Type of role:         

Business Intelligence & Management Information

Working pattern:   Flexible working, Full-time

Number of Posts:   1

About The Department

The Ministry of Justice (MoJ) is a major government department, at the heart of the justice system. Responsible for courts, prisons and probation services, we work to ensure sentences are served and offenders are given rehabilitation opportunities to become law-abiding citizens.

The Ministry of Justice (MoJ) has one of the largest and most complex spend profiles in central government. The Commercial and Contract Management Directorate (CCMD) is responsible for coordinating procurement and contract management across the MoJ, its agencies and non-departmental public bodies.

The MoJ spends £7.5bn a year and manages over 1600 active contracts, all of which are sourced and managed by CCMD. We are running some of the most groundbreaking programmes such as Prison Reform and His Majesty’s Courts and Tribunal Service Reform. The scope of our contracts ranges from building, maintenance and the operation of Prisons, Courts and Young Offender establishments through to food for prison dogs. The directorate also buys and manages contracts for feeding up to 80,000 prisoners, the secure escorting of prisoners from numerous establishments based around the country and translation services.

CCMD is organised into category teams, each with an interesting portfolio of contracts and diverse customers and suppliers to manage. We also have systems, programme management office, supplier relationship and risk management teams who work across all areas.

Scope

This role is in the Business Intelligence and Data Management team, part of the Commercial Operating Centre Portfolio which sits in the Commercial & Contract Management Directorate (CCMD). You will be working with stakeholders across MoJ both internally and externally, to develop a suite of reporting products that provide good quality, timely and relevant commercial data into formats that allows stakeholders to analyse and make or take data-driven decisions or actions. The post-holder will be responsible for providing key performance statistics to commercial portfolios, CCMD’s Senior Management Team and Commercial Governance Boards.

An additional role you will undertake will be to act in an advisory capacity on the submission of; Freedom of Information Requests, Parliamentary Questions, Treat Officials Requests and Ministerial Correspondence.

Key Responsibilities

The jobholder will 

  • Support and lead the development of comprehensive requirements which form the specification for reporting products.
  • Develop dynamic and engaging data visualisation products.
  • Plan and lead the delivery of end-to-end Business Intelligence projects.
  • Work in line with and improve upon the Product Delivery Framework which sets out the standards and delivery model for data products.
  • Continuously learn and extract the most benefit from the Business Intelligence tools.
  • Develop and update documentation across the Product Delivery Framework.
  • Take ownership of the development of reporting products, working collaboratively with colleagues in the business on developing requirements and iterating the improvement of data products.
  • Develop and run reporting queries as required.
  • Support legacy platforms as required, manually extracting reports and refreshing data

Person Specification

Essential Criteria:

  • Extensive experience developing high quality, visually engaging business intelligence products.
  • Extensive experience working within the Microsoft stack, including Power BI, Azure and the Power Platform.
  • Intermediate knowledge of Microsoft Power Bi, (including Power BI query), transforming, cleansing, manipulating data and creating measures, into meaningly statistical and visual information within the power bi package
  • Advanced skills in Excel and Power Query.
  • Experience in SQL, DAX and Data Protection Acts
  • Experienced networker with proven ability to build effective relationships with both internal and external stakeholders.
  • Excellent communicator with experience in communicating across all levels of a business.
  • Experience of leading the gathering and consolidation of stakeholder requirements
  • Ability to convey otherwise complex findings through actionable data visualisation.
  • Able to prioritise work, meet deadlines and ensure data is presented accurately and clearly.
  • Experience leading end to end business intelligence projects, from requirements and design to hands-on delivery and support.
  • Comfortable working cross-functionality with a range of colleagues.
  • Passionate about business intelligence with a desire to learn and stay up to date with industry best practice.
  • Able to work autonomously and part of a team.

Desirable Criteria:

  • Experience of using Oracle based Purchase to pay (P2P) systems including extracting and building reports in the discovery reporting function of oracle.
  • An understanding of Commercial processes and P2P life cycle.

Application stage (Sifting):

An initial sift will be performed against the following elements:

Application stage (sifting)

  • CV
  • Behaviour – Managing a Quality Service (Please follow the essential criteria to provide an example using a STAR approach.)
  • Statement of Suitability - Please share examples using STAR approach to demonstrate your suitability against the Key Responsibilities and Essential Skills in the job description.

If shortlisted, you’ll be invited to an interview and will be assessed on the selected success profile and technical elements. Please carry a proof of ID that has your photo on it (Passport, BRP, Driving Licence etc) at the interview.

Interview stage:

There is one interview stage for this vacancy and as part of the interview process you will be required to provide evidence on the following:

Technical

  • Demonstration of specific professional skills and knowledge (Ten-minute Power BI presentation on data analytics and ability to demonstrate end to end management of data life cycle)

Presentation

  • During your ten-minute presentation around Power BI on data analytics, you will be assessed on your ability to engage with the stakeholders.

Behaviours

  • Communicating and Influencing
  • Working Together
  • Making Effective Decisions

Please use STAR approach to structure your examples.

  • Situation – Describe the situation you found yourself in and what happened.
  • Task – The Hiring Manager will want to understand what you tried to achieve from the situation that you found yourself in.
  • Action – What actions did you take and how did you do it. Make sure to use “I”, not “we” to explain how your actions lead to a result.
  • Result – Use facts and statistics to demonstrate the results that your actions produced. Explain whether it was a successful outcome, and if not, what you learned from the experience.

Further information on the Success profile elements can be found on Success Profiles - GOV.UK (www.gov.uk)

Working Arrangements & Further Information

The MoJ offers Hybrid Working arrangements where business need allows. This is an informal, non-contractual form of flexible working that blends working from your base location, different MoJ sites and / or from home (please be aware that this role can only be worked in the UK and not overseas). Some roles will not be suitable for Hybrid Working. Similarly, Hybrid Working will not suit everyone’s circumstances. Arrangements will be discussed and agreed with the successful candidate(s) and subject to regular review.

For nationally advertised roles, the successful candidate(s) will be appointed to a MoJ office location, which may include their nearest Justice Collaboration Centre or Justice Satellite Office. This will be discussed and agreed on the completion of pre-employment checks.

Some of MoJ’s terms and conditions of service are changing as part of Civil Service reform. The changes will apply to staff joining MoJ who are new to the Civil Service. Staff joining MoJ from other civil service employers will transfer onto the new MoJ terms if they are already on 'modernised' terms in their current post or onto 'unmodernised' MoJ terms if they are on 'unmodernised' terms at their current post. Details will be available if an offer is made.

MoJ candidates who are on a specialist grade, will be able to retain their grade on lateral transfer.

All candidates who are currently in receipt of Mark Time / Pay Protection should ensure they are familiar with the new policy on permanent and temporary promotion which can be found on the employee intranet.

Flexible working hours

The Ministry of Justice offers a flexible working system in many offices.

Benefits

The MoJ offers a range of benefits:

Annual Leave

Annual leave is 25 days on appointment and will increase to 30 days after five years’ service.

There is also a scheme to allow qualifying staff to buy or sell up to three days leave each year. Additional paid time off for public holidays and 1 privilege day. Leave for part-time and job share posts will be calculated on a pro-rata basis.

Pension

The Civil Service offers a choice of pension schemes, giving you the flexibility to choose the pension that suits you best.

Training

The Ministry of Justice is committed to staff development and offers an extensive range of training and development opportunities.

Networks

The opportunity to join employee-run networks that have been established to provide advice and support and to enable the views of employees from minority groups to be expressed direct to senior management. There are currently networks for employees of minority ethnic origin, employees with disabilities, employees with caring responsibilities, women employees, and lesbian, gay, bisexual and transgender employees.

Support

  • A range of ‘Family Friendly’ policies such as opportunities to work reduced hours or job share.
  • Access to flexible benefits such as voluntary benefits, retail vouchers and discounts on a range of goods and services.
  • For moves to or from another employer or moves across the Civil Service this can have implications on your eligibility to carry on claiming childcare vouchers. You may however be eligible for alternative government childcare support schemes, including Tax Free Childcare. More information can be found on GOV.UK or Childcare Choices. You can determine your eligibility at https://www.childcarechoices.gov.uk/.
  • Paid paternity, adoption and maternity leave.
  • Free annual sight tests for employees who use computer screens.

Working for the Civil Service

The Civil Service Code sets out the standards of behaviour expected of civil servants.

We recruit by merit on the basis of fair and open competition, as outlined in the Civil Service Commission's recruitment principles. Should you feel that the recruitment process has breached the recruitment principles you are able to raise a formal complaint in the following order

The Civil Service embraces diversity and promotes equal opportunities. As a Disability Confident employer, MoJ are committed to providing everyone with the opportunity to demonstrate their skills, talent and abilities, by making adjustments throughout all elements of the recruitment process and in the workplace. MoJ are able to offer an interview to disabled candidates who meet the minimum selection criteria, except in a limited number of campaigns.

You will be able to request reasonable adjustments to the recruitment process within the application form. If you need additional help completing the application form, please contact the SSCL Recruitment Enquiries Team.

We encourage applications from people from all backgrounds and aim to have a workforce that represents the wider society that we serve. We pride ourselves on being an employer of choice. We champion diversity, inclusion and wellbeing and aim to create a workplace where everyone feels valued and a sense of belonging. To find out more about how we do this visit: https://www.gov.uk/government/organisations/ministry-of-justice/about/equality-and-diversity.

Expected w/c 1st April

04/03/2024, 23:55 hours.

If you require any assistance please call 0345 241 5359 (Monday to Friday 8am - 6pm) or e mail Moj-recruitment-vetting-enquiries@gov.sscl.com Please quote the job reference - 84297.

To apply for roles in MOJ you will need to confirm your employment history for at least 3 years prior to the date of application so that pre-employment checks (BPSS) can be undertaken. If you have spent significant time abroad (a total of 6 months in the past 3 years) you would be required to give a reasonable account of the reasons why. 

For some roles you will be required to successfully complete National Security Vetting at Counter Terrorism (CTC), Security Clearance (SC) or Developed Vetting (DV) level as a condition of appointment. To meet CTC/SC/DV requirements you will normally need to have been resident in the UK for at least 3/5/10 years prior to the date of application (The level of checks that are required are stated in the advert).

If you do not meet the above requirements, you may still be considered if, for example:

  • You've been serving overseas with HM Forces or in some other official capacity as a representative of HM Government
  • You were studying abroad
  • You were living overseas with parents

In such cases you will need to be able to provide referee cover for the period(s) of residence overseas. The duration of overseas residence and the country of abode will also be taken into account.

Success Profiles will enable a fairer and more inclusive method of recruitment by enabling us to assess the range of experiences, abilities, strengths, behaviours and technical/professional skills required for different roles. This flexible approach to recruitment focuses more on finding the right candidate for the specific role. To find out more about Success Profiles to support your application please click here for further guidance.

if you feel that your application has not been treated in line with the Civil Service Recruitment Principles, please contact SSCL (Moj-recruitment-vetting-enquiries@gov.sscl.com) in the first instance

We have provided detail of the assessment stages and areas being assessed to help you prepare for completing your application form, and to advise of what will be assessed following this, if you successfully pass the application stage.


Application form stage assessments

Behaviours
Managing a Quality Service - 250 word limit
Experience
CV
Statement of Suitability - 1000 word limit

Interview stage assessments

There is 1 interview stage for this vacancy.
Behaviours
Communicating and Influencing
Working Together
Making Effective Decisions
Technical Skills
Demonstration of specific professional skills and knowledge (Ten-minute Power BI presentation on data analytics and ability to demonstrate end to end management of data life cycle)
Additional Assessment(s)
Presentation

A Great Place to Work for Veterans

The "Making the Civil Service a Great Place to work for veterans" initiative includes a guaranteed interview scheme to those who meet the minimum criteria to provide eligible former members of the Armed Forces with opportunities to secure rewarding jobs. Allowing veterans to continue to serve their country, and to bring highly skilled individuals with a broad range of experience into the Civil Service in an environment, which recognises and values your previous service in the Armed Forces.
For further details about the initiative and eligibility requirements visit : https://www.gov.uk/government/news/making-the-civil-service-a-great-place-to-work-for-veterans

Redeployment Interview Scheme

Civil Service departments are expected to explore redeployment opportunities before making an individual redundant. The MoJ are committed, as part of the Redeployment Interview Scheme, to providing opportunities to those who are 'at risk of redundancy'.

MoJ are able to offer an interview to eligible candidates who meet the minimum selection criteria, except in a limited number of campaigns. Candidate's will not be eligible for the Redeployment Interview Scheme if they are applying on promotion.

The Civil Service welcomes applications from people who have recently left prison or have an unspent conviction. Read more about prison leaver recruitment.

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) https://www.gov.uk/settled-status-eu-citizens-families

· 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) https://www.gov.uk/government/publications/nationality-rules

This Vacancy is closed to applications.