All posts by Katie Straker

Alzheimer’s Society are looking for a Fundraising Database Officer – 12 month contract

Fundraising Database Officer

Alzheimer' class=

Contract: 12 Month Fixed

Salary: £32,908

Location: Tower Hill, London

Closing Date: 28th June 2018

About the role

Working in our Fundraising Database Support team (FDS) you will have a key role in maintaining and improving our CRM by:

  • ensuring data is scrutinised and reconciled prior to import and then imported accurately;
  • identifying and resolving database issues and promoting database use and accuracy amongst colleagues at all levels;
  • providing first class supporter care, maximising income and ensuring the best possible customer experience is delivered to Alzheimer’s Society’s supporters, staff and volunteers;
  • communicating with colleagues at all levels and with external contacts to optimise, schedule and document core processes.

You will be managing a Fundraising Database Assistant and be supported by the Fundraising Database Executive and the rest of FDS.

About you

We are looking for a self-motivated and driven individual who is able to demonstrate reliable attention to detail and strong data maintenance skills.  You will have an inquisitive approach and be comfortable challenging existing processes, driving towards a common goal of continuous improvement.

As a critical part of the team helping to migrate our CRM to a new system (thankQ) over the coming year, you will be able to master existing data processes and assist with the programme of development.

To find out more about the role, download a job description (which also includes the person specification) from the link below. For further information about the role you can also contact or telephone 020 7423 3689.

You can also visit our Working for Us pages, which give you more information about what it’s like to be an employee at the Society. For further information and link to apply CLICK HERE

Information about the application process: Once you click apply you will be asked to complete the following steps.

  1. Pre-application: Input your details including name and email address to register your interest. Alzheimer’s Society will use this information to keep in contact with you about your application and to send you future job alerts if you opt to receive them. By submitting this information you are indicating that you agree to this.
  2. Download and complete an application form. An email with the application form will also be sent to you.
  3. Email your completed application form to  by midnight on Thursday 28th June 2018. 

If you’re experiencing problems applying for this role please contact

Alzheimer’s Society embraces diversity, inclusion and accessibility for all our people. We are committed to building a diverse organisation that represents the communities we serve and ensuring inclusion in everything we do.

No CVs or agencies please.

Late applications will not be accepted.

GOSH are looking for a Campaign Selections Officer

Campaign Selections Officer

GOSHC logo_black text_RGB

Contract: 9 month fixed term

Salary: Competitive

Location: London

Closing Date: 9th July 2018

Role overview

This fixed term post-holder will sit in the Data Marketing Team (which is in the Direct Marketing department) servicing the needs of the charity. The role will involve delivery of ‘business as usual’ supporting the campaign selection requirements of teams where you will work with the requesting team and senior members of the Data Team to understand business objectives and define the best audience for each communication. You will then follow protocols, working to a critical path to create and test SQL queries to pull data from our warehouse delivering accurate, complete selections on time.

Main duties and responsibilities  

  • Liaise with internal teams, to understand their campaign needs, helping to document their requirements; allowing you then to carry out data selections from our data warehouse on time and to brief.
  • Agree the success criteria of each campaign, working alongside the Data Analyst to ensure the data selected, and subsequent response will deliver the insight required.
  • Assist in the development and enforcement of charity wide and product specific communication rules.
  • Keep task related documentation up to date.
  • Identify and flag areas for improvement in selections documentation and procedure contributing to amendments.
  • Liaise with external agencies ensuring that data is delivered on time.
  • Supply external suppliers and agencies with e.g. house and attrition files to supplement their analysis.
  • Assist with data preparation and extracts for post campaign analysis.
  • Maintain supporter contact histories, package codes and campaign meta data repository.
  • Adhere to stringent Data Protection and Security policies and protocols.
  • Pro-actively flag issues impacting campaign analysis / data selections service delivery to manager.
  • To participate in training and other activities as requested.
  • To work as a supportive member of the team, providing cover for and training of other staff as required.
  • To undertake any other reasonable request as required.

For further information and how to apply CLICK HERE

Great opportunity for a Database Officer at the Royal Marsden Cancer Charity

Database Officer


Contract: Permanent

Salary: £32,000

Location: South Kensington, London

Closing Date: 8th July 2018

The Royal Marsden Cancer Charity raises money solely to support The Royal Marsden, a world-leading cancer centre. We ensure our nurses, doctors and research teams can provide the very best care and develop life-saving treatments, which are used across the UK and around the world.

We are looking for a Database Officer to help the Charity achieve its aims and objectives.  Database and Fundraising Support is a small team with ambitious plans to develop new systems and processes to support the growing fundraising department. As one of two database officers you will be responsible for supporting the Database Assistant in ensuring that all data is received and imported accurately into the Raisers Edge and helping to develop new systems and processes to support this. You will help solve problems, answer requests, deliver mailing selections, and promote effective and compliant database use through training and supporting colleagues across fundraising.

Database administration and support

  • Advise and set up coding, structures and processes to reflect the database needs of Fundraising and Finance
  • Carry out recoding and global changes to the database as required
  • Review data and processes to ensure that data within Raiser’s Edge remains compliant to GDPR standards.
  • Proactively evaluate and suggest ways to improve database systems and processes
  • Work with the team to develop and maintain procedural documentation related to use of the database
  • Set up new users and maintain security groups

Data Imports and Quality

  • Design and implement import routines with third-party suppliers as needed
  • Support the Database Assistant to ensure that data from external sources is imported onto the Raiser’s Edge
  • Work with colleagues in the Finance Team to reconcile income
  • Ensure that procedures are in place to check the quality of data input
  • Set up and run database housekeeping procedures to optimise the accuracy of the supporter data.

Data Outputs & Reporting

  • Support and run complex marketing selections from the Raisers Edge
  • Provide reporting and expertise to support the analysis of the campaign results
  • Develop simple data outputs and complex reports using “query” and “export” for fundraisers as required
  • Develop and support use of dashboards for Reporting

Team Working and Support

  • Support team members within Database and Fundraising Support in delivering the team’s day-to-day workload.
  • Work closely with Fundraisers to standardise best practice of the database for income processing, data management and supporter care.
  • Provide user training and develop clear process documentation to support consistent use of the database
  • Build and maintain strong relationships with colleagues across the organisation

For more information and how to apply CLICK HERE

The Microsoft Excel for Data Analysis and Reporting course has a new MANCHESTER date

Microsoft Excel for Data Analysis and Reporting (intermediate level)
Date: Thursday 12th July 2018
Location: St John Ambulance, St John House, Crossley Road, Heaton Chapel, Stockport SK4 5BF
Cost: IoF Individual Member £175, Charity Individual £195
Trainers: Victoria Barham


In this one day course Victoria will introduce you to Excel functionality that is fundamental when analysing and presenting data in Excel. Using relevant examples, you will leave with actionable learnings that you can implement to save time and to make your Excel spreadsheets more flexible and visual.

This is a practical course suitable for those who are familiar with basic Excel functionality but keen to learn more to enhance their work, for example Analysts, Campaign Managers and Database Administrators.

Attendees will need to bring their own laptop with Excel (preferably Windows, with Excel 2010 or later) installed.  Sample data and all course material will be provided on the day by the course trainer.


Essential Functions and Formulas

There are functions and formulas that are essential when analysing and summarising data in Excel. Using hands on experience of working with charity data for over 9 years, Victoria will cover the functions and formulas that are essential when analysing and summarising data in Excel.  These will include using named ranges, sorting, filtering, functions for text manipulation, working with date variables, logical functions such as IF / AND / OR / SUMIF / COUNTIF, and LOOKUP functions.

Excel Charting

Visualising your data in chart form can be a useful way to identify trends and engage your audience. In this session you will learn how to create attractive and relevant charts.

An Introduction to PivotTables

PivotTables are a powerful feature within Excel that allow the user to summarise large datasets with ease. In this session Victoria will introduce you to PivotTables, showing you how to summarise, present and explore complex data with them. 

This is a practical course suitable for those who are familiar with basic Excel functionality but keen to learn more to enhance their work.

What people are saying about it:

“Extremely useful day, looking forward to applying the things I learnt in my job role”

This course was run at a very good pace and Victoria is a very patient and attentive trainer”

Victoria Barham

Victoria has enjoyed many years working within analytical roles, including over 12 years within the Charity Sector. Victoria provides freelance analytical support with clients including DM Insight, PDSA, Tree Aid, Birmingham Children’s Hospital, Noah’s Ark Children’s Hospice, Marie Curie and The Christie Charity with projects including data preparation and exploration, Campaign targeting, selection, and analysis, RFV analysis, Forecasting models, Lifetime Value analysis, FastStats Excelsior Reporting and Predictive Modelling. Victoria can also provide bespoke Excel training courses and is also an accredited trainer in FastStats Discoverer and Excelsior.

Excellent opportunity at Amnesty International this week…

Marketing Analyst (Digital)

Amnesty candle+text (1)

Contract: Permanent

Salary: circa £33,000 p.a.

Location: London, EC2A

Closing Date: 12th June 2018

We are looking for a Marketing Analyst (Digital) to join us at Amnesty International UK (AIUK). This role is based in the Data and Insight Team and within the Corporate Services Directorate.

About the role

The Marketing Analyst (Digital) is responsible for providing the insight, reporting and learnings to evaluate the effectiveness and inform the direction of AIUK’s digital marketing and campaigning activities, to ensure we can maximise engagement, campaign impact and financial return. The role is also responsible for managing the supply of data selections for email and digital marketing campaigns.

About you

You will have experience undertaking analysis and reporting of digital marketing campaigns, as well as of statistical analysis within a digital marketing environment. Experience with relational databases, digital marketing platforms and a range of data analysis tools and techniques is a must. You will be highly numerate with excellent communication skills, enabling you to translate statistical or technical findings in an easy-to-understand manner to stakeholders in the organisation. You must be an advanced user of MS Excel, MS SQL, and a confident user of R, SPSS, SAS or similar statistical analysis tools. You will have a strong understanding of Data Protection legislation, Equal Opportunities, and a commitment to the aims and objectives of Amnesty International UK.

For full details of the role, please see the job description below.

About us

Our aim is simple: an end to human rights abuses. Independent, international and influential, we campaign for justice, freedom and truth wherever they’re denied. Amnesty International is a global movement of more than 7 million people who campaign for a world where human rights are enjoyed by all. Our supporters are outraged by human rights abuses but inspired by hope for a better world – so we work to improve human rights through campaigning and international solidarity. We reach almost every country in the world and have: 

  • more than 2 million members and supporters who drive forward our fight for rights
  • more than 5 million activists who strengthen our calls for justice 

Whether we’re applying pressure through powerful research or direct lobbying, mass demonstrations or online campaigning, we’re all inspired by hope for a better world. One where human rights are respected and protected by everyone, everywhere. 

For more information and how to apply CLICK HERE

Amnesty values a diverse work force and welcomes applications from all sections of the community. 

Interviews: 21 June 2018

Are you a Data Analyst looking for a new role? Eden Stanley may just have the role for you…

Data Analyst

Eden Stanley Logo Blue

Contract: Permanent

Salary: £40,000

Location: Highbury, London

Closing date: 30th June 2018

The main focus of this role will be maintenance and development of our two Tracker services, and insight projects that analyse the Tracker data set to find new insights of value to the sector. In addition, you will deliver project-based quantitative research and data analysis.


  • Ultimate responsibility for the management and development of the ETL (extract, transform and load) process, from survey to dashboard. 
  • Conduct the monthly ETL processes, associated with Eden Stanley’s Tracker services 
  • Perform regular quality checking of Eden Stanley’s Tracker data 
  • Ensure all work is fully compliant with Eden Stanley’s data security policies and relevant regulation.


  • Ad-hoc reporting, auditing data quality, enriching data, and building segmentations and similar analysis.
  • Conduct data analysis projects, including cluster-based audience segmentations and predictive models 
  • Deliver ad hoc data explorations in support of Eden Stanley’s strategy projects, or in response to client queries. 


  • Supporting and developing data visualisations in Tableau and creating usable data exports.
  • Build or modify data visualisation dashboards on Eden Stanley’s Tracker services, in line with our quality standards and brand guidelines
  • Create ad hoc reports, including data tables, and providing data insights for research reports
  • Produce written reports based on your data analysis 


  • Work with colleagues at Eden Stanley, and our external suppliers, in the development of new data products 


  • The role will include some direct communication with clients, for example dealing with a data enquiry, or support in the use of our data services.


Above all you will need the six personal attributes listed on the front sheet of this job description. If you’re not sure you meet all of them, this is probably not for you. If you do, please make sure that you also have the following skills and experience.


  1. A level of education and career experience consistent with the remuneration offered. That means you will have a good degree (or equivalent) and experience working with statistics and data analysis in a marketing context
  2. You will have proficiency in statistical and quantitative analysis, with strong analytical and conceptual skills and demonstrable experience using data analysis techniques to check significance, validity, derive insights and present results to stakeholders
  3. Experience of audience segmentation using cluster modelling in a marketing context
  4. Experience in data visualisation best practice and user experience design
  5. A sense of personal accountability to deliver on your commitments is vital. You will need a ‘can do’ attitude, be willing to roll your sleeves up, be organised and get things done. We work hard at Eden Stanley, and we enjoy our work because it is diverse and rewarding – and we don’t do bureaucracy. 



  1. Commercial experience building and maintaining ETL workflows using tools like Alteryx, Excel and SQL
  2. Proficiency in basic statistical and BI/MI data analysis
  3. Experience using data visualisation tools like Tableau, Qlik or PowerBi
  4. Familiarity with using tools like PowerShell or Python to script automated processes
  5. Familiarity with cloud hosting platforms like AWS or Azure.


  1. Experience using Alteryx and Tableau in an Advertising, Marketing or Communications organisation
  2. Experience using SQL to query, manipulate and manage large volumes of data
  3. Familiarity with content management systems like WordPress
  4. Solid understanding of the ETL, BI and Database landscape.

For the full job description and how to apply click here

Excellent role for a Head of Strategic CRM at UCL

Head of Strategic CRM

UCL logo -small use blk

Contract: Permanent

Salary: £55,163 – £59,981 per annum

Location: London

Closing date: 3rd June 2018

UCL is London’s Global University. We do things differently here and we take the long view. We are not afraid to take risks. We remain focused on making a major contribution to the long term benefit of humanity. In September 2016 UCL launched ‘It’s All Academic’, our bold global Philanthropy and Engagement Campaign to raise £600m to support students, research and the transformation of our campus. It will enable us to achieve more than ever before to secure our position as one of the world’s top higher education institutions. At the end of March 2018 we are delighted to have raised more than £378m towards our target. 

From fighting dementia to ensuring generations of students reach their full potential: It’s All Academic. UCL’s ideas and discoveries are shaping the future, improving lives and having a massive impact on London and the wider world. There has never been a more exciting time to join our Development office. We are a team of exceptionally ambitious, creative and passionate individuals who work together to achieve remarkable things with a global impact, and we would love for you to be part our success on this exciting journey. 

This is your chance to play a pivotal role in delivering our Campaign. As Head of Strategic CRM you will use your technical knowledge and expertise to deliver a focused and effective customer relationship management strategy and systems. These systems will provide excellent data management services and tools to fundraising teams and alumni relations stakeholders across the UCL community. 

You will have significant experience and demonstrable enthusiasm for data management with the ability to inspire colleagues to provide excellent service and innovative solutions to internal clients and external customers. A strong influencer and strategic thinker, you will have the ability to drive change in a large and dynamic organisation. 

We offer an empowering values-based environment where staff are encouraged to try new things. We offer agile working and flexibility around working hours – this post could be a part-time role. We also value mutual respect and collaboration, and have a strong customer-service ethic. Expectations are high and we work hard, but the rewards are huge. UCL is an outstanding place to work. In addition to working with some of the greatest intellects in the world, as a member of the UCL community you are entitled to a generous pension scheme and holiday entitlement, as well as opportunities for personal and professional growth. At UCL we are proud of our longstanding commitment to equality, diversity and inclusion. We welcome people from all backgrounds and strive to create an environment where everyone can give of their best. For any queries about the role please contact Martin Wedlake, Executive Head of Strategic Planning. 

For any queries about the application process please contact Cameron McNeil, People Coordinator. Both can be reached by phone: +44 (0)20 3108 3804 or email: For more information about our philanthropic activities please visit:

For further details about the vacancy and how to apply online please go to and search on Reference Number 1725357

We particularly welcome female applicants and those from an ethnic minority, as they are under-represented within UCL at this level.

We will consider applications to work on a part-time, flexible and job share basis wherever possible.

 To apply click here

Less than a month to go to the Insight in Fundraising Awards 2018

The Insight in Fundraising Awards 2018 will take place at the wonderful Royal Institute of British Architects in Central London on Wednesday 20th June. Minutes from Regents Park, we will be immersed in the splendour of the 1930s in George Grey Wornum’s fantastic building on Portland Place. Wornum was the winner of a competition to design the new headquarters for the RIBA, so a truly fitting venue for our very own awards!

Join us at this incredible venue for an evening that recognises and celebrates the best use of data insight in fundraising. Tickets for the Insight in Fundraising Awards 2018 gala dinner on 20th June are on sale now, so head over to our booking page to make sure you have a seat at this year’s event!

We look forward to seeing you there!

With thanks to our headline sponsor:  REaD Group logo


and all our wonderful sponsors for 2018:

Qbase sponsor Logo

Datatech Sponsor logo

Apteco sponsor logo

WfT sponsor logo



Only four weeks to go…

There is only one month until the Insight SIG event of the summer, the Insight in Fundraising Awards 2018, at the Royal Institute of British Architects in central London. You can be part of the event and celebrate the achievements of your colleagues and peers by reserving your place now!

We would also like to take the opportunity to thank our Sponsors for 2018, without whom we wouldn’t be able to host this wonderful event! A big thank you to:

 REaD Group Sponser logo

Apteco sponsor logo

Datatech Sponsor logo

Qbase sponsor Logo

WfT sponsor logo



There are still a few places left on our fabulous Spring Training Courses…

Insight in Fundraising logo_WEB
We still have a few places remaining on both our Communicating Insight and Insight in Fundraising Essentials courses being held in June. There’s still time to book your place on each of these courses, and as they run consecutively we are offering a fantastic discount of 10% off each course if booked together! Contact us if you’d like to take us up on this fab offer!

Communicating Insight 
Date: Thursday 14th June 2018
Location: RNLI, 124-126 Webber St, London SE1 0QL
Cost: IoF Individual Member £175, Charity Individual £195
Trainers: Ruth Smyth & Steven Dodds

This course will explain how to maximise the benefits of your analysis and research by making findings relevant to your audience and minimise the ambiguity of insight to increase business confidence in the conclusions. It will also teach the mechanics of good visual, verbal and written communication methods and how to apply these to your insight communications.

Insight in Fundraising Essentials
Date: Friday 15th June 2018
Location: Macmillan Cancer Support, Albert Embankment
Cost: IoF Individual Member £175, Charity Individual £195
Trainers: Ruth Smyth & Jon Kelly

This course will help you understand what Fundraising Insight is and how it can benefit your organisation. It will also give you an overview of all the key tools and techniques used to understand your audiences, products and the impact of your communications. Plus you will identify ways in which your charity can develop its use of Insight.

For more information, please see course details here, but hurry, places are limited!