Data Solutions Developer

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 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 , 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