To Lead on Maintaining and Upgrading the Database

Job Description

Job Purpose

To provide data analysis, interpretation and quality assurance for a wide range of information collected through manual and electronic data collection, utilising advanced knowledge of SSRS, Excel and other software packages as appropriate.

To contribute to the ongoing development of the client caseload information system (InSight) to ensure the system and data comply to the NCCIS data specification and meet the operational and business planning needs of Ansbury.

To lead on maintaining and upgrading the database.

To support the MI & Data Manager in the development of the overall MI & Data Team activities

To ensure accurate information is provided in a timely manner and high quality reports are produced to a cycle of deadlines, this will include a suite of SSRS reports.

Key Tasks and Responsibilities

1. To maintain an overview of current developments in the InSight database.

1. To contribute to the development and planning of the InSight database.

1. To lead with the testing and implementation of upgrades and modifications to the InSight database in accordance with NCCIS yearly requirements.

1. To ensure all data reported is accurate and validated prior to internal and external distribution. Demonstrate initiative when collecting data and following up concerns and errors associated with accuracy or completeness of data received.

1. To produce and check the monthly NCCIS data return as required by DfE.

1. To prepare narrative reports identifying exceptions in meeting agreed standards/targets. To use communication and influencing skills in working with staff to identify issues and report on action being taken to improve compliance.

1. To implement procedures to check quality and accuracy of the data held on the database and liaise with appropriate operational staff to remedy errors.

1. To continually review information requirements, adapt information production in response to changes within Ansbury Guidance, Dorset County Council and External Stakeholders.

1. To design and manage systems to maintain accuracy and robustness of data, to check data quality, provide audit trails and archive records.

1. To extract and gather information and undertake detailed analysis as requested by Ansbury Guidance, Dorset County Council and external stakeholders using in depth, statistical, analytical and judgmental skills.

1. To lead with the mass input of data supplied electronically to Ansbury including data from Local Authorities, LSC and others.

1. To assist with user support via the InSight Helpdesk.

1. To assist in the monitoring, reporting and working towards achieving national and local performance indicators.

1. To contribute to the writing and on-going development of appropriate reporting procedures to provide information for the business of Ansbury.

1. To be aware of Data Protection Legislation and potential issues of confidentiality and to ensure that this remains central to the work of the MI Team.

1. To continually adapt to new working practices, system changes and technology.

1. To operate as a member of the team in the achievement of objectives and targets.

1. To monitor own work outputs and performance against team targets set in the MI Team quarterly plans.

1. To take reasonable care for your own safety and that of others, to ensure that a safe working environment is maintained at all times, to use appropriate protective equipment when there is a requirement to do so, and to report any accidents/hazardous conditions to the Line Manager.

1. To attend employee training and development activities as directed by the Line Manager.

1. To undertake any other duties in connection with the job purpose as may be allocated by the Line Manager.

Performance Indicators

The Line Manager will set performance indicators for the postholder. The standards from which the performance indicators will be derived are:

• Achievement of set objectives.
• Compliance with quality management systems.
• Contribution to the achievement and retention of IiP status & Matrix.
• Client and customer satisfaction rates.

MI and Data Analyst

PERSON SPECIFICATION

Disposition and Motivation

Job Circumstances

Willing to undertake a criminal records bureau check for convictions and cautions (basic disclosure).



Willing and able to work flexibly across the local area as directed by the Line Manager and to meet the needs of the business



Willing and available to work outside of normal working hours as required to fulfil the duties of the post.



Hold a valid UK driving licence and have access to a car, and the ability to undertake travel as required, to carry out the duties of the post effectively

Willing to undertake training and staff development to maximise skills and experience relevant to the post

JP/AR January 2017