CE01

Role Description

Role Title: / Database Analyst / Department: / Support Services
Reports To: / Head of Support Services / Last Updated: / January 2016

Role Purpose

To provide support to the Head of Support Services by being responsible for the administration, monitoring, maintenance and development of the case management systems which are used across Cambridge Enterprise business units and related reporting and data analysis functions for business intelligence.

The role includes:

·  the development and design of case management systems maintenance and development strategies, including data integrity monitoring;

·  being responsible for extracting data, creating and producing dashboards, preparing regular and ad-hoc reports (including SQL query writing) and analysis;

·  using Excel, VBA, Macros, pivot tables

·  planning for future development of the systems;

·  coordination and control of the user access, permissions and privileges;

·  writing or updating the case management system documentation, including data quality standards and user manual;

·  training new and existing users on the case management system as well as any new features;

·  monitoring bug reports and responses, liaising with our case management system provider;

·  interfacing with case management system provider and CE’s IT team to solve system problems and to further develop the existing or new functionalities and/or new applications;

The main case management system currently used at Cambridge Enterprise is Sophia from Wellpsring Worldwide Inc.

Main Responsibilities

Key duties and responsibilities / Estimated % time spent / frequency
1.  / Case management systems administration
·  Coordinating administration of case management systems users accounts and permissions
·  Provide users with training inductions, follow-up and ad-hoc training sessions
·  First point of call for internal users queries and troubleshooting relating to the case management systems and escalate to the system provider when appropriate
·  Manage database bugs and submitted fault reports to their resolution
·  Undertake data quality and integrity control and follow-up
·  Coordinating the on-going development and evolution of the case management systems. / 50%
2.  / Data extraction, reporting and analysis
·  Prepare dashboards and reports recurrently or on demand for internal purposes, for University Departments or Schools and externally for University research sponsors, external partners or government bodies.
·  ad hoc query production and development of new reports and data analysis upon request
·  Data analysis will include defining data requirements, data extraction (including SQL query writing) and processing, data checking and cleaning (if necessary), data analysis, communication using tables, graphs, time series etc. as appropriate, receiving feedback which may result in additional analysis. This process may need to be repeated iteratively. / 45%
3.  6 / Other duties
·  Other duties appropriate to the level of the post as may be reasonably requested / 5%

Person Specification

Competencies / Essential / Desirable
1. Ambition/ Effectiveness / Achieve targets/deadlines with high quality completed work and projects, whilst looking for ways to implement continuous improvements
Use initiative to resolve problems and queries
2.  Customer Focus / Responds to requests from CE Staff about the case management system or requests for data or information from CE or University colleagues, in an efficient and customer orientated manner.
Gives feedback to Head of Support Services on the information service supplied and develops improvements to service in relation to internal and external feedback.
3. Team Working/ Flexibility / Ability to work effectively with colleagues within Business Support and IT; and other Cambridge Enterprise Business Units, but also within the University or externally and with our case management system supplier support team, to achieve the desired successful outcome.
4. Planning and Organising / Able to plan and manage own workload to achieve deadlines with a minimum supervision.
Good project management skills
Ability to deliver outputs consistent with expected standards in terms of productivity and quality.
5. Problem Solving / Ability to use initiative and take proactive approach to solving problems.
Dealing with problems arising with data management system, and informing and or discussing the suggested best way forward with Head of Support Services as and when appropriate.
6. Motivation / Demonstrated by your enthusiasm and interest in understanding and supporting through your own skills, the commercialisation of University expertise and ideas, supporting the academic innovation to create products, services and advice that benefit the University, the UK and society on a global scale.
Essential / Desirable
7.  Knowledge, Skills and Experience / Knowledge and understanding and experience of database systems and business intelligence or data analysis.
Knowledge of structured query language (SQL).
Computer literate with experience of Microsoft Office suite including some advanced Excel skills (formulas, VBA, macros and pivot tables).
Basic knowledge of Access database system.
Conscientious, diligent with high level of accuracy and attention to details.
Excellent organisational and time management aptitudes.
Ability to work effectively as a member of a team with excellent interpersonal and communication skills both verbally and in writing.
Understanding of a “customer service” focused organisation and the support function.
Problem solving and good analytical skills with data mining and report building experience.
Degree level standard of education or proven experience in database administration and business intelligence or data analysis. / Knowledge and understanding of the data protection issues.

Page 1 of 4