Junior Business Intelligence Developer

This role sits within the Data and AI team, part of the DCMS Digital, Data and Technology (DDaT) directorate.

DCMS is currently preparing for a new integrated business suite (ERP) for finance and HR services, which will feed into many of our core BI processes. Alongside this, we're always looking for ways to improve how we use data and streamline processes, making the most of existing systems and bringing in new tools where they add value.

A big part of this work is the continued development of our Corporate Business Intelligence Platform, including a data warehouse and suite of dashboards. This is the main responsibility of the Business Intelligence team. We're a small team with a big remit, focused on unlocking the value of corporate data and helping put it at the centre of decision-making across the department.

While BI is our main focus, we also use our skills and tools to tackle wider business challenges, using data, automation and emerging technologies to support work that sits beyond traditional business intelligence.

This role reports to the Business Intelligence Lead. You will be expected to work independently while also contributing flexibly as part of a small collaborative team.

You will assist in the development and maintenance of the Corporate BI Platform, which comprises a data warehouse and a suite of dashboarding tools. The platform supports a broad range of users, particularly within Finance and HR, and continues to expand to incorporate additional business data sources. We currently use Looker Studio as our primary reporting platform and are undertaking a migration to Power BI over the coming months.

Working closely with experienced colleagues, you will help design and deliver reports, dashboards and data processes that provide users with timely, reliable and accessible information. You will also contribute to the ongoing development of the platform by supporting data integration activities and helping to improve the quality, accessibility and usability of corporate data.

A key area of work will be supporting the department's transition from a Google-based environment to Microsoft 365. This will involve assisting with the adaptation and replication of existing reporting, analytical and automation processes, while gaining experience of new technologies and helping to shape the future direction of the BI platform.

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, Experience and Technical skills.

To apply for this vacancy, you will need to submit the following documents which will assessed against the experience success profile:

➔ A CV setting out your career history, with key responsibilities and achievements. Please ensure you provide employment history that relates to the essential and desirable criteria, and that any gaps in employment history within the last 2 years are explained. The CV should not exceed more than 2 x A4 pages and you should insert your CV into the "Job History" section on Civil Service Jobs on the Civil Service Jobs application form.

➔ A Statement of Suitability (max 500 words) explaining how you consider your personal skills, qualities and experience provide evidence of your suitability for the role with particular reference to the essential criteria listed. You may also choose to reference the desirable skills listed however these will not be considered in the assessment of your application except in circumstances where there are a high number and calibre of candidates.

➔ Technical statement (max 250 words) Describe a dashboard project you have delivered, preferably with corporate data, including its objective, how you gathered requirements, the tools and technologies used, data preparation process, how you ensured accuracy and stakeholder satisfaction

For the shortlist, we will select applicants demonstrating the best fit for the role by considering the evidence provided in your application.

In the event of a large number of applicants, an initial sift will be conducted on the technical statement.

Those who are successful in the initial sift will then be scored on all elements of the application.

The interview process will assess behaviours, strengths and technical skills.

The behaviours to be tested at interview are:

• Changing and improving
• Making Effective Decisions
• Working Together

You will not be made aware of the strengths being assessed prior to your interview.

Technical skills to be assessed (outlined in the Government Digital and Data Capability Framework for Data analyst):

• Communicating between the technical and non-technical
• Data visualisation
• Data preparation and linkage

For support in writing your application and interviewing, please refer to the ‘Application and Interview Guidance’ document attached to the job advert.

For indicative sift and interview dates please refer to the attached Candidate Information Pack.

In most cases interviews will take place remotely via Google Meet video call. However please refer to the Candidate Information Pack to confirm the interview approach.

Further Information

If the vacancy is offered as FTA/Loan, existing Civil Servants must join on a Loan basis only. Prior agreement to be released on loan must be obtained before commencing the application process. In the case of Civil Servants, the terms of the loan will be agreed between the home and host department and the Civil Servant. This includes grade on return.

This role is full time only. Applicants who wish to work an alternative pattern are welcome to apply however your preferred working pattern may not be available and you should discuss this with the vacancy holder before applying.

For further information on National Security Vetting please visit the following page https://www.gov.uk/government/publications/demystifying-vetting

A reserve list may be held for a period of 12 months from which further appointments can be made.

Any move to Department for Culture, Media and Sport from another employer will mean you can no longer access childcare vouchers. This includes moves between government departments. You may however be eligible for other government schemes, including Tax Free Childcare. Determine your eligibility at https://www.childcarechoices.gov.uk

New entrants are expected to join on the minimum of the pay band.

DCMS has a London and a National pay scale. For more information on this, including the circumstances in which each pay scale will apply, please see the ‘Candidate Information Pack’ attached.

If successful and transferring from another Government Department a criminal record check may be carried out.

In order to process applications without delay, we will be sending a Criminal Record Check to Disclosure and Barring Service on your behalf. However, we recognise in exceptional circumstances some candidates will want to send their completed forms direct. If you will be doing this, please advise Government Recruitment Service of your intention by emailing Pre-EmploymentChecks.grs@cabinetoffice.gov.uk stating the job reference number in the subject heading.

Applicants who are successful at interview will be, as part of pre-employment screening, subject to a check on the Internal Fraud Database (IFD). This check will provide information about employees who have been dismissed for fraud or dishonesty offences. This check also applies to employees who resign or otherwise leave before being dismissed for fraud or dishonesty had their employment continued. Any applicant’s details held on the IFD will be refused employment.

A candidate is not eligible to apply for a role within the Civil Service if the application is made within a 5-year period following a dismissal for carrying out internal fraud against government.

Reasonable Adjustment

We are committed to supporting candidates so they can perform at their best throughout the recruitment process. This includes making reasonable adjustments to our process.

In order to request an adjustment, please:

Complete the ‘Assistance required’ section on the ‘Additional requirements’ page of your application form to tell us what changes or help you might need further on in the recruitment process. For instance, you may need wheelchair access at interview, or a verbal test rather than a written one.

Alternatively, contact the Government Recruitment Service via dcmsrecruitment.grs@cabinetoffice.gov.uk as soon as possible before the closing date to discuss your needs.

Accessibility

If you are experiencing accessibility difficulties with any of the attachments, please contact us. Contact details can be found in the 'contact point for applicants' section of the job advert.

Feedback

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