Data Warehouse Specialist Developer (EPR)
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 Specialist Developer on a Fixed Term Contract to support the implementation of the new Shared EPR.
We are looking for a dynamic, forward thinking individual to work closely with the Data Architect tomaintain 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 act as a technical expert to 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)
- PostgreSQL
- Data Warehousing Architectures
- Microsoft Power BI
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 essential for this role.
Main duties of the job
The post holder is responsible for the adaptation, support and development of the technologies and processes supporting the safe use of the Trust Data Warehouse & BI Platform (a major trust wide information system). Ensuring accurate data flows to support Trust Financial Reporting, Income Recovery, National Data Submissions and Internal reporting requirements
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
Qualifications
- Masters degree or equivalent relevant training and experience.
- Degree in relevant subject
- Evidence of continued professional development
Experience
- Significant experience of working in a Data Warehouse environment in a large organisation.
- Significant development experience with SQL (including T-SQL, SSIS, SSRS & SSAS), or PostgreSQL
- Demonstrable experience working in an NHS Acute/Community Trust
- Previous experience working in an Information Department within the NHS
- Experience delivering specialist training to other staff and organisations in all aspects of the Data Warehouse technical environment.
- Previous experience working within a shared EPR Programme
Knowledge
- Expert knowledge of the NHS Data Manual, Information Standards, data flows and statistical returns.
- Expert knowledge of Microsoft SQL Server (T-SQL, SSIS, SSRS, SSAS), PowerBI and Data Warehouseing Architectures
- Clear understanding of NHS patient activity information, statutory data requirements, data definitions and performance measures
- Ability to communicate complex (potentially contentious or sensitive) analytical issues to data literate persons or groups at various levels.
- Knowledge of NHS datasets and specialised coding structures (eg CDS, OPCS4, ICD10, HRG)
- Technical Knowledge of PostgreSQL
Employer details
Employer name
Salisbury NHS Foundation Trust
Address
Salisbury NHS Foundation Trust
Odstock Road
Salisbury
SP2 8BJ
United Kingdom
Employer's website
https://www.salisbury.nhs.uk/