Data Analyst in City of Westminster

As part of the BBC's Creative Diversity team, this role will play a key part in transforming complex production, commissioning and diversity data into meaningful business intelligence. Working across multiple data sources, you’ll help build a robust data and reporting infrastructure, bringing datasets together, developing impactful Power BI dashboards and generating insights that enable better-informed decision-making and track progress against the BBC's creative diversity ambitions. This is a hands-on role suited to an experienced Data Analyst who can quickly understand complex data, establish effective reporting solutions and translate information into clear, accessible insight for a range of stakeholders. You’ll be comfortable working at pace and taking ownership of defined deliverables within a short-term assignment. Interviews - please note that there may be up to 2 interviews required for this role.

Responsibilities

• Design, develop and maintain a suite of Power BI dashboards and reporting tools enabling stakeholders to monitor performance against Creative Diversity priorities.
• Bring together and interrogate complex datasets from multiple sources, including production, commissioning and diversity data, establishing consistent structures and improving data quality.
• Translate complex datasets into clear business insight and compelling, user-friendly visualisations for technical and non-technical stakeholders.
• Work closely with the Creative Diversity Operations Lead and relevant data stakeholders to ensure information is accurate, accessible and fit for analysis and reporting.
• Support colleagues to understand and use reporting tools and dashboards, contributing to guidance and knowledge transfer to build sustainable capability within the team.
• Develop custom visualisation approaches using Power BI custom visuals, HTML and/or JavaScript solutions.
• Manage delivery against the agreed three-month scope, identifying and escalating risks, dependencies and data-quality issues.

Education to degree level or above in STEM subject or equivalent experience

• Strong Power BI expertise, with demonstrable experience designing and developing dashboards and intuitive, user-friendly data visualisations.
• Proficient in developing and maintaining Python and SQL scripts to automate processes, analyse data, and improve operational efficiency.
• Strong Excel and data manipulation skills, including experience cleaning, consolidating and structuring datasets using formulas, data transformation techniques and structured reporting approaches.
• Experience developing data visualisation solutions, including Power BI custom visuals and HTML and/or JavaScript, with the technical capability to adapt reporting solutions to meet business requirements.

Desirable

• Experience working with diversity, representation, audience or workforce data, including knowledge of frameworks such as Diamond or equivalent monitoring/reporting systems.
• Experience working with TV commissioning, production or media data, including familiarity with relevant systems, workflows and data structures.
• Strong stakeholder and communication skills, with the ability to understand business requirements and translate complex data into clear, accessible insights and reporting products for technical and non-technical audiences.

Please wait... BBC Group and Public Services, Broadcasting House, Portland Place, London, United Kingdom, W1A 1AA. BBC Studios Distribution Limited, company no: 01420028, registered address: 1 Television Centre, 101 Wood Lane, London, United Kingdom W12 7FA.

Disclaimer This job description is a written statement of the essential characteristics of the job, with its principal accountabilities, incorporating a note of the skills, knowledge and experience required for a satisfactory level of performance. This is not intended to be a complete, detailed account of all aspects of the duties involved. Please note: If you were to be offered this role, the BBC will conduct Employment screening checks which include Reference checks; Eligibility to work checks; and if applicable to the role, Safeguarding and Adverse media/Social media checks. Any offer made is conditional on these checks being satisfactory. Before your start date, you may need to disclose any unspent convictions or police charges, in line with our Recruitment policy. This allows us to discuss any support you may need and assess any risks. Failure to disclose may result in the withdrawal of your offer. For any general queries, please contact:

Redeployment The BBC is committed to redeploying employees seeking suitable alternative employment within the BBC and they will be given priority consideration ahead of other applicants. Priority consideration means for those employees seeking redeployment their application will be considered alongside anyone else at risk of redundancy, prior to any individuals being considered who are not at risk.

Information at a Glance

This is your BBC At the BBC you can create and innovate in an inclusive environment while contributing to some of the world's best loved content, and the BBC's mission to inform, educate and entertain.

Life at BBC

• Fair pay and flexible benefits including a competitive salary package, a flexible 35-hour working week, 25 days annual leave with the option to buy an extra 5 days, a defined pension scheme and discounted dental, health care and gym.
• Excellent career and professional development.
• Support in your working life, including flexible working which you can discuss with us at any point during the application, selection or offer.
• A values-based organisation where the way we do things is important as what we do.
• Benefits may vary if you are joining on an FTC basis or on an orchestra conditions contract. Learn more about life at the BBC and our values in our candidate pack.

You belong We have a working environment where we value and respect every individual's unique contribution, so all our employees feel that they can belong, thrive and achieve their full potential. We want to attract the broadest range of talented people to join us. The more diverse our workforce, the better able we are to respond to and reflect our audiences in all their diversity. We welcome applications from individuals, regardless of age, gender, ethnicity, disability, sexual orientation, gender identity, socio-economic background, religion and/or belief. Find out more about diversity, inclusion and belonging in our strategy below. Disability confident