Data Analyst - Income and Supporters
Role details
Job location
Tech stack
Job description
The Insight team plays a pivotal role at BBC Children in Need, supporting teams across the charity by leveraging insight to both shape and evaluate our funding, storytelling, communications and fundraising activity. As 'Data Analyst - Income and Supporters', you will work in partnership with stakeholders in the Finance, Technology and Commercial teams, helping to ensure that they have the data and insight they need to inform their decision making and shape their activity. You will also work closely with Insight colleagues to ensure that we have 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 the children and young people who need us most. You will be part of an enthusiastic and close-knit team with a strong sense of shared purpose. Your work will directly impact the difference we make for children and young people., * Develop and maintain our 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 our 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 of the charities 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.
Requirements
- Experience of building and using BI / Dashboard solutions (e.g. Tableau, Power BI, Access Analytics), in order to present fundraising insight and track key data KPI's.
- Experience of building data warehouse models to combine separate data sets together, check data quality, clean data and create bespoke data views, to enable the creation of 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 datasets, to ensure dashboards and reports are accurate, KPI's are correct and all insight generated is coherent and useful.
- Experience importing and extracting data from fundraising/commercial CRM databases, specifically Access Charity CRM.
- Experienced in working in a fast-paced matrix environment, with multiple stakeholders. Proficient in requirements gathering / engineering and Agile project management methodology, specifically as a Scrum Master or Scrum Product Owner.
- Experience of working in the charity, voluntary or public sector, preferably in a fundraising related role, with knowledge and experience of various supporter data types and donation platforms (e.g. Online, Text, Cheques etc.) If you can bring some of these skills and experiences, along with transferable strengths, we'd love to hear from you and encourage you to apply. Before your start date, you may need to disclose any unspent convictions or police charges, in line with our Contracts of Employment 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.
Benefits & conditions
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 Here you will benefit from:
- 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