Job summary
The post holder will develop data visualisation products, such as reports and dashboards, built upon Microsoft Power BI and SQL Platform, delivering outputs using data visualisation methodologies to convey key messages to the products users. The post holder will need create documentation including the completion of design templates, change control requests, testing plans and results. The post holder will also be support the administration and provide maintenance support to the associated reporting environments.
Main duties of the job
- Ensure reports and dashboards are designed to a high standard using latest data visualisation methodologies and can be used in a self-service environment.
- Provide a high level of documentation which underpins the on-going success of the Informatics Delivery service. This includes internal technical documents but also friendly business user focused documentation.
- Participate in projects which are aligned to the key organisational objectives of the Trust, providing options and recommendations to support those objectives.
- Ensure that all new developments and amendments follow the change control process. This requires rigorous testing procedures and detailed impact analysis.
- To work with clinicians and service managers to undertake analysis of business/care delivery processes, advising on how these might be changed or refined to improve their efficiency, and how such changes would be enabled by the appropriate use of information systems and communications technology.
Flexible working:
As one of the few Trusts in London we are proud to offer flexible working as part of our new ways of working, and we are happy to talk flexible working at the interview stage. In this role you will be able to work Monday to Friday in the time frames from 8am to 6pm, giving you the very best of good work life balance.
About us
About the team:
The informatics team is split into two areas, data delivery and requirements & engagement. These teams work together to deliver against our service model to the organisation.
We work in an environment of collaboration, and whilst we endeavour to deliver information in a right the first-time environment, we have also created the space for teams and individuals to test out new technologies or interest projects within ring-fenced time - often in collaboration with external consultancies who support and encourage learning within the team.
About the location:
The Digital Services Informatics team is based at Jeanette Wallace House, in between Bromley and Croydon (CR0 1FE).
Our Trust headquarters is located at Denmark Hill less than 5 minutes from the train station (zone 2). We also provide services and operate across other locations, such as London boroughs of Croydon, Lambeth, Lewisham and Southwark; and substance misuse services for residents of Bexley, Lambeth, Greenwich and Wandsworth.
Job description
Job responsibilities
- Ensure reports and dashboards are designed to a high standard using latest data visualisation methodologies and can be used in a self-service environment.
- Provide a high level of documentation which underpins the on-going success of the Informatics service. This includes internal technical documents but also friendly business user focused documentation.
- Participate in projects which are aligned to the key organisational objectives of the Trust, providing options and recommendations to support those objectives.
- Ensure that all new developments and amendments follow the change control process. This requires rigorous testing procedures and detailed impact analysis.
- To work with clinicians and service managers to undertake analysis of business/care delivery processes, advising on how these might be changed or refined to improve their efficiency, and how such changes would be enabled by the appropriate use of information systems and communications technology.
- Participate in the development of data quality monitoring tools and techniques to support the accurate reporting of all internal and external reports and lead on the development of reporting from the Trust's data warehouse.
- Presenting of highly complex information to a wide range of stakeholders. This includes dealing with complex ad hoc queries and where necessary making solutions accessible and available trust wide.
- Supporting research and development by using specialist research methods. This may include the management of discrete projects.
- The post holder will assist in the provision of customer support, interfacing and maintaining business and Supplier relationships.
- Ensure that developments / products adhere to the policies and procedures of the Informatics Department, Digital Services, and of the Trust.
Job description
Job responsibilities
- Ensure reports and dashboards are designed to a high standard using latest data visualisation methodologies and can be used in a self-service environment.
- Provide a high level of documentation which underpins the on-going success of the Informatics service. This includes internal technical documents but also friendly business user focused documentation.
- Participate in projects which are aligned to the key organisational objectives of the Trust, providing options and recommendations to support those objectives.
- Ensure that all new developments and amendments follow the change control process. This requires rigorous testing procedures and detailed impact analysis.
- To work with clinicians and service managers to undertake analysis of business/care delivery processes, advising on how these might be changed or refined to improve their efficiency, and how such changes would be enabled by the appropriate use of information systems and communications technology.
- Participate in the development of data quality monitoring tools and techniques to support the accurate reporting of all internal and external reports and lead on the development of reporting from the Trust's data warehouse.
- Presenting of highly complex information to a wide range of stakeholders. This includes dealing with complex ad hoc queries and where necessary making solutions accessible and available trust wide.
- Supporting research and development by using specialist research methods. This may include the management of discrete projects.
- The post holder will assist in the provision of customer support, interfacing and maintaining business and Supplier relationships.
- Ensure that developments / products adhere to the policies and procedures of the Informatics Department, Digital Services, and of the Trust.
Person Specification
Qualifications
Essential
- Educated to Degree level or equivalent experience in business intelligence/ designing dashboards
Desirable
- Postgraduate/ professional qualification in research/ advanced statistics
- Prince2, Agile or other Project Management qualification
Experience
Essential
- Substantial experience in using Microsoft SQL Server and corporate reporting tools
- Experience of documenting data management solutions including architectural diagrams, dashboards, extracts, and reports
- Experience of requirements/ business analysis techniques and change control
Desirable
- Understanding of ITIL good practice in a work environment
- Experience of developing complex data transformation using specialist integration tools such as SQL Server Integration Services (SSIS)
Knowledge and skills
Essential
- Developing reporting solutions to meet the business needs of the organisation including clinical data quality, performance management and reporting issues
- Ability work on own initiative, prioritising your own work to meet deadlines, and working under pressure
- A flexible and innovative approach to problem solving
Desirable
- Knowledge of mental health services or NHS data models
- Knowledge of using corporate reporting tools and abstraction layers such as SAP Business Objects, Microsoft SSAS/SSRS, and Qlikview
- Ability to use data modelling tools to develop data warehouse structures
- Statistical concepts and research methods skills
Person Specification
Qualifications
Essential
- Educated to Degree level or equivalent experience in business intelligence/ designing dashboards
Desirable
- Postgraduate/ professional qualification in research/ advanced statistics
- Prince2, Agile or other Project Management qualification
Experience
Essential
- Substantial experience in using Microsoft SQL Server and corporate reporting tools
- Experience of documenting data management solutions including architectural diagrams, dashboards, extracts, and reports
- Experience of requirements/ business analysis techniques and change control
Desirable
- Understanding of ITIL good practice in a work environment
- Experience of developing complex data transformation using specialist integration tools such as SQL Server Integration Services (SSIS)
Knowledge and skills
Essential
- Developing reporting solutions to meet the business needs of the organisation including clinical data quality, performance management and reporting issues
- Ability work on own initiative, prioritising your own work to meet deadlines, and working under pressure
- A flexible and innovative approach to problem solving
Desirable
- Knowledge of mental health services or NHS data models
- Knowledge of using corporate reporting tools and abstraction layers such as SAP Business Objects, Microsoft SSAS/SSRS, and Qlikview
- Ability to use data modelling tools to develop data warehouse structures
- Statistical concepts and research methods skills
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).
