Job summary
- Main area
- Data Warehouse Developer
- Grade
- 6
- Contract
- 12 months (Secondment or Fixed Term Contract)
- Hours
- Full time
- Flexible working
- Home or remote working
- Job ref
- 292-7205038-COPR
- Employer
- The Princess Alexandra Hospital NHS Trust
- Employer type
- NHS
- Site
- Harlow
- Town
- Harlow
- Salary
- £37,338 - £44,962 Plus 5% high cost area supplement Per Annum
- Salary period
- Yearly
- Closing
- 03/06/2025 08:00
Employer heading
Data Warehouse Developer
6
The Princess Alexandra Hospital NHS Trust (PAHT) provides a full range of general acute, outpatient and diagnostic services at The Princess Alexandra Hospital in Harlow, the Herts and Essex Hospital in Bishop’s Stortford, and St Margaret’s Hospital in Epping.
Our values
The Princess Alexandra Hospital NHS Trust (PAHT) promise to our patients, as identified by our three values which will contribute to improving our patients’ experiences, is:
Patient at heart – Always holding the patient and their wellbeing at the centre of our thoughts and efforts.
Everyday excellence – Sharing and celebrating our successes, being honest when we get it wrong, giving us the ability to learn from both.
Creative collaboration – Knowing strength comes from diversity, we combine our experiences, skills and talents, working together to find new and better ways to care.
Job overview
This is a 12 month opportunity to join our Informatics team at PAH
The post holder will be part of the team developing and rolling out a robust
integrated Data Warehouse, developing scripts to extract, transform and load data from information systems across the Trust.
Main duties of the job
One area in particular which is vital to the Trust and its income is the SUS/CDS integration with SLAM. This role is key to ensuring delivery of data and information to support billing and forecasting, and to enable the identification of issues that may compromise this goal. This role, therefore, will involve developing a close working relationship with colleagues in our Finance department.
Working for our organisation
This is an exciting time for PAHT. Over the next five years we are on a digital transformation journey, leading us to our brand new hospital. You’ll be part of the team supporting our organisation in a diverse and challenging role; a role which can make a significant difference to our patients, staff and the future direction of our services.
Our people demonstrate energy and commitment towards improving the care and experiences provided to our patients and the drive to be an ‘outstanding’ organisation.
It’s never been a better time to join us.
Detailed job description and main responsibilities
Liaise with third party suppliers and staff across all levels of the Trust in the
planning, design and development of highly complex software system
solutions.
• Migrate data marts and incorporate into the Data Warehouse.
• Working with core EPR Supplier, develop iterative ETL scripts to load data into our Data Warehouse.
• Take an active role within the team developing a Data Warehouse Schema and ETL timetable that will enable real time reporting.
• Work with the key contacts to develop the Data Warehouse through design and understanding of the EPR Schema, Trust interface and messaging engines to enable seamless integration.
• Work with and support colleagues in the team to ensure analysts are fully
supported and informed on use of the Data Warehouse for maximum
benefit.
Person specification
Experience
Essential criteria
- Data warehouse development
- NHS data experience
Desirable criteria
- SUS experience
Skills
Essential criteria
- Detailed knowledge of relational database (SQL, MYSQL)
- Developed in at least one of C# .NET, VB.NET or ASP.et
- Presenting skills
Desirable criteria
- Stakeholder or project management
Qalifications
Essential criteria
- Educated to degree level in computer related discipline
Employer certification / accreditation badges
.png "NHS Rainbow badge")
Documents to download
Further details / informal visits contact
- Name
- Jalil Ahmed
- Job title
- Head of Business Intelligence
List jobs with The Princess Alexandra Hospital NHS Trust in Administrative Services or all sectors