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
1. 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
2. To ensure that all developments and changes are fully documented, auditable and change control policies are adhered to
3. 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
4. To comply to standards in respect of database administration, ETL and data modelling, incorporating full documentation to support change control mechanisms and audit requirements
5. To perform continuous reviews on best practice for data transformation, data modelling and information reporting
6. To undertake other duties as designated by the Data Solutions Architect
7. 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.
8. 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
9. SQL
10. T-SQL (or another vendor)
11. SSIS
12. Power BI
13. XML
14. JSON
15. PowerShell
16. Azure Cloud
17. Data Vault modelling
Databases
18. SQL Server (Multiple Versions)
19. 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
20. Demonstrable experience and demonstrable understanding of Relational Database Design & Managements.
21. Proven knowledge of ETL/ELT
22. Proven knowledge of Microsoft SQL Server, SSMS, SSIS and BIDS (or equivalent).
23. Strong proven SQL/T-SQL knowledge
Desirable
24. Understanding of multi-dimensional modelling
25. A good proven knowledge across a multitude of NHS datasets and the complex data schemas and the Information it pertains to.
26. Proven knowledge of Azure, Data Vault, Agile, Power BI
27. Proven knowledge of alternative data structures such as XML, JSON
28. Demonstrable experience of working with programming/scripting languages such as, PowerShell
Qualifications
Essential
29. Degree in relevant subject
30. Educated to A level, similar qualifications, or work experience, or equivalent demonstrable experience
31. Or equivalent demonstrable experience
Desirable
32. Equivalent demonstrable experience in numerate/ informatics subject
Aptitude & Abilities
Essential
33. Good investigative and problem solving skills
34. Proven mathematical reasoning skills.
35. Excellent keyboard skills.
36. Good analytical skills.
37. Business analysis skills.
38. Ability to work as part of a team.
39. Should be able to communicate between user requirements, technical requirements and constraints.
40. SQL skills ideally in SQL Server or relevant vendor.
41. Attention to detail.
Desirable
42. Good presentation skills.
43. Good telephone manner and ability to liaise with staff at all levels.
44. Good time management.
45. Good communications, both written and verbal.
Disposition/Attitude/Motivation
Essential
46. Determined and Self-motivated
47. Team worker
48. Proactive, takes own initiative
49. Analytical
50. Good operational planner
51. Results orientated
52. Ability to work well in a busy environment
53. Ability to prioritise
Desirable
54. Partake in training to improve/motivate overall technical skills and proven knowledge