Data Associate

Package Description

Job Reference: 17933

Band: B

Location: UK Flexible with travel to Salford required

Contract: Fixed Term Contract / Attachment till 01/09/2025

Salary: £24,000 - £28,000 depending on relevant skills, knowledge and experience. The expected salary range for this role reflects internal benchmarking and external market insights. London weighting may be applicable for this role.

We’re happy to discuss flexible working. Please indicate your choice under the flexible working question in the application. There is no obligation to raise this at the application stage but if you wish to do so, you are welcome to. Flexible working will be part of the discussion at offer stage.

•  Excellent career progression – the BBC offers great opportunities for employees to seek new challenges and work in different areas of the organisation.

•  Unrivalled training and development opportunities – our in-house Academy hosts a wide range of internal and external courses and certification.

•  Benefits - We offer a negotiable salary package, a flexible 35-hour working week for work-life balance and 25 days annual leave with the option to buy an extra 5 days, a defined pension scheme and discounted dental, health care and gym. You can find out more about working at the BBC by selecting this link to our candidate pack.

If you need to discuss adjustments or access requirements for the interview process please contact the [email protected]. For any general queries, please contact: [email protected].

Job Introduction

BBC Children in Need believes that every child should have the chance to thrive and be the best they can be. We are committed to being there for children across the UK when they need us the most. Together with the BBC and our partners, we inspire the nation to support this work.

We are committed to funding the grassroots organisations and project workers across the UK that provide the vital positive relationships children need to help them navigate the challenges in their lives. Our project workers support, inspire and champion them to ensure they have opportunities and can reach their goals. And that will always be our approach.

We fund thousands of charities and projects in every corner of the UK, that support children and young people to feel and be safer, have improved mental health and wellbeing, form better, more positive relationships and be given more equal opportunities to flourish.

In the run up to the 2024 Children in Need annual TV appeal we are looking for a data associate to join our team to get hands on experience of managing the charity’s incoming donations and fundraising data. Within this role you will;

• Maintain and develop the existing semi-manual Charity CRM data import and export processes, ensuring that data quality and accuracy is high and the solution remains ‘fit for purpose’ in supporting Income generation, Marketing, Supporter Care and Insight strategies.
• Assist in the maintenance of the CRM through application of existing system processes, including GDPR retention policies, deduping, data cleansing and Gift Aid processing.
• Develop and maintain the existing CRM process and user guide documentation and ensure relevant resources are made available to all stakeholders via the Insight Hub.
• Support stakeholders across multiple CIN divisions with insight, analytics and reports generated from the CRM, as well as with various ad hoc and regular data related projects and tasks.

Main Responsibilities

The Data Associate will report to the Data Systems Manager, within the Insight team. This team works across all areas of Children in Need in supporting the delivery of our organisational objectives through the generation of insight and data to inform decision-making. The main focus of the Data Associate will be on Fundraising related data and systems, including;

• Download commercial data from multiple sources and be responsible for cleansing it using Excel Power Query, VBA and/or SQL, and importing it into our CRM – checking exception reports to ensure accuracy and spotting errors and trends that need the Data Systems Manager’s attention.
• Maintain the coding structure of the commercial data, including CRM classifications, financial coding, libraries and look ups, to ensure our data is allocated and segmented accurately.
• Work with the Data Systems Manager to cleanse CRM data, performing de-duplication and record consolidation routines on a regular basis.
• Ensure customer opt-ins and preferences are kept up to date in the CRM and that we comply with GDPR regulations at all times.
• Assist in the application of our GDPR retention policies, ensuring data is anonymised or deleted in accordance with our rules in a timely manner.
• Build and maintain system procedure documentation, for both technical and end users of the CRM.
• Support annual Appeal activity, including providing data for the Marketing and Commercial teams on key initiatives (e.g. fundraising packs, direct debits and donations)
• Work with the Marketing Coordinator to ensure CRM alignment with the email marketing delivery system
• Respond to ad-hoc data requests from all CRM data stakeholders, extracting, analysing and sharing data as required, ensuring adherence to GDPR principles at all times.
• Support the Data Systems Manager in preparing the CRM Gift Aid Declaration data prior to submitting Gift Aid claims on a regular basis.
• Use Excel Power Query, VBA and/or SQL to feed Tableau data sources with commercial data from various sources and the CRM, to ensure Fundraising and Income dashboards are up to date.
• Support the Data Systems Manager with the move towards system-to-system integration and data process automation, providing analysis, feedback and detail from the existing CRM related processes when required.

Are you the right Candidate?

The successful candidate will have:

• Experience of cleansing large datasets to ensure data accuracy.
• Experience of using Excel Power Query, VBA and/or SQL to analyse and cleanse / code large datasets.
• Knowledge of / experience using fundraising/commercial CRM databases, specifically Access Charity CRM
• Driven by working closely with large datasets, questioning inconsistencies and spotting patterns that may need attention.
• Self-starter in nature who also works well in a complex matrix organisation, where you have to take people with you to achieve goals.
• Meticulous attention to detail with an ethos of owning data and understanding of the importance of clean and reliable data in an analysis environment.
• Experience of project working, including proven ability to deliver to deadlines.
• Experience of logically diagnosing technical issues.
• Experience of prioritising work effectively.
• Experience of preparing regular database reports.
• Experience in communicating effectively with a wide range of colleagues.
• Experience of working under pressure with high volumes of work.
• Experience of updating process documents.
• An understanding of the Data Protection Act 2018 and GDPR.

Desirable

• Experience of working in the charity, voluntary or public sector, preferably in a fundraising environment.
• Experience of using BI / Dashboard solutions (e.g Tableau, Power BI) to build analytics dashboards, to present insight and report on KPI’s etc.

About the BBC

The BBC is committed to redeploying employees seeking suitable alternative employment within the BBC for different reasons 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.

We don’t focus simply on what we do – we also care how we do it. Our values and the way we behave are important to us. Read about them here

Diversity matters at the BBC. We have a working environment where we value and respect every individual's unique contribution, enabling all of our employees to thrive and achieve their full potential.

We want to attract the broadest range of talented people to be part of the BBC – whether that’s to contribute to our programming or our wide range of non-production roles. The more diverse our workforce, the better able we are to respond to and reflect our audiences in all their diversity.

We are committed to equality of opportunity and welcome applications from individuals, regardless of age, gender, ethnicity, disability, sexual orientation, gender identity, socio-economic background, religion and/or belief. We will consider flexible working requests for all roles, unless operational requirements prevent otherwise. To find out more about Diversity and Inclusion at the BBC, please click here.