Senior Data Analyst

RECRUITMENT PACK

What you need to know

The post is the Senior Data Analystand you’ll be in the Public Engagementdepartment.

This role will play a critical part in identifying and delivering opportunities for growth for Plan UK.

You will work with the Business & Marketing Analysis Manager to provide business insights through robust analysis of our supporter data and behaviours,and Plan’s public engagement activities, in order to inform short and long term strategies for maximising donor engagement and income.

Working closely with teams across Plan UK, particularly units in the Public Engagement department and in Management Information Systems, you will gather and input into reporting and analysis requirements, brief in data requests and use your extensive knowledge of statistical and analytical methodologies to provide robust interpretations and recommendationsaroundperformance, behaviours and trends.

This is anexciting opportunity to help shape Plan’s future by managing and interpreting complex data setsto identify learnings, gaps and trends that you translate into meaningfulinsights and recommendations that will influence the way Planworks and help build a better future for children around the world.

It’s a permanent contract at34.5 hours a week[we finish at 4.30pm on a Friday].

We are based in Old Street, London. (Finsgate, 5-7 Cranwood Street to be precise)

What we’re looking for

We are looking for an ambitious professional with strong experience in providing robust data analysis, including statistical regression modelling, to identify and forecast trends and learnings that will drive strategy and business insight. You will have proven experience both of managing analysis projects and delivering analysis yourself on marketing performance, and customer and behavioural data. You will be comfortable working with qualitative as well as quantitative data although your main strengths will lie in quantitative analysis.

You will need to be a strong communicator, comfortable working with diverse and senior audiences, translating complex data sets and statistical findings into meaningful, digestible insights for colleagues to apply in their own areas of work.

You will also be curious about the world and dissatisfied with the status quo. You will have proven experience in creative thinking, identifying growth opportunities and making change happen. You will be keen to learn, develop your skills and take on new challenges with no obvious answer. The successful candidate will have a unique opportunity to influence Plan’s strategy and ways of working, as well challenging what’s possible in the charity and marketing sectors.

Please note: to apply for a position with Plan UK, you must be eligible to live and work in the United Kingdom(in accordance with the Immigration, Asylum and Nationality Act 2006). Most importantly, we follow stringent child protection policies and procedures when dealing with applications.

What we offer you

The usual recruitment rate for this post (Grade 3) is £35,224 with future pay progression within the pay band from £35,224 to £37,078.

We have a generous annual leave entitlement which starts at 25 days (plus public holidays) for new starters.It goes up to 30 once you’ve been with us for 6 years.

We match contributions up to 6% on thepension scheme (which you can join once you’ve been with us for 3 months)

Weaim to be a family-friendly employer, withenhanced maternity, paternity and adoption leave and pay, as well as child care vouchers and a flexible working policy.

Even morebenefits include season ticket loans, study loans, a healthcare plan;cycle scheme and career break policy.

We would like all applications by 8April2014. Interviews will take place Tuesday 15thApril 2014.

Job PLAN UK JOB PROFILE
Job Title / Senior Data Analyst
Department / Public Engagement
Unit / Business Improvement & Innovation
Reporting to / Head of Business Improvement & Innovation
Overview of Department
The Public Engagement department encompasses fundraising, major partnerships, campaigns, publications and digital media, media relations, public policy and advocacy. Its purpose is to raise funds and create a shift in public opinion on international children’s development and rights issues by mobilising the income, resources and forces that are needed to support Plan’s work. The department:
  • raises funds by engaging, securing and maintaining support from UK households, companies and other major partners
  • raises the profile and awareness of Plan’s work among key target audiences, inspiring their support
  • leverages Plan’s programme work through effective advocacy and campaigning
Its current audiences are supporters and potential supporters among UK households, UK businesses, the education sector and opinion formers on development policy, including UK Parliamentarians.
The role of the Business Improvement and Innovation Unit is to encourage and drive innovation and improvement across all Plan UK’s public engagement activities; to develop and drive new products, initiatives and opportunities; to help determine and co-ordinate the Public Engagement Department’s approach to new media and digital; to deliver market and competitive activity analysis and supporter insight; to ensure a supporter data strategy is in place to enable analysis of Plan UK supporter trends and business learning. The team also has a cross-organisational role, and the unit is required to support and encourage innovation and continual improvement across Plan UK.
Job Purpose
The overall purpose of the Senior Data Analyst is to identify and develop opportunities for growth for the Public Engagement Department through robust analysis of marketing performance, supporter data and behaviours.
Reporting to the Business & Marketing Analysis Manager, the core purpose of the Senior Data Analyst is to:
  • Provide business insights into supporter behaviour, consumption patterns and marketing performance by obtaining data, analysing it (initially using Excel but also using specialised tools where appropriate), topresent results to a variety of internal audiences using reporting and presentation tools
  • Formulate and perform mathematical modelling, statistical/quantitative analyses, predictive analytics and data investigationto support business decision-making, and marketing and product development
  • Work with Public Engagement units and the Management Information Systems teamto develop internal reportsto regularly measure performance, identifying key indicators and metrics that will allow you to draw meaningful inferences and make recommendations to support business decision-making, and marketing and product development
  • Develop internal audience segmentation, working with theBusiness & Marketing Analysis Manager to develop an audience development strategy; and communicate this information to staff to ensure the Public Engagement department applies audience insight and strategic direction to their planning, activities and supporter journeys
  • Lead projects, conduct strategic reviews and contribute to improving the quality of Plan’s data by carrying out data cleansing exercises, setting up data capture business rules and establishing marketing data frameworks in orderto enable and future-proof meaningful analyses. Instruct and advise internal teams on multivariate testing and test matrices to ensure data capture serves strategic objectives and that learnings are maximised
  • Identify opportunities for growing Plan’s business insight andcommission and project manageexternal analysis projects to this end
  • Be pro-active, flexible and adaptable, carrying out ad hoc duties as necessary

Key Duties / Key Activities
Provide robust analysis and recommendations to inform business decisions and strategy /
  • Work across Public Engagement to gather and document analysis requirements, ensuring business objectives are clear and agreed with stakeholders
  • Identify most appropriate methodologies for data investigation; and make recommendations for outsourcing / software purchase where necessary
  • Brief in data requests according to chosen methodologies and requirements
  • Interrogate complex data sets to draw inferences from and make recommendations
  • Translate findings into simple and compelling narratives to present back to audiences with recommendations, using engaging presentation and reporting techniques

Develop and deliver regular performance reporting, including interpretation of results, to supportbusiness decision-making, and marketing and product development /
  • Work across Public Engagement and at senior levels to gather and document performance reporting requirements, ensuring business objectives are clear and agreed with stakeholders
  • Evaluate business requirements against data possibilities to identify the most meaningful metrics/data sources to build reports around; recommending adaptation or cleansing of data as necessary
  • Specify report briefs and work closely with the Management Information Systems team to develop, test and approve new reports
  • Present reports, and train colleagues to use and interpret them accurately, providing on-going support to Public Engagement for report queries
  • Run reports at agreed times, and work closely with the Business & Marketing Analysis Manager to identify and track trends in performance data to support business decision-making and strategy
  • Provide verbal and written narrative to accompany reports, and the trends tracked through them,translating results and inferences into simple and compelling stories that stakeholders can digest and apply to their own areas of work

Provide insight into existing audiences and developa segmentation strategy to grow engagement and income /
  • Gather a detailed understanding of and document Plan UK’s existing audiences, product portfolio, touch points and communication plans
  • Work with the Marketing and Business Analyst Manager and theAudience Strategy & Innovation Executiveto identify and define distinct supporter groups/segments
  • Lead development of an internal audience segmentation based on demographic, behavioural, attitudinal and lifetime value data
  • Work with the Head of Business Improvement & Innovation and other Heads of Units within Public Engagement to develop an audience-led growth strategy
  • Ensure data protocols and business processes are in place to ensure the successful on-going tracking of segment performance
  • Analyse and report on segment performance at regular intervals, recommending adaptation of the segmentation model to continually drive maximum income and engagement growth

Implement and feed into a data strategy to grow analysis possibilities and business learning /
  • Assist the Marketing and Business Analyst Manager with and lead on complex CRM-adaptation projects to get the supporter database and other data sources ready for meaningful data mining and analysis
  • Conduct reviews and analysis to identify dirty data or gaps, recommending and carrying out cleansing exercises as necessary
  • Working with the Marketing and Business Analyst Manager identify , document and set up a framework for the consistent capture and ordering of supporter and marketing data, which will best serve agreed business insight objectives
  • Document business rules for data capture and provide training and on-going support to Public Engagement teams to promoteconsistent data entry
  • Work across Public Engagement to gather requirements, make recommendations, and establish an organisational-wide corporate coding structure that enableseffective tracking ofmarketing performance and ROI
  • Support the Marketing and Business Analyst manager to disseminate and embed the new corporate coding structure cross-organisationally

Provide analysis and insight support to the Public Engagement Department /
  • Work closely with and advise other units within Public Engagement so that they can continue to meet supporter needs and achieve growth through application of robust, meaningful analysis
  • Instruct and advise Public Engagement teams on how best to target audiences for campaign selection; and sign off data export and import briefs to ensure supporter opt-outs and preferences are honoured
  • Provide on-going support for Public Engagement units to meet their audience insight and performance measurement needs
  • Provide on-going support for Public Engagement units to meet their strategy, creative thinkingand campaign development needs
  • Commission, supply or manage data analysis projects to meet any of the objectives above
  • Liaise with international colleagues at Plan International Headquarters and other Plan National Offices to ensure Plan UKis aware of new data capture and reporting requirements from across the Plan Family
  • Conduct supporter analysis and benchmarking for Plan UK and the international organisation

General /
  • To be open to change and demonstrate a flexible and adaptable approach
  • To work collaboratively with other departments and be a supportive and effective team member
  • To ensure that all activities undertaken on behalf of Plan UK, externally or internally, are executed in accordance with the overall aims of the organisation and in line with Plan’s policies and procedures
  • To participate in training and other activities as requested by the organisation.

Stakeholder and Customer Service /
  • To provide quality customer service to all our respective audiences and comply with Plan UK’s quality management protocols

Awareness and Representation /
  • To promote positive and consistent messaging of Plan and to represent the organisation effectively.

Key Deliverables / Please Indicate A R or N/A
Develop and maintain performance measurement reports for the Public Engagement directorate, identifying and tracking trends to inform business decisions and strategy / Responsible
Develop and maintain audience segmentation across Plan’s supporter base, to maximise supporter engagement and income growth / Responsible
Complete analysis projects; investigating and modelling data to identify and forecast trends and propensities, highlighting opportunities for growth / Responsible
Contribute to a data capture strategy that will grow analysis possibilities and business learnings; and to promoting a culture which understands and values quality data capture to maximise learnings and performance / Responsible
Level of Child Protection Responsibility / Standard - Commitment to uphold to Child Protection guidelines at all time.
Level of BudgetaryResponsibility / Limited - Post has delegated or functional responsibility of budgetary control
Key Working Contacts /
  • Business & Marketing Analysis Manager
  • Head of Business Improvement & Innovation
  • Audience Strategy & Innovation Executive
  • Digital Innovation Executive
  • Management Information Systems team
  • Other Public Engagement units; Individual Giving, Major Partnerships, Communications, and Advocacy, Campaigns & Research

This is not intended to be an exhaustive list. Your job description may be subject to change.

Date Created / March 2014
PLAN UK PERSON SPECIFICATION
Job Title /

Senior Data Analyst

Department / Public Engagement
Unit (if appropriate) / Business Improvement and Innovation
PERSONAL COMPETENCIES
Competency Title / The successful candidate will be able to….

Communicating with all stakeholders

/
  • Bring clarity and simplicity to complex issues and datasets
  • Turn data and recommendations into engaging stories
  • Produce tools and materials to help other teams apply analytical learnings and insight
  • Inspire colleagues to take action to improve performance
  • Inspire colleagues to collaborate

Working effectively and efficiently

/
  • Work calmly under pressure
  • Manage multiple projects simultaneously
  • Maintain consistent high standards of work
  • Motivate self and seek personal feedback
  • Apply good time management
  • Meet deadlines and deliver on KPIs

Demonstrating Plan values

/
  • Stimulates an analytical and insight-led approach to existing and new methods of working
  • Contributes to the development of a culture which values quality data capture to maximise learnings and performance
  • Ensures that impact is a feature of their work and maintains continuous monitoring, suggesting changes where appropriate
  • Motivates others to improve and develop their performance
  • Responds positively to feedback and provides feedback in a constructive manner

RELEVANT EXPERIENCE
The successful candidate will have experience of ….
Direct marketing and statistical analysis, either in the NGO or commercial sector, agency or client side
Responsibility for analysing customer data and behaviours, marketing campaigns and product portfolios, measuring performance, reporting and making recommendations that inform business critical decisions and strategy
Mathematical modelling, statistical/quantitative analyses, predictive /propensity analytics and data investigation to drive – and application of these techniques to influence business practice and direction
Project management and delivering outcomes on time and on budget
Delivering audiencesegmentation to successfully grow engagement and income among existing customers
Identifying and leading on data strategy to ensure that opportunities for analysis and business learnings are maximised
Applying insight, trends and customer information to creative thinking, strategic problem-solving, and business development
SPECIFIC SKILLS AND KNOWLEDGE
The successful candidate will have the ability to…. / The successful candidate will have knowledge of….
Analyse complex datasets to draw inferences / Excel to an advanced standard, as well Microsoft Word, Outlook and PowerPoint
Create and interpret robust statistical models / Database structures and business intelligence tools e.g. SPSS
Assimilate and analyse information from diverse data sources / Statistical modelling techniques
Commission quantitative analysis work and sense-check methodologies / Audience segmentation techniques
Identify opportunities for growing business knowledge through analysis / Effective presentation methods
Identify ways to future-proof analysis-capabilities / Effective communication methods
Overlay qualitative research to add additional insight to analytical / statistical findings / Training others and leading workshops
Present to senior and large audiences / Direct Marketing methodologies such as A/B and variant testing
Work successfully with a wide variety of teams and personalities; and influence cultural change
Act proactively and entrepreneurially
Effective project management
Test ideas and hypotheses
Date Created / March 2014