Job summary
It's an exciting time to join the Digital Team. We have refreshed our Digital Strategy and increasing our Digital capability to provide better care for our service users and staff.
We are looking to appoint a Senior Data Analyst within the Informatics Service. This post based in the substance misuse team will provide technical data extraction and analysis skills to support the extract and transfer of data from electronic care records.
The successful candidate will bring experience and technical skills in data extraction techniques and SQL Server. The successful candidate will work with Substance Misuse Service and Digital teams to design and deliver data extraction techniques as to service specifications.
This post will report to the Informatics and Substance Misuse service and there will be opportunities to work on tasks across both services. Initially this post is offered on a 12-month fixed term contract basis to support some high priority work.
Main duties of the job
As a candidate for this role, you will be experienced in data extraction, know your way around SQL server and be confident with identifying where source data is stored in databases.
You'll need to be able to demonstrate.
- Strong technical skills including knowledge and experience of using tools in:
- The Microsoft SQL server such as SSIS, SSRS, SSAS, T-SQL.
- ETL Data skills (Extract Transform and load).
- Ability to quality assure and validate work.
You'll be confident in articulating and documenting the methods in how you have extracted data and provide assurance to colleagues that the information you have extracted is correct to support patient care.
About us
We are passionate about providing the very best care to the people we support, and we're looking for amazing people who share this passion to join us.
What is it that makes our Trust such a special place to work? Well, it's all about the people. Our staff, service users, carers and families all come from such diverse backgrounds and all have expertise and stories to share.
It's important that you feel supported in your role, that the people who you work with are as passionate as you are and that your health and wellbeing is taken care of
If you're interested in developing your career, you'll have access to a range of training and education opportunities, including apprenticeships, work experience and placements, as well as the chance to get involved in research.
We are all very proud of the difference we make to people's lives each and every day and if that's something that you'd like to be part of we'd love to have you with us.
Job description
Job responsibilities
The Senior Information Analyst based within the Substance Misuse (SM) service will lead on a data migration and data analysis projects. The post holder will design and extract data from clinical systems to supply data insights and opportunities to consume data for service-based projects. This post will lead on dataset extraction from Substance Misuse and Criminal Justice Datasets.
This post will initially report into the Business and Performance Manager within the Substance Misuse and but will have a very close working relationship with the Head of Informatics and key stakeholders in the Digital, Substance Misuse and with key software suppliers.
Job description
Job responsibilities
The Senior Information Analyst based within the Substance Misuse (SM) service will lead on a data migration and data analysis projects. The post holder will design and extract data from clinical systems to supply data insights and opportunities to consume data for service-based projects. This post will lead on dataset extraction from Substance Misuse and Criminal Justice Datasets.
This post will initially report into the Business and Performance Manager within the Substance Misuse and but will have a very close working relationship with the Head of Informatics and key stakeholders in the Digital, Substance Misuse and with key software suppliers.
Person Specification
Knowledge
Essential
- oAdvanced knowledge of Microsoft SSIS and MS SQL Server database Technologies - SQL Server 2012 and above.
- oExcellent verbal and written communication skills with the ability to write concise, accurate & readable documentation and reports oAble to demonstrate skills and pass on knowledge and experience to others.
- oAble to deal with colleagues and services in difficult situations. oAble to deal with sensitive or confidential information appropriately at all times.
Desirable
- oComprehensive knowledge of data validation and quality assurance systems
- oComprehensive knowledge of NHS data definitions and information standards
- oSubstance Misuse Knowledge
Training & Qualifications
Essential
- oDegree in computer related subject or equivalent professional qualification or experience.
Desirable
- oCertificate in database administration / data modelling.
Experience
Essential
- oAppropriate demonstrable experience in relational database management systems (RDBMS), building and maintaining database for service delivery. oExperience of extracting information using TSQL
Desirable
- oKnowledge & experience of NHS Datasets
- oExperience of manipulating and presenting data using Qlikview, Power BI, SSRS, Crystal Reports or similar packages
- oNHS information flows, hospital systems and applications.
Person Specification
Knowledge
Essential
- oAdvanced knowledge of Microsoft SSIS and MS SQL Server database Technologies - SQL Server 2012 and above.
- oExcellent verbal and written communication skills with the ability to write concise, accurate & readable documentation and reports oAble to demonstrate skills and pass on knowledge and experience to others.
- oAble to deal with colleagues and services in difficult situations. oAble to deal with sensitive or confidential information appropriately at all times.
Desirable
- oComprehensive knowledge of data validation and quality assurance systems
- oComprehensive knowledge of NHS data definitions and information standards
- oSubstance Misuse Knowledge
Training & Qualifications
Essential
- oDegree in computer related subject or equivalent professional qualification or experience.
Desirable
- oCertificate in database administration / data modelling.
Experience
Essential
- oAppropriate demonstrable experience in relational database management systems (RDBMS), building and maintaining database for service delivery. oExperience of extracting information using TSQL
Desirable
- oKnowledge & experience of NHS Datasets
- oExperience of manipulating and presenting data using Qlikview, Power BI, SSRS, Crystal Reports or similar packages
- oNHS information flows, hospital systems and applications.
Disclosure and Barring Service Check
This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).
Additional information
Disclosure and Barring Service Check
This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).
