This role sits within the Data team, part of the DCMS Digital, Data and Technology (DDaT) directorate.
Within the next 2 years, DCMS is implementing a new integrated business suite (ERP) for finance and HR services. As a directorate we are continuing to find new ways to improve data and processes, optimising the use of existing systems and utilising additional tools where appropriate to drive innovation.
One of the key pillars of this work is the development of a Corporate Business Intelligence Platform. This platform is the key responsibility of the Business Intelligence team. We are currently a small team with an ambitious remit to unlock the value of corporate data, putting it front and centre in the decision making process for departmental decision makers.
If you are a systems thinker, interested in developing digital skills and capability, and passionate about technology then this may be the role for you.
Job description
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
Essential Requirements:
* Proven understanding of fundamental data warehousing concepts, including ETL/ELT processes and data modeling, in line with best practices for data engineering.
* Experience developing reports and dashboards using tools such as Looker Studio, Power BI, or Tableau, ensuring effective data presentation.
* Experience using data migration tools (for example, SQL Server Integration Services (SSIS) or similar) to support data movement and transformation.
* Proficiency in SQL,with demonstrable experience in querying and manipulating data to support analysis and reporting.
* Act as an advocate for the team within DCMS, supporting collaboration and promoting best practices in data engineering.
Desirable Skills:
* Experience of working on corporate reporting (notably within Finance and HR).
* Experience in process redesign and change management, applying data-driven approaches to enhance efficiency and effectiveness.
* Familiarity with automation tools such as Google Apps Script or Microsoft Power Automate.
* Experience using workflow automation and scheduling tools such as Google Cloud Workflow and Cloud Scheduler or similar.
* Commitment to continuous learning and development in digital and data-related skills.
We are running an information session where prospective applicants can find out more about the role. This will be hosted by Glyn Spencer & Harry Ager, and will take place on:
* Monday 10th March at 3pm
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 7th March 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 recruitment.team@dcms.gov.uk
Calculate your take home pay. Use this service to estimate how much Income Tax and National Insurance you should pay for the current tax year.
Employment could affect your benefits, find out more here. Turn2us Benefits Calculator.