Information Analyst

Location: Exeter, EX2 5AF
Salary: £28407.00 to £34581.00
Date posted: 4th April 2024
Closing date: 21st April 2024

Our professional responsibility is to reduce the risk of infection to others as far as possible. Getting vaccinated against diseases that can be passed person-to-person in healthcare settings is part of this responsibility. The Trust will provide advice, guidance and support on vaccinations and access to vaccinations where requested.

The Data and Analytics Team

We provide dataanalysis and business intelligence reporting services to Devon Partnership Trust,responding to requests which can originate within the Trust or from externalsources. This post is based within our Central Team of analysts, working todeliver routine and ad-hoc reports by interpreting requests, analysinginformation and producing products that meet the business needs.

We are looking for a motivated and capabledata analyst with knowledge of relational databases and ideally, experience of SQL querywriting as well as advanced Excel spreadsheet design to gain experience withnew reporting technology. Proficiency in Power BI would be an advantage buttraining would be provided. Excellent communication skills are required.

Responding to requests across from across all areas of ourdiverse Trust, we are looking for someone who feels confident establishingrelationships with multiple teams to provide efficient support. While there areroutine responsibilities associated with the role, the work is varied and weencourage innovation when approaching any task. This is a fantastic opportunity to anyone wanting to develop their skills further in a busy yet supportive environment.

• Writing SQL queries with an understanding of structured data and relational databases
• Provide reports to support business needs, both routine and on an ad-hoc basis
• Provide data for national returns, for exampleNHS Benchmarking, working with others to ensure accuracy and assurance
• Document and maintain records of processes
• Communicate effectively across all levels of theorganisation and with other partners
• Utilising other appropriate software to enhancethe way we communicate our data

We provide mental health, learning disability and neurodiversity services, as well as a range of specialist & secure services for the wider south west region & nationally. We are passionate about promoting good mental health & wellbeing. We strive to use the expertise & resources within our organisation, and through our partnerships, to deliver high quality services that are safe & focused on people's recovery.

We are committed to developing a culture of coproduction, involving patients, families & carers in everything we do

Our values

We not only recruit based on qualifications & experience - we recruit individuals who possess & demonstrate the behaviours which underpin our Trusts core values. These include such attributes as showing a commitment to quality of care, improving lives of others, giving respect, dignity & compassion. We can bring those values to life in our everyday tasks by giving a smile; making time for people; challenging ourselves & others, & being open to new ideas.

We are committed to being an inclusive employer & applications are encouraged & welcomed from all sections of the community, regardless of any protected characteristics as governed by the Equality Act 2010. Part time & flexible working applications will be considered & supported, where possible. We particularly encourage applicants with lived experience of mental health conditions, neurodiversity or learning disabilities. We are a Disability Confident Leader.

• To develop, administrate the control and production process for the Trusts key performance indicators, regular reports and ad-hoc requests for information in relation to Trusts information needs.
• To work directly with clinical staff to support their understanding of information, analytics and associated performance measures.
• To support development of Business Intelligence reporting and rich data visualisation using industry standard tools.
• To work as part of a team in the Informatics team.

Duties and Responsibilities

• The main duty of this post is to coordinate the Informatics requirements of a service delivery area. This post requires excellent planning and time management skills.
• The post holder will administrate the KPI production process by creating briefs and debriefs, creating and maintaining the work schedule, and holding checkpoint meetings to monitor progress.
• The post holder will draw upon well-developed communication skills and planning skills to ensure that the allocated workload is completed and that deadlines are met to agreed quality standards.
• To manage the team mailbox responding where appropriate and ensuring that requests are logged.
• To assist provision of an information analysis service to support operational management, measure performance and to provide returns required by the Health Authority and other statutory bodies. These post requirements will aid senior managers in the planning of local services and patient care.
• Data analysis, interpretation and presentation are key elements of the role and the post holder will be required to work from a variety of information sources producing regular and ad hoc information reports. This is achieved by analysis, review and reporting of information held in systems which include the Trusts clinical systems and other internal Trust systems as well as external sources of information such as NHSI Model Hospital, NHS Benchmarking and the Mental Health Service Dataset (MHSDS).
• To provide analysis and commentary around data, highlighting insights and summarising performance to various audiences in order to support decision making and performance management of services. The post holder will work under the supervision of the Information Manager to produce information on the regular report schedule, and to respond to ad-hoc requests for information.
• The post holder will work with staff in the organisation to ensure that the data is of a consistently high standard, investigating how information is recorded to ensure accurate reporting. This will involve identifying data quality issues and providing information, guidance and support to teams to assist with the correction of errors.
• The post holder will be responsible for assimilation, validation and submission of data for central NHS organisations and other statutory bodies.
• The post holder will use their skills in SQL scripting and spreadsheets alongside their knowledge of relational databases and advanced excel skills to understand, provide, and
• receive complex information. They will be required to design new spreadsheets and to write SQL code to query the SQL server database.
• The post holder will be expected to lead on specific projects that relate to informatics, data reporting and performance frameworks.
• The post holder will work closely with the Senior Information Analysts in other departments to cross cover their work.
• The post holder will be expected to have an awareness of other reporting techniques such as R programming and will have the opportunity to develop their skills to enhance the current suite of analytics of the trust.
• The post involves communicating complex information to enable managers to comprehend it, overcoming any barriers to understanding, so that the correct conclusion can be reached. Specialist presentation techniques, such as run-charts, statistical process control charts and pivot tables, are necessary to assist the understanding of information.
• The post may involve providing briefings, both written and verbal, to staff within the Trust.
• The post holder will be expected to be familiar with the rationale and usage of Key Performance Indicators (KPI) and will use and maintain the KPI register.
• The role will involve ensuring documentation around processes is maintained and creating instructions for any new processes.
• The post holder may be required to administer routine data collections and surveys as necessary.

• Strong analytical and requirements gathering skills; Be able to interpret results from the analysis, apply the results to the given problem and suggest conclusions to be drawn
• IT skills particularly use of Microsoft Office and use of the Intranet, Internet and email
• Understanding of a wide range of data quality issues and the application of the appropriate data validation techniques
• Knowledge of NHS processes
• Understanding of Mental Health issues
• Experience of SQL query writing.
• Experience of creating Power BI dashboards.
• Experience of R or Python.

• Considerable experience working as an Information Analyst or equivalent experience in a role which is focused on data analysis and reporting
• Experience of working with analytical systems and processes
• Experience of working in the NHS or Public Sector
• Experience of identifying and managing areas where there are shared and conflicting agenda
• Ability to manage a small team and prioritise own and staffs work in line with organisational policies
• Experience of working on projects to deliver quality outcomes to deadline and identifying risks

• Good general education to GCE/GCSE level to include English Language and Mathematics
• Educated to A level or equivalent experience
• Education to degree level (preferably in an IT discipline) or equivalent experience