Overview
The Insight team plays a pivotal role at BBC Children in Need, supporting teams across the charity by leveraging insight to shape and evaluate our funding, storytelling, communications and fundraising activity. As a "Data Analyst – Income and Supporters", you will work in partnership with stakeholders in Finance, Technology and Commercial teams to ensure they have the data and insight they need to inform decision‑making and shape their activity. You will also work closely with Insight colleagues to maintain an integrated approach to our use of data.
WHY JOIN THE TEAM: As the BBC’s charity, our ambition within Children in Need is to create positive and lasting change across the UK for children and young people who need us most. You will be part of an enthusiastic, close‑knit team with a strong sense of shared purpose. Your work will directly impact the difference we make for children and young people.
Responsibilities
* Develop and maintain donation and audience dashboards (currently Tableau), working with Finance on income reconciliation. Use Excel Power Query, VBA and/or SQL to feed Tableau data sources with commercial data from various sources and the CRM, to ensure all Fundraising and Income dashboards are up to date.
* Work with the Technology team to progress data automation and AWS/data platform development and play an active role in the charity’s Technology Working Group, ensuring alignment and best practice across all fundraising data processes and systems.
* Support Appeal broadcast reporting, updating the donation dashboard after each broadcast to enable income to be reported.
* Integrate donation/supporter data and analysis into the broader planning and evaluation outputs of the Insight team, including annual appeal evaluation, quarterly and bi‑annual performance reporting.
* Support Appeal activity, including providing data for the Marketing and Fundraising teams to activate key initiatives (e.g. fundraising packs, direct debits).
* Respond to ad‑hoc data requests from CRM data stakeholders, extracting, analysing and sharing data as required, in line with GDPR principles.
* Support stakeholders with insight, analysis and reports generated from the CRM, as well as with ad‑hoc and regular data‑related projects and tasks. This includes contributing income‑related KPIs to organisational performance reporting.
Qualifications
* Experience of building and using BI / dashboard solutions (e.g. Tableau, Power BI, Access Analytics) to present fundraising insight and track key data KPIs.
* Experience of building data warehouse models to combine separate data sets, check data quality, clean data and create bespoke data views, enabling accurate Insight / BI dashboards, reports and KPI trackers, ideally using Access Data Engine.
* Experience of using Excel Power Query, VBA and/or SQL to analyse and cleanse / code / update large data sets, ensuring dashboards and reports are accurate and KPIs are correct.
* Experience of importing and extracting data from fundraising/commercial CRM databases, specifically Access Charity CRM.
* Experienced in a fast‑paced, matrix environment with multiple stakeholders. Proficient in requirements gathering / engineering and Agile project management, specifically in a Scrum Master or Scrum Product Owner role.
* Experience working in charity, voluntary or public sector, preferably in a fundraising related role, with knowledge of supporter data types and donation platforms (e.g. online, text, cheques, etc.).
Before your start date, you may need to disclose any unspent convictions or police charges, in line with our Recruitment policy. Failure to disclose may result in the withdrawal of your offer.
BBC Group and Public Services, Broadcasting House, Portland Place, London, United Kingdom, W1A 1AA.
We welcome applications from individuals, regardless of age, gender, ethnicity, disability, sexual orientation, gender identity, socio‑economic background, religion and/or belief.
J-18808-Ljbffr