Junior Business Intelligence Developer
Role Overview
The role is in the Data and AI team within DCMS Digital, Data and Technology.
The team develops a corporate BI platform comprising a data warehouse and dashboards, supporting decision-making across the department.
The platform supports users, particularly in Finance and HR, and is expanding to include more business data sources.
Looker Studio is currently the primary reporting platform, with migration to Power BI planned.
Key Skills for This Role
Full Job Posting
Role overview
The role is in the Data and AI team within DCMS Digital, Data and Technology.
The team develops a corporate BI platform comprising a data warehouse and dashboards, supporting decision-making across the department.
The platform supports users, particularly in Finance and HR, and is expanding to include more business data sources.
Looker Studio is currently the primary reporting platform, with migration to Power BI planned.
Job responsibilities
- Assist in developing and maintaining the Corporate BI Platform, including its data warehouse and dashboard tools.
- Help design and deliver reports, dashboards, and data processes that provide timely, reliable, 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-based tools to Microsoft 365.
- Work independently while contributing flexibly to a small collaborative team.
- Apply data, automation, and emerging technologies to challenges beyond traditional business intelligence.
Essential requirements
- Know data warehousing concepts and dimensional data modelling principles.
- Use SQL to extract, transform, and analyse complex datasets.
- Have experience building reports, dashboards, or visualisations with Power BI, Looker Studio, Tableau, or similar BI platforms.
- Gather and analyse stakeholder requirements to deliver reporting solutions that meet user needs.
- Communicate effectively and explain technical concepts and insights to non-technical audiences.
Desirable skills
- Understanding of data integration, data pipelines, ETL/ELT processes, and data movement between systems is desirable.
- Experience with workflow automation tools such as Microsoft Power Platform, Power Automate, Power Apps, or Google Apps Script is desirable.
Pay and contract
- The listed salary range is £36,734–£40,344; no pay cadence is stated.
- The contract is fixed term for two years; loan or secondment arrangements are also listed.
Working pattern
- The listed working patterns include flexible working, full time, and job share.
Role details
The position is in Manchester and reports to the Business Intelligence Lead.
An information session is offered to prospective applicants; it is not a recruitment-process briefing.
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