Data Warehouse Developer
Job summary
Salisbury NHS Foundation Trust is excited to offer an opportunity for an ambitious individual to join our Data and Informatics team as a Data Warehouse Developer.
We are looking for a dynamic, forward thinking individual to help maintain and develop the Trust Data Warehouse and BI architecture including performance, maintainability and scalability along with a secure, governed and well architected data infrastructure.
This role will support users both within the department and to other departments around the Trust in the following key areas:
- Microsoft SQL Server (T-SQL, SSIS, SSRS, SSAS)
- Data Warehousing Architectures
- Microsoft Power BI
- PostgreSQL
To be successful in this role you will have a real eye for detail, an analytical mind-set, excellent communication skills and a willingness to adapt your approach with our stakeholders and interpret requirements with the enthusiasm to get the job done to the highest standards.
Experience of working with NHS data is highly desirable but candidates without a previous NHS background will be considered provided they can demonstrate technical proficiency in the above toolsets.
Main duties of the job
Please see attached Job description and person specification for full details of roles and responsibilities
About us
Salisbury NHS Foundation Trust (SFT) is an innovative hospital with a proud heritage and over 250 years of experience behind us. Here we're driven to deliver an outstanding experience for everyone and have been well regarded for the quality of care and treatment we continue to provide for our patients and also our staff.
We are an acute Trust, rated "Good" by the CQC, with a track record of high performance providing regional and super regional specialist services such as: Burns, Plastics & Reconstructive Surgery, Wessex Regional Genetics Laboratory, Wessex Rehabilitation, Spires Cleft Centre and the Duke of Cornwall Spinal Treatment Centre. We have about 470 beds and employ over 4000 staff.
We support flexible working and will consider requests taking into account the needs of the service. We think working here is pretty rewarding. You can access a range of NHS discounts, receive a minimum of 35 days paid holiday (pro rata), and we offer a generous pension scheme. On-site benefits include car parking (fee applies), leisure centre, day nursery and holiday play scheme.
Salisbury is an attractive place to live and work and really gives you the best of everything. With easy access to London and local airports, the city of Southampton is only a short train or car journey away or if you prefer the sea, Bournemouth is also accessible. Don't just take our word for it, why not explore what Salisbury has to offer by visiting www.experiencesalisbury.co.uk
Job description
Job responsibilities
Please see attached Job description and person specification for full details of roles and responsibilities.
Person Specification
Education, Qualifications and Training
- The post holder must be educated to degree level in a relevant subject, or have an equivalent level of experience in a similar field.
- Further education level qualification in Information Technology, Informatics or similar.
Experience
- Experience of working in a Data Warehouse environment in a large organisation.
- Development experience with SQL (including T-SQL, SSIS, SSRS & SSAS), or PostgreSQL
- Previous experience working in an Information Department within the NHS
- Experience in Microsoft Power BI Architecture & report development
Knowledge and Skills
- Knowledge of Data Warehousing techniques and principles
- Knowledge of either Microsoft SQL server, including T-SQL, SSIS, SSRS & SSAS or PostgreSQL.
- Ability to discuss complex technical and business process issues in terms appropriate to technical and non-technical.
- Clear understanding of NHS patient activity information, statutory data requirements, data definitions and performance measures
- Knowledge of NHS datasets and specialised coding structures (eg CDS, OPCS4, ICD10, HRG)
Other Job-Related Requirements
- Willing to work in other areas of the Trust or Trust-wide as and when required to do so
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.
Certificate of Sponsorship
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.
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.
Employer details
Employer name
Salisbury NHS Foundation Trust
Address
Salisbury NHS Foundation Trust
Odstock Road
Salisbury
SP28BJ
https://www.salisbury.nhs.uk/
- Company
- Salisbury NHS Foundation Trust
- Location
- Salisbury, United Kingdom SP28BJ
- Employment Type
- Permanent
- Salary
- £35392.00 - £42618.00 a year
- Posted
- Company
- Salisbury NHS Foundation Trust
- Location
- Salisbury, United Kingdom SP28BJ
- Employment Type
- Permanent
- Salary
- £35392.00 - £42618.00 a year
- Posted