Objective of the role:
Working in support of the Senior Data Manager, and in collaboration with the Data team and other colleagues drawn from across the organisation, the Data Analyst is a critical new role designed to help underscore and complement the organisation's overall data-led approach.
The Data Analyst is responsible for all reporting and analysis principally in support of our Engagement & Communications department, which is tasked with the delivery of our fundraising, campaigns, and audience engagement activity. You will also work to support the ad hoc reporting and analysis needs of other teams across the organisation, including the Sustainable Business Support department.
At the operational BAU level, the Data Analyst will generate a mix of standard reporting, such as one-off fundraising appeal analysis, as well as the building and interrogating of the organisation's dashboards using Power BI to produce insights for a variety of internal audiences at different levels of the business.
Key responsibilities:
In conjunction with colleagues across the Data team, you will work to support the Senior Data Manager develop, deliver, and maintain the organisation's data strategy.
In support of the Senior Data Manager, you will build and implement a programme of standard reports and analysis for a variety of stakeholders, whilst championing data across the organisation in support of the wider data strategy.
Carry out scheduled and periodic reporting, in addition to ad hoc requests, as required.
Maintain and extend the existing suite of Power BI dashboards and provide support to the wider Data team in helping administer the Power BI function at the organisation.
Work with the Data team to begin migration of Salesforce-based reports to standard SQL using our bespoke data warehouse.
Meet regularly with stakeholders across the organisation to capture any reporting and analysis requirements, to help the organisation understand the power of data, e.g. using expertise to advise on statistically robust testing methods.
Go beyond the stated requirements from stakeholders and provide evidence-based insight to teams by interrogating data further, therefore being able to challenge assumptions in a supportive and collaborative manner.
Ensure that all data reporting and analysis activity is securely managed in accordance with the organisation's data protection obligations under GDPR and the Data Protection Act.
At the request of the Senior Data Manager or senior management, support the work of the organisation by undertaking any other appropriate task at this level.
Person specification:
Ability to strictly maintain agreed organisational protocols, and to use one's own initiative and common sense as required.
Ability to use initiative in solving problems.
Excellent organisational skills with the ability to prioritise workloads and meet of multiple tasks to deadline.
A positive and flexible approach to work.
Excellent interpersonal skills, including the ability to build and maintain positive and productive relationships with key stakeholders, decision makers, and colleagues.
Ability to identify user needs and to produce/communicate solutions in nontechnical language.
The ability to take instructions and to work well within a team and with colleagues in different disciplines across the organisation.
Experience:
Excellent skills in SQL.
Keen understanding of the scope and usage of supporter data in regard to security and the organisations legal requirements.
In depth knowledge of Microsoft Office, including SharePoint and OneDrive.
Proven knowledge and understanding of GDPR and the Data Protection Act, and its application in the workplace.
Education:
Educated to degree standard or qualified by relevant work experience.
Working knowledge of relational database systems such as SalesForce, Raisers Edge, Dynamics.
Previous experience of using Python.
Experience of building data models and dashboards in Power BI or similar data visualisation tool.