Job summary
Part Time Role - 25hr pw
The Information Team provides data analysis and Business Intelligence reporting services to The Trust, responding to requests which can originate within the Trust and from external sources.
The purpose of this post is to support the Business Intelligence reporting, by using Microsoft SQL server data warehouse and Tableau as the data visualisation front-end.
This is an exciting opportunity for an Information Analyst to work on various data visualisation and information automation workstreams to deliver in a fast paced, constantly changing agile environment.
You will be responsible for design, development and implementation of information measures and dashboards therefore you will need to have significant aptitude in undertaking all these activities.
Main duties of the job
Key tasks
* Your high level of computer literacy on software packages such as Microsoft Excel, data visualisation and information systems, combined with exceptional data visualisation and attention to detail will complement the skills of other team members
* Writing advanced SQL queries, functions and stored procedures with use of transactions
* Demonstrable experience in data automation and visualisation
* Proven experience of developing Dashboards that meets end-user needs
* Ability to communicate effectively and co-design information assets with users across all levels of the organisation
* Expert use of MS SQL and Tableau
The role will provide the opportunity to get involved with frontline teams and participate in the evaluation of numerous national pilots.
If you're ready for a new challenge and would like to widen your experience of health and social care we would welcome an application from you.
About us
Working as part of a great team with a committed purpose to deliver great information which directly contributions to the improvement in patient care.
Why work with us
Job description
Job responsibilities
Extract and manipulate complex and varied data from different databases, for all levels of management, with a view to assisting the organisation meet its operational requirements
Analyse and present complex information using charts, tables, graphs, maps and other statistical techniques using various software packages including SQL Server, Postgres, Tableau & Microsoft Office
Manage datasets and information resources to allow ready access by authorised personnel
Please refer to your suitability to the post in your supporting information from the role requirements or person specification.
Job description
Job responsibilities
Extract and manipulate complex and varied data from different databases, for all levels of management, with a view to assisting the organisation meet its operational requirements
Analyse and present complex information using charts, tables, graphs, maps and other statistical techniques using various software packages including SQL Server, Postgres, Tableau & Microsoft Office
Manage datasets and information resources to allow ready access by authorised personnel
Please refer to your suitability to the post in your supporting information from the role requirements or person specification.
Person Specification
Qualifications and Training
Essential
- Educated to A level standard (or equivalent qualification/experience)
- Evidence of continued professional development/education/training
- Significant data analyst experience and strong numeracy and spreadsheet skills
- Understanding of NHS or Social Care information and IT systems
- Skills in the use of Microsoft Word, Microsoft Excel and Microsoft Access to an intermediate level
- Understanding of data quality issues
- Experience of data analysis tools to create and use database queries
Desirable
- Experience of data sets and standards
- Degree in statistics or mathematics
- Database skills
- Experience of data modelling
Knowledge and Skills
Essential
- Sound knowledge of developing and using spreadsheets, including creating pivot tables, graphs and the use of formulae and macros
- Ability to analyse complex information and challenge accuracy where appropriate
- Proven experience of working alongside clinicians and senior managers
- Good network and relationship building skills
Desirable
- Ability to present information to a high standard in a written report format
- Experience of auditing own or other work areas
Special Experience
Essential
- Knowledge of Health or Social Care activity and key performance indicators
Desirable
- Experience in Microsoft SQL
- Experience in Tableau
Person Specification
Qualifications and Training
Essential
- Educated to A level standard (or equivalent qualification/experience)
- Evidence of continued professional development/education/training
- Significant data analyst experience and strong numeracy and spreadsheet skills
- Understanding of NHS or Social Care information and IT systems
- Skills in the use of Microsoft Word, Microsoft Excel and Microsoft Access to an intermediate level
- Understanding of data quality issues
- Experience of data analysis tools to create and use database queries
Desirable
- Experience of data sets and standards
- Degree in statistics or mathematics
- Database skills
- Experience of data modelling
Knowledge and Skills
Essential
- Sound knowledge of developing and using spreadsheets, including creating pivot tables, graphs and the use of formulae and macros
- Ability to analyse complex information and challenge accuracy where appropriate
- Proven experience of working alongside clinicians and senior managers
- Good network and relationship building skills
Desirable
- Ability to present information to a high standard in a written report format
- Experience of auditing own or other work areas
Special Experience
Essential
- Knowledge of Health or Social Care activity and key performance indicators
Desirable
- Experience in Microsoft SQL
- Experience in Tableau
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.
