Data & 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.
SUPPORTING STATEMENT: As part of the shortlisting process, you need to provide a Supporting Statement with your CV. The supporting statement should highlight your experience that are relevant to this role and explain why you would make an ideal candidate.
SALARY: £33,410 - £36,009 per annum+ Excellent Benefits
LOCATION: Hybrid - Part from the office inRugby and part from home
JOB TYPE: Full-Time, Permanent
JOB OVERVIEW
We are looking for a Data & 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 focus as the Data & 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 stakeholders to understand business intelligence requirements, scope out projects and deliver reporting.
As the Data & 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.
Ideally, you 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
Data & Insight Analyst duties:
- 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 and propose changes and enhancements to such software
- Work with colleagues 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
- Conducting marketing data selections, to provide fundraising colleagues with carefully curated data which will power marketing campaigns
REQUIREMENTS
We are looking for someone 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 maximise efficiency in our fundraising programmes.
Essential
- 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
- Experience of producing reporting within Power BI
- Experience of working with The Raiser's Edge
Why join us?
The opportunity to make 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 this is a great place to work.
Our open plan offices in the centre of Rugby and near to Rugby train station.
Benefits
- Full time roles are contracted at 35 hours pw
- Hybrid/flexible working
- 27 days' holiday rising with continuous service, in addition to public holidays
- Pension scheme - employer 10.5% and employee 5%
- Enhanced family friendly policies, including maternity, adoption, paternity, and shared parental leave
- Life assurance (3 x annual salary)
- Bike to Work scheme