Campaign Planning & Data Selections Officer Contract type: 12 Month Fixed Term Contract. Full Time, 35 hours per week Location: London, UK subject to the right to work. 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. • 60/40 hybrid working at WaterAid is currently defined as: 60% of an employee's time in a location of their choice, 40% face to face, defined as in the London office, at conferences or at stakeholder meetings or other location as relevant for the proper performance of the duties of the role. Salary: £33,266 - £36,000 per year with excellent benefits About WaterAid Want to use your skills in SQL to play a vital role in making clean water, decent toilets and good hygiene 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 Campaign Planning & 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. About the Team The WaterAid Data Selections team works with stakeholders across the entire Fundraising directorate. This is a great role to quickly learn how charities use data for their fundraising communications. About the Role As our data savvy Data Selections Officer, you will update and write SQL scripts to enable WaterAid UKs fundraising mass communications, and champion our supporter's experience ensuring supporters receive communications that are relevant to them. In this role you will collaborate with stakeholders across Fundraising, interpreting their data requests into SQL scripts, and work closely with the Data Engineering team to update our data warehouse as the organisations data requirements evolve. You'll also: • Review current SQL scripts and optimise them • Work with teams on setting up, and updating our supporter journeys • Advise stakeholders on using data effectively, creating variable outputs or segmentation for testing • Work closely with the Analytics team, implementing their findings and collaborating on propensity models • Champion data quality, and work with relevant teams to constantly improve the data in the data warehouse. Requirements The successful applicant will have a keen eye for detail, and be able to interpret natural language data requests into complex SQL queries. To be successful, you'll need: • Experience of writing SQL syntax, including the creation of views, stored procedures and processes. • Good knowledge of data protection legislation and its application. • Working style that reflects WaterAid's values of Respect, Accountability, Courage, Collaboration, Integrity and Innovation. Although not essential, we also prefer you to have: • Experience working in a Fundraising or charity environment. • Demonstrable understanding of a data warehouse. • Previous experience using a CRM system View Full Job Description here Closing Date: Applications will close 12:00pm UK Time on July 04, 2025. Shortlisting and interviews may take place on a rolling basis and the application process will close if a suitable candidate is found prior to the advertised closing date. How to Apply: Click ‘Apply' to complete the pre-screening questions and upload your CV and an essential cover letter. Can I use Artificial Intelligence (AI) technology in my application? At WaterAid, we strongly advise against using AI technology at any stage of the recruitment process. Our goal is to ensure a fair and transparent process that provides every applicant with an equal opportunity to succeed. We value hearing about your unique experiences and perspectives in your application, and, if shortlisted, during the interview as well. Pre-employment screening: To apply for this post, you must be able to demonstrate your eligibility to work in the respective country. All pre-employment checks will be carried out according to the applicable laws in the respective countries to comply with our Safer Recruitment policy. All our UK-based vacancies require a basic Disclosure and Barring Service (DBS) check. Benefits 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.