Analyst and Database Manager

at  Overcoming Multiple Sclerosis

Job description

JOB DESCRIPTION

This is an exciting opportunity to be at the heart of the Charity operations. This role will help to continue to transform the way the Charity uses data to make decisions. As data is at the heart of our organisational strategy for our next phase, you will play a big role in making an impact through this role. You will ensure the correct systems, processes and training are in place for gathering, storing, processing, analysing and reporting on data.

• Primarily the postholder will be responsible for: the delivery of dashboards, KPI reports, analysis and insights to the organisation to drive organisational strategic decisions.
• The effective and smooth management and upkeep of our database (MS Dynamics) as well as the organisation’s use of our database ensuring data is accurate and able to be used efficiently by the organisation.

The role involves understanding different systems and processes, and working with data challenges. You must be able to keep the end user in mind in your decisions, as the community is at the heart of all we do.

IN YOUR COVERING LETTER, PLEASE LET US KNOW:

• Your motivation for applying for the role
• Your notice period
• Your current location.

MAIN DUTIES AND RESPONSIBILITIES

• Analysis and reporting
  o Lead on the delivery of dashboards, KPI reports, analysis and insights to the organisation to drive organisational decisions and demonstrate our impact.
  o Identify trends within our database to inform our activities to drive engagement of our community and the loyalty and retention of our supporters.
  o Run regular reports to communicate our database reach and scope, including using Power BI for data visualisation.

o Build and run regular activity reports, post-campaign reports and in-depth analytical reports to provide data-driven insight into supporter behaviour, using CRM, Excel and other relevant tools.

• Campaign management and data selection support

o Support fundraising team and community engagement teams with their data selections for email, mail shots, webinars, survey distribution and any other communication to members or supporters. Work with colleagues to understand their data needs, then schedule and project manage all data selections and segmentation.

o Work to ensure smooth data management from start to finish of campaigns.

• Data and database lead

o Lead on all data activity for the Charity, being responsible for the integrity of our data and adherence to protocols.
o Identify developments needed to the MS Dynamics database system to help the organisation achieve its goals.
o Ensure our database serves as a single customer view by connecting data through automations (supporting our external database provider).
o Build supportive relationships with colleagues to ensure their data needs are fully understood and met, including ensuring the right data is available for email selections (Dot Digital).
o Provide training and support to staff so they are able to confidently use the database as relevant to their roles.
o Creating and/or improving data-related policies and processes.

o Assist in the diagnosis of data and database problems and research solutions.

• Compliant use of data

o Ensure data processes are within relevant legislation, including GDPR and other data protection legislation.

• Data integrity and quality

o Advise and accurately maintain all data protocols and ensure that all data activity is promptly scheduled and actioned.
o Ensure regular ‘house-keeping’ functions to ensure that standard data is maintained at a high level.

o Ensure individual entries and bulk uploads and imports from website and Excel spreadsheets are performed accurately and on time.

• Supplier management

o Work with 3rd party suppliers to help scope and deliver database changes and perform UAT.

• Customer support processes

o Work with colleagues to ensure all supporter enquiries and interactions are dealt with promptly and efficiently – such as FAQ’s, responses etc.

• Line management

o Management of the Digital and Database Administrator, ensuring they are able to perform their role effectively.

This is an exciting opportunity to be at the heart of the Charity operations. This role will help to continue to transform the way the Charity uses data to make decisions. As data is at the heart of our organisational strategy for our next phase, you will play a big role in making an impact through this role. You will ensure the correct systems, processes and training are in place for gathering, storing, processing, analysing and reporting on data.

• Primarily the postholder will be responsible for: the delivery of dashboards, KPI reports, analysis and insights to the organisation to drive organisational strategic decisions.
• The effective and smooth management and upkeep of our database (MS Dynamics) as well as the organisation’s use of our database ensuring data is accurate and able to be used efficiently by the organisation