Data and Insight Analyst with experience of data analysis, reporting and presenting complex information and advanced MS Excel skills (pivot tables, IF and VLOOKUP), is required to join our team at Practical Action based in Rugby, Warwickshire, West Midlands.
SUPPORTING STATEMENT REQUIRED: As part of the shortlisting process, you need to provide a Supporting Statement with your CV. The supporting statement should highlight your skills and experience that are relevant to this role and explain why you would make an ideal candidate for this position.
SALARY: £33,410 - £36,009 per annum + Excellent Benefits (see below)
LOCATION: Hybrid working – part from the office in Rugby, Warwickshire, West Midlands (CV21), and part from home
JOB TYPE: Full-Time, Permanent
JOB OVERVIEW
We are looking for a Data and Insight Analyst who has a passion for working with data, and providing business intelligence that leads to action. If you love creating simple ways to explain complex data and are excited by revealing the stories hidden within the data, then this could be the role for you.
Your main focus as the Data and Insight Analyst will be to provide reporting and research for our fundraising and marketing initiatives, helping to create a clear view of our marketing directorate performance. You will work closely with colleagues and key stakeholders to understand business intelligence requirements, scope out projects and deliver reporting to agreed specifications.
As the Data and Insight Analyst you will work closely with colleagues to ensure that reporting is used and a data-driven culture established. The outputs from your work will lead to insight that supports strategy development, and future investment decisions. Some projects will focus on other areas of organisational data, such as measuring our impact, or our financial model, as required.
Ideally, the successful candidate will have proven experience in analysing data and producing reporting, ideally using some advanced techniques for data extraction and manipulation (such as SQL) and a modern data visualisation tool (such as Power BI or Tableau). Full training will be provided, to enable the postholder to develop into a fully rounded data analyst, including training in the maintenance and development of our in-house data warehouse.
DUTIES
Your duties as Data and Insight Analyst include:
-
Contribute towards the development and production of a large and complex portfolio of reports
-
Work closely with colleagues to embed reporting into day-to-day work
-
Work with the Senior Data Services Analyst, Data and Insight Manager and IT, to develop our data structures and architecture, enabling a robust data model and real-time reporting
-
Develop our use of Power BI, our data visualisation tool of choice, keeping up to date with latest reporting technologies and proposing changes and enhancements to such software where appropriate
-
Work with colleagues across the marketing directorate and wider Organisation to understand business intelligence requirements
-
Work with marketing audience strategists and the Data and Insight Manager in the commissioning and production of research, and contribute to statistical modelling projects
-
Propose and pro-actively undertaking supporter analysis with the aim of promoting efficiencies and value for money within fundraising campaigns
-
Play a key role in strategic projects, as required, acting as a subject matter expert for data, covering a range of topics, such as supporter journey mapping, process documentation / re-design, software implementation to name just a few
-
Conducting marketing data selections, to provide fundraising colleagues with carefully curated data which will power marketing campaigns
CANDIDATE REQUIREMENTS
We are looking for a pro-active self-starter, who has a passion for working with data and a hunger to learn. You will be patient and methodical in your work and be able to focus both on the technical aspects of data analysis and reporting, and also understand the strategic thinking that your work will contribute to.
You’ll be great at building relationships with stakeholders and be comfortable in communicating complex information through a variety of means.
Your work will help to ensure that we maximise efficiency in our fundraising programmes, and as such you’ll be comfortable challenging the status quo, and making suggestions for how we might change, as we look to continuously improve.
Qualifications, Knowledge and Experience
Essential
-
A self-starter, able to work on own initiative to meet goals / objectives
-
A champion for change and committed to continuous improvement
-
Experience of working with, manipulating and interpreting data
-
Experience of delivering reporting / analysis and presenting information in engaging and clear ways
-
The ability to build relationships with stakeholders and present complex information to a non-technical audience
-
Advanced use of MS Excel (pivot tables, IF and VLOOKUP)
-
Working knowledge of GDPR and data protection and fundraising regulations and compliance
Desirable
-
An understanding of data warehousing techniques
-
Expert user of MS Excel (PowerPivot / data model, VBA, statistical techniques)
-
Working knowledge of SQL (basic SELECT statements, JOINS and GROUPING data, Common Table Expressions (CTEs), Partitions, Aggregate Functions)
-
Experienced using a statistical analysis package such as SPSS and a working knowledge of statistical techniques such as CHAID and logistic regression
-
Knowledge of fundraising, and market research techniques and methodologies
-
Experience of producing reporting within Power BI
-
Experience of working with The Raiser’s Edge
Why join us?
The opportunity to work for an organisation that is making a positive difference to the lives of people worldwide, a friendly and supportive culture, and working with values-driven and highly engaged colleagues are just some of the reasons we think Practical Action is a great place to work.
Our open plan offices are located in the centre of Rugby and near to Rugby train station.
In addition, we offer the following benefits:
-
Full time roles are contracted at 35 hours per week
-
Hybrid/flexible working options
-
27 days’ holiday rising with continuous service, in addition to public holidays
-
Pension scheme - employer contributes 10.5% of salary and the employee contributes a minimum of 5%
-
Enhanced family friendly policies, including maternity, adoption, paternity, and shared parental leave
-
Life assurance (3 x annual salary)
-
Bike to Work scheme
About Practical Action
We are an international development organisation putting ingenious ideas to work so people in poverty can change their world.
We help people find solutions to overcome some of the world’s toughest problems. Challenges made worse by catastrophic climate change and persistent gender inequality. We work with communities to develop ingenious, lasting and locally owned solutions for agriculture, water and waste management, climate resilience and clean energy. And we share what works with others, so answers that start small can grow big.
We’re a global change-making group. The group consist of a UK registered charity with community projects in Africa, Asia and Latin America, an independent development publishing company, and a technical consulting service. We combine these specialisms to multiply our impact and help to share a world that works better for everyone.
NO AGENCIES PLEASE
HOW TO APPLY
To be considered for this job vacancy, please submit your CV to our Recruitment Team who will review your details.
JOB REF: AWDO-P12441
This job is being advertised by AWD online on behalf of Practical Action
AWD-IN-SPJ