Data and Performance Analyst

at  Maggies

DESCRIPTION

As the Data and Performance Analyst you will lead the analysis, interpretation and visualisation of Maggie’s activity and visitor data.
Working closely with the Director of Performance, you will build data dashboards and carry out data analysis to help Maggie’s understand organisational performance and, crucially, interpret areas for growth and improvement.
Communicating with key teams across the organisation, you will define the requirements for data analysis projects, and you will extract, clean and engineer data ready for analysis, conduct appropriate analysis and then be able to report back.
You will present data and insight in reports, dashboards, presentations and papers and will be key to turning data into decision-making and action. You will be integral to developing the data culture at Maggie’s through the creation of quarterly and annual data reports. Working closely with the Quality and Evidence Researcher, you will also support Fundraising teams to bring data to life for funding proposals.
In collaboration with the Database and Business Intelligence team, you will be one of the chief drivers of data quality, supporting the implementation of the organisation’s data strategy. You will develop a strong understanding of Maggie’s strategy, operating model and objectives, especially in relation to Maggie’s visitors and our cancer support, and, working with the Director of Performance, you will help analyse data to drive decision making, performance and organisational growth.

SKILLS, KNOWLEDGE AND EXPERTISE

• Degree educated (or equivalent experience) in a relevant field
• Extensive experience in quantitative data analytics with an ability to manipulate and interpret data utililising a breadth of analytical techniques, including statistical and predictive modelling, to interpret trends, patterns and outliers
• Excellent proficiency in using Power Bi for data reporting and analysis. An overall strong competency in data reporting and data visualisation through dashboard development to create interactive and insightful dashboards, in particular using Salesforce, Power Bi, Tabluea and Microsoft Excel platforms
• Experience generating insight from data, through use of analysis, graphical visualisations, narrative and impact statements
• A strong communicator with experience communicating and presenting data and insight with Heads of Departments/Teams to inform decision-making and performance
• Ability to oversee and manage projects from start at the planning and scoping stage, to finish when sharing results
• Able to read and write SQL code for querying and manipulating data from databases, data lakes, and data warehouses.
• Understanding the ETL process of extracting data from a source system, transforming it to meet the business requirements and loading it into the data warehouse

• Lead the analysis of quantitative data [Maggie’s programme of support and visitor data]. Identify and communicate trends, patterns, outliers, contradictions and connections within data to the Director of Performance, helping to drive organisational performance and growth.
• Develop data reports and dashboards on Power Bi, Microsoft Excel and Salesforce, as well as any future systems, utilising data cleaning and validation processes, to build accurate, reliable and sustainable reports.
• Develop Maggie’s performance dashboards and working with the Director of Performance, analyse and monitor performance data to develop key performance metrics, performance frameworks and the forecasting of growth and risk.
• Generate insightful data-driven presentations for use across the organisation to ensure data supports decision-making and drives improvements both within centres and organisationally.
• Support the Fundraising, Communications and Marketing, and PR and Public Affairs teams to use organisational data in an impactful manner in funding proposals, PR campaigns and external facing communications.
• Collaborate with cross-functional teams to analyse business requirements and prepare detailed specifications for the integration of these systems with existing databases and the data warehouse.
• Work with the Quality and Evidence Researcher, Fundraising Insights, and Brand, Marketing and Communications Insights, on collaborative research and analysis to support wider organisational projects.
• Lead on the reporting and collation of data for Maggie’s Impact Reports
• Work with the Database Business Intelligence team to ensure data governance and quality is a key pillar throughout all data projects, systems and processes
• Working with the Head of Operations, ensure data confidentiality and security is present throughout processes