Job summary
An exciting opportunity has arisen to join the Performance Information Team who are seeking to appoint a Data Solutions Developer to support the Data Solutions Team in the development and maintenance of data warehousing and BI solutions on behalf of the Trust.
The successful candidate will have access to the NHS apprenticeship scheme with opportunity to study further academic qualifications.
***Preference will be given to internal Trust staff, as well as 'Priority' and 'At Risk' status including NHS At Risk staff throughout Devon who are able to display recent relevant experience as dictated by the Person Specification.***
Main duties of the job
This post will provide support for Business As Usual (BAU), including daily process checks and the timely delivery of regular submission/reporting requirements. In doing so, the post holder will develop a robust knowledge of NHS and Trust datasets, and the wider Data Warehouse.
The role will offer the candidate the opportunity to familiarise themselves with a range of health systems and datasets, working closely with Information Analysts to support clinical staff and inform operational processes.
They will also be part of a team that transforms the existing data warehouse as the organisation seeks to increase data maturity on its journey moving to cloud hosting as part of a three-year digital data strategy.
About us
We are a people business - where every member of staff matters and can make a difference. Patients are at the heart of everything we do. Joining University Hospitals Plymouth NHS Trust means becoming part of a team of dedicated staff, who are committed to leading the way through innovation, clinical excellence and great customer care. The Trust has great opportunities for career development in a highly progressive working environment. We offer all of this in a vibrant, modern city with a historic reputation for adventure. PLEASE NOTE THAT ALL COMMUNICATION WILL BE ELECTRONIC, PLEASE CHECK YOUR EMAIL ACCOUNT REGULARLY. If you have any issues with applying online and need additional support including reasonable adjustments with the application process please contact the recruitment team on 01752 432100. We recognise that work life balance is important for our colleagues and so we invite requests from applicants around less than full time/flexible working for our advertised roles. Please contact the recruiting manager to discuss this prior to your application submission. We commit to giving this full consideration in each case. We encourage people from diverse backgrounds to apply for our roles, as diversity strengthens our teams. It is sometimes necessary to close vacancies before the closing date. If you have not heard from us within 4 weeks of the closing date, please assume that you have not been shortlisted.
Job description
Job responsibilities
Technical skills include SQL (and other data manipulation languages), ETL tools, understanding RDBMS, Excel and BI Reporting tools such as SSRS and Power BI.
Data Warehousing / Data & Server Management
- Participate in the development of data marts, data extracts and ETL/ELT processes in support of the Trusts federated Corporate Data Warehouse and the provision of a Single Source of Fact
- To ensure that all developments and changes are fully documented, auditable and change control policies are adhered to
- To liaise with external agencies, clinical users, & trust staff as required to support the development of the service to meet the needs of its users
- To comply to standards in respect of database administration, ETL and data modelling, incorporating full documentation to support change control mechanisms and audit requirements
- To perform continuous reviews on best practice for data transformation, data modelling and information reporting
- To undertake other duties as designated by the Data Solutions Architect
- To assist on the design, development & maintenance of the Corporate Data Warehouse which acts as the single platform for reporting utilising the most appropriate technologies.
- To work as part of the team developing and deploying a cloud data warehouse solution
Special FeaturesThis role has a frequent requirement for intense concentration whilst developing & analysing complex database solutions.
The job is specialised in terms of the technical capabilities of the post holder and the ability to develop skills and experience in the following would be considered core requisites to undertake the role:
Programming Languages, Systems, Methodologies
- SQL
- T-SQL (or another vendor)
- SSIS
- Power BI
- VB.Net
- XML
- JSON
- PowerShell
- Azure Cloud
- Data Vault modelling
Databases
- SQL Server (Multiple Versions)
- RDBMS
To maintain data security and duty of confidence which meets the data protection act 1998, NHSguidelines and EC directives in maintaining use of confidential and personal information involvingpatient data. To always ensure Information security.
Please see attached JD for further details.
Job description
Job responsibilities
Technical skills include SQL (and other data manipulation languages), ETL tools, understanding RDBMS, Excel and BI Reporting tools such as SSRS and Power BI.
Data Warehousing / Data & Server Management
- Participate in the development of data marts, data extracts and ETL/ELT processes in support of the Trusts federated Corporate Data Warehouse and the provision of a Single Source of Fact
- To ensure that all developments and changes are fully documented, auditable and change control policies are adhered to
- To liaise with external agencies, clinical users, & trust staff as required to support the development of the service to meet the needs of its users
- To comply to standards in respect of database administration, ETL and data modelling, incorporating full documentation to support change control mechanisms and audit requirements
- To perform continuous reviews on best practice for data transformation, data modelling and information reporting
- To undertake other duties as designated by the Data Solutions Architect
- To assist on the design, development & maintenance of the Corporate Data Warehouse which acts as the single platform for reporting utilising the most appropriate technologies.
- To work as part of the team developing and deploying a cloud data warehouse solution
Special FeaturesThis role has a frequent requirement for intense concentration whilst developing & analysing complex database solutions.
The job is specialised in terms of the technical capabilities of the post holder and the ability to develop skills and experience in the following would be considered core requisites to undertake the role:
Programming Languages, Systems, Methodologies
- SQL
- T-SQL (or another vendor)
- SSIS
- Power BI
- VB.Net
- XML
- JSON
- PowerShell
- Azure Cloud
- Data Vault modelling
Databases
- SQL Server (Multiple Versions)
- RDBMS
To maintain data security and duty of confidence which meets the data protection act 1998, NHSguidelines and EC directives in maintaining use of confidential and personal information involvingpatient data. To always ensure Information security.
Please see attached JD for further details.
Person Specification
Knowledge & Experience
Essential
- Demonstrable experience and demonstrable understanding of Relational Database Design & Managements.
- Proven knowledge of ETL/ELT
- Proven knowledge of Microsoft SQL Server, SSMS, SSIS and BIDS (or equivalent).
- Strong proven SQL/T-SQL knowledge
Desirable
- Understanding of multi-dimensional modelling
- A good proven knowledge across a multitude of NHS datasets and the complex data schemas and the Information it pertains to.
- Proven knowledge of Azure, Data Vault, Agile, Power BI
- Proven knowledge of alternative data structures such as XML, JSON
- Demonstrable experience of working with programming/scripting languages such as VB.Net, PowerShell
Qualifications
Essential
- Degree in relevant subject
- Educated to A level, similar qualifications, or work experience, or equivalent demonstrable experience
- Or equivalent demonstrable experience
Desirable
- Equivalent demonstrable experience in numerate/ informatics subject
Aptitude & Abilities
Essential
- Good investigative and problem solving skills
- Proven mathematical reasoning skills.
- Excellent keyboard skills.
- Good analytical skills.
- Business analysis skills.
- Ability to work as part of a team.
- Should be able to communicate between user requirements, technical requirements and constraints.
- SQL skills ideally in SQL Server or relevant vendor.
- Attention to detail.
Desirable
- Good presentation skills.
- Good telephone manner and ability to liaise with staff at all levels.
- Good time management.
- Good communications, both written and verbal.
Disposition/Attitude/Motivation
Essential
- Determined and Self-motivated
- Team worker
- Proactive, takes own initiative
- Analytical
- Good operational planner
- Results orientated
- Ability to work well in a busy environment
- Ability to prioritise
Desirable
- Partake in training to improve/motivate overall technical skills and proven knowledge
Person Specification
Knowledge & Experience
Essential
- Demonstrable experience and demonstrable understanding of Relational Database Design & Managements.
- Proven knowledge of ETL/ELT
- Proven knowledge of Microsoft SQL Server, SSMS, SSIS and BIDS (or equivalent).
- Strong proven SQL/T-SQL knowledge
Desirable
- Understanding of multi-dimensional modelling
- A good proven knowledge across a multitude of NHS datasets and the complex data schemas and the Information it pertains to.
- Proven knowledge of Azure, Data Vault, Agile, Power BI
- Proven knowledge of alternative data structures such as XML, JSON
- Demonstrable experience of working with programming/scripting languages such as VB.Net, PowerShell
Qualifications
Essential
- Degree in relevant subject
- Educated to A level, similar qualifications, or work experience, or equivalent demonstrable experience
- Or equivalent demonstrable experience
Desirable
- Equivalent demonstrable experience in numerate/ informatics subject
Aptitude & Abilities
Essential
- Good investigative and problem solving skills
- Proven mathematical reasoning skills.
- Excellent keyboard skills.
- Good analytical skills.
- Business analysis skills.
- Ability to work as part of a team.
- Should be able to communicate between user requirements, technical requirements and constraints.
- SQL skills ideally in SQL Server or relevant vendor.
- Attention to detail.
Desirable
- Good presentation skills.
- Good telephone manner and ability to liaise with staff at all levels.
- Good time management.
- Good communications, both written and verbal.
Disposition/Attitude/Motivation
Essential
- Determined and Self-motivated
- Team worker
- Proactive, takes own initiative
- Analytical
- Good operational planner
- Results orientated
- Ability to work well in a busy environment
- Ability to prioritise
Desirable
- Partake in training to improve/motivate overall technical skills and proven knowledge
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).
