Data Selections Officer

Job Description

Data Selections Officer

Contract: Permanent, Full Time

Salary: £31,352 to £32,919 with excellent benefits

Location: London, UK

Hybrid Working: A minimum of 40% of working time is spent face to face, either in London office, or as a result of external engagement or travel for WaterAid. WaterAid is located at Canary Wharf, London and this will be your location and contract base.

About WaterAid:

Want to use your skills in events delivery to play a vital role in making clean water, decent toilets and good hygiene normal for everyone everywhere. We need passionate, creative and dedicated people.

In return, you will be encouraged and empowered to be yourself at your very best. Together, we will make a bigger difference.

Join WaterAid as Data Selections Officer to change normal for millions of people so they can unlock their potential, break free from poverty and change their lives for good. On top of that you'll be joining a 2020 Great Place to Work® award-winning organisation.

About the team:

The Campaign Planning & Selections Team, headed by the Campaign Planner & Data Selections Manager, sits within part of the Performance, Insight and Innovation Department. Working alongside the Business Insight Teams, the team is focused on ensuring that WaterAid UK adopts an insight-led and data-driven approach to maximising return on investment in fundraising and campaigning activity. This is achieved through targeted supporter communications, delivering data selections, activity monitoring and end of campaign reporting.

About the role:

The Data Selections Officer plays a vital role in understanding all communication activity broadcast by WaterAid UK, and by using SQL to extract the relevant data from the data warehouse for those campaigns. You will work closely with members of the Campaign Planning and Selection team, and the wider Performance, Insights and Innovation department, to implement new processes and procedures into your working to improve our team's efficiency and effectiveness.

You'll also:

• Managing relationships with stakeholders both inside and outside of the Performance, Insight and Innovation Department (PIID), with a particular focus on Campaign data selections delivery.
• Managing the scheduling and delivery of data selections and segmentations in an accurate and timely fashion, in accordance with the agreed data selection brief, deadlines, and legislation/policy.
• Having an overview of all campaign audience activity and implementing automated data selections for campaigns that are run regularly.
• Maintaining backend processes to update the database with communications history and marketing coding systems during campaign data selections.
• Creating and updating Data Selections process documents, and maintaining filing systems for easy retrieval of documentation.
• Ensuring that data selections adhere to formats as defined by the Supporter Experience + Operations team.
• Review the data warehouse regularly to ensure processes are optimised for selections and provide wider support to the team on the data warehouse functionality.
• Liaising with key stakeholders across the organisation to help ensure data selection briefs are interpreted accurately and that they deliver on their objectives.
• Collaborating with Campaign Planning & Selections team members to think of creative ways of measuring campaign success through end of campaign reporting and exploring innovative solutions to maximise supporter engagement.

About you:

• Advanced knowledge of relational databases and experience of working with large and complex data sets.
• Extensive experience of building complex queries and producing data selections from a database package. Experience of writing SQL syntax, including the creation of views, stored procedures and processes.
• Advanced MS Excel skills.
• Excellent verbal and written communication.
• An ability to think beyond the remit of the role and to apply creative problem solving skills.
• Proven ability to work to a high standard and with an eye for detail, working under own initiative and managing multiple tasks simultaneously.
• Good knowledge of data protection legislation and its application.
• Relevant degree or equivalent qualification or experience.
• Working style that reflects WaterAid's values of Respect, Accountability, Courage, Collaboration, Integrity and Innovation.

Closing date: Applications will close at 23:59 on 26th January 2024. Shortlisting and interviews may take place on a rolling basis and the application process will close if a suitable candidate is found before the advertised closing date.

How to Apply: To see the full job pack, please click 'Apply'. Please apply by submitting your CV and a cover letter in one document in either Word Document or PDF format.

Pre-employment screening: To apply for this post, you must be able to demonstrate your eligibility to work in the UK. All our vacancies require a basic Disclosure and Barring Service (DBS) check to comply with our Safer Recruitment policy.

Our Benefits:

• 36 days' holiday (including 8 Bank Holidays)
• Option to buy an extra 5 days annual leave
• We offer a generous pension plan with employer contribution of up to 10%
• Wide range of flexible and agile-working arrangement
• Season Ticket Loan
• Free annual eye tests
• Pay as You Give charitable giving scheme
• Enhanced Maternity and Adoption/Surrogacy pay, Shared Parental Leave and Paternity Leave
• Sabbaticals
• Volunteer Day

Our Commitment

Our People Promise:
We will work with passion and focus to ensure safe and sustainable water, toilets and hygiene are available to everyone, everywhere. WaterAid is a place of purpose - where people have a real commitment and shared responsibility for the impact we have. We are a global community with diverse backgrounds and perspectives, motivated by inspiring, stimulating work. We are determined to put the wellbeing of our people first, to be a place where people feel safe and able to contribute their voice and truly live our values.

Equal opportunities:
We are an equal opportunity, disability-confident employer and are dedicated to achieving the highest standards of diversity, equity and inclusion. We welcome applications from people of all backgrounds, beliefs, customs, traditions and ways of life. This includes, but is not limited to, race, gender, disability, age, sexual orientation, religion, national or social origin, health status, and economic or social situation.

Safeguarding:
We are also committed to protecting everyone we come into contact with. We have a zero-tolerance approach to abuse of power, privilege or trust across our global work, and any form of inappropriate behaviour, discrimination, abuse, bullying, harassment, or exploitation. Safeguarding the people and communities we work with, our staff, volunteers and anyone working on our behalf is our top priority, and we take our responsibilities extremely seriously.