Data and Insight Analyst

Role Title: Data and Insight Analyst

Job/Role Purpose: To ensure VSO is able to generate increased income from public fundraising by ensuring we have the capability to generate actionable insights from supporter communication.

Task Responsibilities

1. Develop and deliver dashboards using PowerBI to visualize business performance, including attrition, communications and supporter journey evaluations, trend reporting and supporter profile reports.
2. Design and automate enhancements to existing dashboards.
3. Aid in the design of segmentations, propensity models, Lifetime value calculations, the measurement of supporter engagement and similar, undertaking statistical analysis as appropriate and developing automated implementations.
4. Produce time critical operational sales and attrition reports for Public Fundraising.
5. Proactively communicate and share insights with internal and external stakeholders to ensure key findings are understood, meaningful and valued.
6. Promote the use of analysis in aiding decision making.
7. Develop and implement robust procedures and documentation that ensure business continuity.
8. Support the Database Manager, and the team more widely, to ensure that our data architecture is fit for purpose in delivering robust insight.and in improving data quality.
9. Effectively lead, motivate and train other members of the Data & Insight team (and other stakeholders) in building reporting and analysis skills.

Competence required

Essential:

1. Experience of developing PowerBI reports from scratch.
2. Substantial knowledge of database/ CRM / CDB systems such as Raiser’s Edge, Apteco Marketing Suite and Salesforce.
3. Excellent written and spoken communication skills, including the ability to communicate complex analysis to non-technical colleagues.
4. Experience of using reporting and analysis to influence senior fundraising colleagues and improve strategy.
5. Knowledge of Python or SQL for data manipulation, reporting and analysis.
6. Strong statistical and analytical skills.

Desirable:

1. Experience of propensity modelling, use of SAS / SPSS software.
2. Project Management skills.
3. Knowledge of the principles of database marketing