Key accountabilities:

• Responsible for the creation and management of systems for collating and managing data from a variety of sources, including CRM, fundraising, survey, towpath counter data and third party demographic data.
• Responsible for design and creation of appropriate data models and building of data marts within the Trust’s data warehouse, using recognized data warehouse methodology (e.g. Kimball) and incorporating testing of these models.
• Creation/building of Power BI dashboards and SQL Reporting Services (SSRS) report to allow members of the Insight & Evidence team to access accurate key results in a timely manner. This will include creation of regular reports and production of ad hoc reports.
• Developing a close working relationship with the Trust’s central IT/Business Intelligence teams to ensure data solutions are built in accordance with wider Trust standards and methods of work.
• Undertake the storage and collation of raw data from day to day activities across the Trust; projects, mystery shopping, and other tools used to measure the quality of customer/service facilities, and user/ visitor experience.
• Maintain the Central Repository of Evidence - inputting and cataloguing items received and ensuring compliance with GDPR regulation.

Knowledge, experience & skills: 

Technical: 

• Relevant working experience in data engineering - data cleansing, data pipelines, data modeling, and data integration
• Working experience in building data pipelines in production and ability to work across structured, semi-structured, and unstructured data

• Experience preparing data for analytics and following a data science workflow.

• Extensive hands-on experience of SQL and MS Power BI tools (including Tableau,TSQL, SSAS, SSRS and SSIS), Excel and VBA with programming and database administration experience being an advantage.

• Experience in formal documentation of requirements.

• Relevant professional experience and evidence of formal training, either to degree level or other recognized professional training.

• Sugar CRM experience, desirable.

General:

• Self-motivated and independent learner.

• Evidence of strong written communication skills - ability to write clear and concise communications, with high attention to detail

• Good verbal communication skills to explain complex solutions to customers in a clear and concise manner - ability to plainly communicate to all stakeholders at all levels within the organisation.