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.
Essential Criteria
Your Skills And Experience
* 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.
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: bbchr@bbc.co.uk
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.
#J-18808-Ljbffr