Data Analyst - Income and Supporters

Job Details

EXTERNAL TITLE: Data Analyst - Income and Supporters
IN-HOUSE TITLE: Data Analyst (Charity)
JOB BAND: C
CONTRACT TYPE: Permanent, Full-time.
DEPARTMENT: BBC Children in Need.
LOCATION: Salford - hybrid.
PROPOSED SALARY RANGE: £29,000-35,000 depending on relevant skills, knowledge and experience. The expected salary range for this role reflects internal benchmarking and external market insights.

We're happy to discuss flexible working. If you'd like to, please indicate your preference in the application - though there's no obligation to do so now. Flexible working will be part of the discussion at offer stage.

PURPOSE OF THE ROLE

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.

YOUR KEY RESPONSIBILITIES AND IMPACT:

• 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.

YOUR SKILLS AND EXPERIENCE

ESSENTIAL CRITERIA:
1. 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.
2. 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.
3. 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.
4. Experience importing and extracting data from fundraising/commercial CRM databases, specifically Access Charity CRM.
5. 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.
6. 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.