Junior Business Intelligence Developer

This role will report to the Business Intelligence Lead. You will be expected to work independently but also flexibly as part of a team.

To enhance data driven decision making you will assist in the build and implementation of products that transform the way we manage and interact with data, creating innovative solutions that ultimately provide an intuitive experience for a wide array of users primarily within Finance, HR and Commercial.

These products will be held within the Corporate BI Platform, comprising two components: a data warehouse and reporting/dashboarding tools. The initial focus of the BI platform has been the core Finance and HR reporting and data processes, but we plan to expand the platform to bring in a range of other non-corporate data sources as well.

As the Junior Business Intelligence Developer your key responsibilities will be

• Technically facilitate the expansion of the BI platform data warehouse, through developing data extraction, transformation and loading (ETL) pipelines.
• Collaborate with teams across DCMS to assist the BI team in understanding reporting requirements.
• Assist the BI team with the creation of self service, user intuitive reports within a business analytics reporting tool (currently Looker Studio).
• Assist in the transition from a Google-based environment to Microsoft 365 by adapting and replicating existing processes to ensure seamless functionality within the new platform.

Person specification

The ideal candidate would have the following key skills and experience.

Essential requirements:

• Demonstrable experience with data warehouses and dimensional data models (e.g., star/snowflake schemas)
• Proficiency in SQL, including joins, subqueries, window functions, common table expressions (CTEs), and advanced SQL functions
• Experience developing and deploying dashboards or reports used by business stakeholders, using tools such as Power BI or Looker Studio
• Ability to gather and translate reporting requirements from stakeholders, and assist team leads in planning and implementing processes to support those requirements
• Strong communication skills, with the ability to translate technical concepts for non-technical stakeholders

Desirable skills:

• Working knowledge of data pipeline and data integration concepts related to data warehousing (e.g., ETL/ELT processes)
• Experience with corporate data (notably Finance and HR)
• Familiarity with automation tools such as Google Apps Script or Microsoft Power Automate

We are running an information session where prospective applicants can find out more about the role. This will be hosted by Glyn Spencer, and will take place on: Monday 21st July at 10 a.m.

The session will be an opportunity to hear more about the role, the team and wider directorate and the department. It will also be an opportunity for you to ask any questions.

Please register your interest by filling out this Registration form by Friday 18th July and you will be sent an invitation.

Please note that the session will not focus on the DCMS recruitment process - please direct any queries that you have on this topic (timelines, reasonable adjustments, onboarding etc) to

Behaviours

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

• Changing and Improving
• Delivering at Pace
• Working Together

Technical skills

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

• 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
• Communicating between the technical and non-technical
• Data visualisation
• Data preparation and linkage

We only ask for evidence of these technical skills on your application form:

• 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

Benefits

Alongside your salary of 34,584, Department for Culture, Media and Sport contributes 10,018 towards you being a member of the Civil Service Defined Benefit Pension scheme. Find out what benefits a Civil Service Pension provides.

DCMS values its staff and offers a wide range of benefits to everyone who works here. Were committed to developing talent, and supporting colleagues to have great careers in our department. To support with that, some of the benefits we offer include:

• Flexible working arrangements and hybrid working - DCMS staff work on a flexible basis with time spent in offices, and time spent working from home
  
• 26.5 days annual leave on entry, increasing to 31.5 days after 5 years service
  
• A Civil Service pension with an employer contribution of 28.97%
  
• Access to the Edenred employee benefits system which offers discounts to popular retailers and access to various useful resources such as financial and savings advice
  
• 3 days of paid volunteering leave
  
• Up to 9 months maternity leave on full pay + generous paternity and adoption leave
  
• Staff reward and recognition bonuses that operate throughout the year
  
• Occupational sick pay
  
• Access to the Employee Assistance Programme which offers staff 24/7 confidential support and resources such as counselling, debt guidance and management advice
  
• Active and engaged staff networks to join including the LGBT+, Ethnic Diversity, Mental Health and Wellbeing and Gender Equality Networks
  
• Exceptional learning and development opportunities that you can explore alongside your day to day work
  
• Season ticket loan, cycle to work scheme and much more!
  

Terms and conditions at SCS grades will vary. Those applying for SCS roles should refer to the candidate information pack for more information on terms and conditions.

Things you need to know

Selection process details

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 post, please send us the following documents no later than 23:55 on 27th July 2025via the CS Jobs portal:

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 in reference to the essential requirements highlighted. 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) describing a dashboard project you have delivered, preferably with corporate data, including its objective, how you gathered requirements, the tools and technologies used, your data preparation process, and how you ensured accuracy and stakeholder satisfaction - This will be assessed against Data Management at HEO level

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

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

In the event of a large number of applicants, an initial sift will be conducted on the technical question. Those who are successful in the initial sift will then be scored on all elements of the application.

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

The interview process will assess behaviours , strengths and technical skills , through a scenario based task The behaviours to be tested at interview are:

• Changing and improving
• Delivering at Pace
• Working Together

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

Technical skill to be assessed at interview (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

Your interview will tak e place remotely via GoogleMeets.

Further Information

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 athttps://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 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 applicants 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.

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.

NSV

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

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 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.

Security

Successful candidates must undergo a criminal record check.

Successful candidates must meet the security requirements before they can be appointed. The level of security needed is security check (opens in a new window) .

See our vetting charter (opens in a new window) .

People working with government assets must complete baseline personnel security standard (opens in new window) checks.

Nationality requirements

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)

Working for the Civil Service

The Civil Service Code (opens in a new window) 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 (opens in a new window) .

The Civil Service embraces diversity and promotes equal opportunities. As such, we run a Disability Confident Scheme (DCS) for candidates with disabilities who meet the minimum selection criteria.

The Civil Service also offers a Redeployment Interview Scheme to civil servants who are at risk of redundancy, and who meet the minimum requirements for the advertised vacancy.

Diversity and Inclusion
The Civil Service is committed to attract, retain and invest in talent wherever it is found. To learn more please see the Civil Service People Plan (opens in a new window) and the Civil Service Diversity and Inclusion Strategy (opens in a new window) .

Apply and further information

This vacancy is part of the Great Place to Work for Veterans (opens in a new window) initiative.

The Civil Service welcomes applications from people who have recently left prison or have an unspent conviction. Read more about prison leaver recruitment (opens in new window) .

Once this job has closed, the job advert will no longer be available. You may want to save a copy for your records.

Contact point for applicants
Job contact :

• Name : Glyn. Spencer
• Email :

Recruitment team

• Email :

Further information

The law requires that selection for appointment to the Civil Service is on merit on the basis of fair and open competition as outlined in the Civil Service Commission's Recruitment Principles. <BR>If you feel your application has not been treated in accordance with the Recruitment Principles, and you wish to make a complaint, you should contact in the first instance. If you are not satisfied with the response you receive from the Department, you can contact the Civil Service Commission at:https://civilservicecommission.independent.gov.uk/recruitment/civilservicerecruitmentcomplaints/

Attachments_415647 - Junior Business Intelligence Developer - Candidate Information Pack Opens in new window (pdf, 6938kB) DCMS Application & Interview Guidance for Candidates Aug 23 Opens in new window (docx, 67kB)