Junior Business Intelligence Developer
Role Overview
The role is in the DCMS Data and AI team within the Digital, Data and Technology directorate.
The team develops the Corporate Business Intelligence Platform, including a data warehouse and dashboards used particularly by Finance and HR.
DCMS is preparing a new integrated business suite for Finance and HR, and continues to improve data use and business processes.
The team uses Looker Studio as its primary reporting platform and plans to migrate to Power BI.
The role reports to the Business Intelligence Lead and combines independent work with collaboration in a small team.
Key Skills for This Role
Full Job Posting
About the role
The role is in the DCMS Data and AI team within the Digital, Data and Technology directorate.
The team develops the Corporate Business Intelligence Platform, including a data warehouse and dashboards used particularly by Finance and HR.
DCMS is preparing a new integrated business suite for Finance and HR, and continues to improve data use and business processes.
The team uses Looker Studio as its primary reporting platform and plans to migrate to Power BI.
The role reports to the Business Intelligence Lead and combines independent work with collaboration in a small team.
Responsibilities
- Assist with development and maintenance of the corporate BI platform, data warehouse and dashboarding tools.
- Help design and deliver reports, dashboards and data processes that provide timely, reliable and accessible information.
- Support data integration and improve corporate data quality, accessibility and usability.
- Help adapt and replicate reporting, analytical and automation processes as the department moves from Google tools to Microsoft 365.
- Contribute to the ongoing development and future direction of the BI platform.
Essential requirements
- Knowledge of data warehousing concepts and dimensional data modelling principles.
- Ability to use SQL to extract, transform and analyse complex datasets.
- Experience building reports, dashboards or data visualisations with Power BI, Looker Studio, Tableau or similar.
- Ability to gather and analyse stakeholder requirements for reporting solutions.
- Strong communication skills, including explaining technical concepts and insights to non-technical audiences.
Desirable skills
- Understanding of data integration, data pipeline concepts, ETL/ELT processes and data movement between systems.
- Experience with workflow automation tools such as Microsoft Power Platform, including Power Automate and Power Apps, or Google Apps Script.
Role details
The post is listed as fixed term for two years, with loan and secondment also stated as contract arrangements.
Full-time working is listed, alongside flexible working and job share.
Salary range is £36,734–£40,344, with a Civil Service Pension employer contribution of 28.97%.
One vacancy is advertised in Manchester.
Applicant information
- An information session is advertised for prospective applicants; it is not a job requirement.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Department for Culture, Media and Sport
Honours Strategy Lead
Manchester, GBR
The Department for Culture, Media and Sport is seeking a lead to deliver reform of its honours system and coordinate its contribution to cross-government improvements. The role requires strategic delivery, political awar
Honours Strategy Lead
Manchester, GBR
DCMS is seeking a strategic lead to reform its honours system and improve the quality, diversity and regional representation of nominations. The role leads departmental and cross-government workstreams, advises senior le
Honours Strategy Lead
Manchester, GBR
The Department for Culture, Media and Sport is seeking a lead to reform its honours system and coordinate departmental work on a cross-government review. The role requires strategic delivery, political awareness, senior
Honours Strategy Lead
Manchester, GBR
DCMS seeks a lead to reform its honours system and coordinate the department’s contribution to cross-government improvements. The role requires strategic delivery, political awareness, senior stakeholder engagement, stro
Honours Strategy Lead
Manchester, GBR
The Department for Culture, Media and Sport is seeking a lead to deliver strategic reform of its honours system and contribute to cross-government improvements. The role requires strong political awareness, senior stakeh
Honours Strategy Lead
Manchester, GBR
DCMS is seeking a lead to reform its honours system and coordinate the department’s work on cross-government improvements. The role leads policy and process changes, advises senior decision-makers, and engages ministers
Technology and Cybersecurity Assurance and Risk Manager
London, GBR
DCMS seeks a Technology and Cybersecurity Assurance and Risk Manager to lead its cyber risk programme, assessments, compliance monitoring and supplier risk management. Candidates need cyber security governance and risk e
Technology and Cybersecurity Assurance and Risk Manager
London, GBR
DCMS is seeking a manager to lead its cybersecurity risk programme and inform evidence-based security decisions. The role covers cyber risk assessments, enterprise risk management, GovAssure and arms-length body complian
Honours Strategy Lead
Manchester, GBR
Honours Strategy Lead
Manchester, GBR
Honours Strategy Lead
Manchester, GBR
Honours Strategy Lead
Manchester, GBR
Honours Strategy Lead
Manchester, GBR
Honours Strategy Lead
Manchester, GBR
Technology and Cybersecurity Assurance and Risk Manager
London, GBR
Technology and Cybersecurity Assurance and Risk Manager
London, GBR