Job summary
- Main area
- Operational Management
- Grade
- NHS AfC: Band 5
- Contract
- Permanent
- Hours
- Full time
- Flexible working
- Home or remote working
- Job ref
- 216-AM-A6764516
- Employer
- University Hospitals Plymouth NHS Trust
- Employer type
- NHS
- Site
- Agile Working/Brittany House
- Town
- Plymouth
- Salary
- £29,970 - £36,483 £29,970 - £36,483 Per Annum
- Salary period
- Yearly
- Closing
- 28/11/2024 23:59
Employer heading
Data Solutions Developer
NHS AfC: Band 5
Job overview
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.
Working for our organisation
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.
Detailed job description and main 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 Trust’s 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 Features
This 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, NHS
guidelines and EC directives in maintaining use of confidential and personal information involving
patient data. To always ensure Information security.
Please see attached JD for further details.
Person specification
Knowledge & Experience
Essential criteria
- 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 criteria
- 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 criteria
- Degree in relevant subject
- Educated to A level, similar qualifications, or work experience, or equivalent demonstrable experience
- Or equivalent demonstrable experience
Desirable criteria
- Equivalent demonstrable experience in numerate/ informatics subject
Aptitude & Abilities
Essential criteria
- 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 criteria
- 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 criteria
- 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 criteria
- Partake in training to improve/motivate overall technical skills and proven knowledge
Employer certification / accreditation badges
Applicant requirements
This post will require a submission for Disclosure to be made to check for any unspent criminal convictions.
Documents to download
Further details / informal visits contact
- Name
- Nathan Roberts
- Job title
- Data Solutions Architect
- Email address
- [email protected]
- Telephone number
- 01752 432100
List jobs with University Hospitals Plymouth NHS Trust in Administrative Services or all sectors