Junior Business Intelligence Developer

Job summary

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.

Job description

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.

Person specification

Essential requirements:

• Knowledge of data warehousing concepts and dimensional data modelling principles.
• Ability to use SQL to extract, transform, and analyse data across complex datasets.
• Experience building reports, dashboards, or data visualisations using BI tools such as Power BI, Looker Studio, Tableau, or similar platforms.
• Ability to gather and analyse requirements from stakeholders to deliver effective reporting solutions that meet user needs.
• Strong communication and interpersonal skills, with the ability to explain technical concepts and insights to non-technical audiences.

Desirable skills:

• Understanding of data integration and data pipeline concepts, including ETL/ELT processes and data movement between systems.
• Experience with workflow automation tools, such as Microsoft Power Platform (including Power Automate, Power Apps) or Google Apps Script.

We are running an information session where prospective applicants can find out more about the role. This will be hosted by Glyn Spencer and Harry Ager, and will take place on:

Tuesday 13th October at 10:00am

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 and you will be sent an invitation. Invites will only be sent after this deadline has passed.

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

Behaviours

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

• Changing and Improving
• Making Effective Decisions
• Working Together

Technical skills

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

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

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 £36,734, Department for Culture, Media and Sport contributes £10,641 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).

DCMS values its staff and offers a wide range of benefits to everyone who works here. We’re 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

Artificial intelligence

Artificial intelligence can be a useful tool to support your application, h