Job summary
Employer heading
Data Warehouse Developer
Band 6
Job overview
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.
Main duties of the job
Please see attached Job description and person specification for full details of roles and responsibilities
Working for our organisation
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
Detailed job description and main responsibilities
Please see attached Job description and person specification for full details of roles and responsibilities.
Person specification
Education, Qualifications and Training
Essential criteria
- The post holder must be educated to degree level in a relevant subject, or have an equivalent level of experience in a similar field.
Desirable criteria
- Further education level qualification in Information Technology, Informatics or similar.
Experience
Essential criteria
- Experience of working in a Data Warehouse environment in a NHS organisation.
- Development experience with SQL (including T-SQL, SSIS, SSRS & SSAS), or PostgreSQL
Desirable criteria
- Experience in Microsoft Power BI Architecture & report development
Knowledge and Skills
Essential criteria
- 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.
- A good understanding of the NHS Data Standards and Information Publications.
Desirable criteria
- 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
Essential criteria
- Willing to work in other areas of the Trust or Trust-wide as and when required to do so
Documents to download
Further details / informal visits contact
- Name
- Martin Mortimore
- Job title
- BI Architect
- Email address
- [email protected]
- Telephone number
- 01722336262
- Additional information
x5711
List jobs with Salisbury NHS Foundation Trust in Administrative Services or all sectors