Trac proudly powers the recruitment for
Norfolk and Norwich University Hospitals NHS Foundation Trust

About
The Norfolk and Norwich University Hospitals NHS Foundation Trust provides a full range of acute clinical services for a catchment area of up over 1 million people. Our vision is “to provide every patient with the care we want for those we love the most”, reflecting the utmost importance that we attach to the quality of care and experience that each and every one of our patients receives.
We provide specialist services in radiotherapy, neonatalogy, paediatrics, orthopaedics, plastic surgery, ophthalmology, rheumatology, medicine and surgery. Every year our 7,000 staff treat people from Norfolk, neighbouring counties and further afield. Our patients are referred to us by around 100 local GP surgeries and other acute hospitals and primary care Trusts around the country. We are involved in the teaching and training of a wide range of health professionals, in partnership with the University of East Anglia and other local education providers.
Contact
- Address
- 20 Rouen road
- Norwich
- Norfolk
- NR1 1QQ
- Contact Number
- 01603 286286
EPR Lead SQL Developer
Closed for applications on: 27-Nov-2024 00:05
Vacancy status: Closed
Closed for applications on: 27-Nov-2024 00:05
Key details
Location
- Site
- Norfolk & Norwich University Hospital
- Address
- Colney Lane
- Town
- Norwich
- Postcode
- NR4 7UY
- Major / Minor Region
- Norfolk
Contract type & working pattern
- Contract
- 18 months (Fixed Term/ Secondment opportunity until 31st March 2026)
- Hours
- Full time
- Part time
- Flexible working
- Home or remote working
- Compressed hours
Salary
- Salary
- £53,755 - £60,504 per annum, pro rata
- Salary period
- Yearly
- Grade
- (NHS AfC: Band 8a)
Specialty
- Main area
- EPR
At NNUH it is our privilege to provide healthcare to over one million people across Norfolk and surrounding areas. Our vision is to ‘provide the best care for every patient’, and if this inspires you and you share our values, we really want you to join our team.
NNUH is currently the busiest Trauma Unit in the East of England caring for almost 850 trauma patients annually many with complex care needs. We are enhancing our urgent and emergency care specialist services for patients with significant injuries as a result of trauma and have an ambition to become a Major Trauma Centre.
Our values support our vision and guide the behaviour of everything we do, these are:
People-focused
We look after the needs of our patients, carers and colleagues, to provide a safe and caring experience for all.
Respect
We act with care, compassion and kindness and value others’ diverse needs.
Integrity
We take an honest, open and ethical approach to everything we do.
Dedication
We work as one team and support each other to maintain the highest professional standards.
Excellence
We continuously learn and improve to achieve the best outcomes for our patients and our hospital.
Wish you were here? So do we.
We want all our staff to achieve a balance between work and personal life and understand how important flexible working can be. We welcome applications on a full or part time basis, various shift patterns and hybrid working, where roles allow.
At the Norfolk and Norwich University Hospitals NHS Foundation Trust (NNUH), we know the benefits diversity can bring to our organisation such as creativity, innovation and compassion. All of which have a direct impact towards our staff and patient experience. We are committed to being a Hospital for All – being equitable and inclusive, and a place where all feel a sense of belonging. We therefore particularly encourage and welcome applications from candidates who are underrepresented in NNUH’s workforce. These include people from Black, Asian, and Minority Ethnic backgrounds, people with diverse abilities and people within the LGBT+ community.
Job overview
We have embarked on a programme to implement a single Electronic Patient Record (EPR) as part of the NHS digital health ongoing initiative across the Norfolk and Waveney Acute Hospital Collaborative (NWAHC). The collaborative is made up of three acute hospitals in Norfolk and Waveney;
· James Paget University Hospitals NHS Foundation Trust (JPUH)
· Norfolk and Norwich University Hospitals NHS Foundation Trust (NNUH)
· The Queen Elizabeth Hospital King's Lynn NHS Foundation Trust (QEH)
This is a unique opportunity to contribute your skills and expertise to create a meaningful impact on the health and well-being of individuals throughout Norfolk and Waveney. We are dedicated to advancing our digital capabilities in alignment with our long-term strategic goals, ensuring a high standard of patient care and safety for our diverse communities.
The acute hospitals in Norfolk are a vital part of the health and social care system. Our digital mission is an essential part of our transformation into a post-modern healthcare system.
Advert
An EPR Lead SQL Developer plays a critical role in the development, maintenance, and optimization of SQL databases and applications within MEDITECH Expanse. The role involves technical expertise, strong leadership, and a deep understanding of NHS data and regulations.
Working for our organisation
Join us at the Norfolk and Norwich University Hospital and be part of a workforce of over 10,000 staff!
The NNUH is one of the largest NHS trusts in the UK, providing first-class acute care for around one million people, living in Norfolk and surrounding areas. We are a teaching and research hospital, at the forefront of innovation, home to state-of-the-art facilities, such as the Quadram Institute. We are pleased to work closely with the University of East Anglia, providing teaching opportunities for our staff and placement opportunities for their students. We attract some of the best and leading professionals from across the country and are proud that our workforce represents 94 countries from across the world.
We are a friendly, collaborative hospital, working with local services and home to N&N Hospitals Charity
We can offer you the full range of NHS benefits/discounts and in addition:
- Flexible working hours
- Fast Track Staff Physiotherapy Service
- Multi Faith prayer room
- Discounted gym memberships
- Excellent pension scheme and annual leave entitlement
- Wagestream - access up to 40% of your pay as you earn it
- Free Park & Ride service direct to NNUH site
- Free 24-hours confidential counselling support
- On-site Nursery
- On-site cafes offering staff discounts
- Support in career development
- Flexible staff bank
- Salary Sacrifice schemes including lease cars, Cycle to Work scheme and home electronics
Detailed job description and main responsibilities
1. Leadership & Collaboration:
· Lead a team of SQL data warehouse developers.
· Collaborate closely with business analysts, solution architects, and project managers across all three trusts to understand data requirements and translate them into technical specifications.
· Work effectively with stakeholders across different business units to ensure alignment and successful delivery.
2. Data Warehouse Design & Development:
· Support the design and implementation of a robust, scalable, and secure data warehouse solution that integrates data from various source systems within the EPR landscape.
· Develop and maintain ETL (Extract, Transform, Load) processes to populate the data warehouse with accurate and timely data.
· Ensure data quality, integrity, and consistency across the data warehouse.
· Optimize data warehouse performance for efficient querying and reporting.
3. Technical Expertise:
· Strong understanding of data warehousing principles, methodologies, and best practices.
· Expertise in data modelling techniques (dimensional modelling, star schema, etc.).
· Proficiency in SQL and experience with data warehouse platforms (e.g., Snowflake, AWS Redshift, Google BigQuery).
· Knowledge of data integration tools and technologies.
· Experience with cloud-based data warehousing solutions is highly desirable.
The Job Description, which includes a Person Specification, provides a full outline of responsibilities and requirements for this role. Please use your supporting statement to demonstrate how you meet the person specification.
Visa and Immigration
If you are wishing to apply for this role and would require sponsorship (this includes if you are already in a sponsored post and looking to change employer), you can determine the likelihood of obtaining a Certificate of Sponsorship for this post by assessing your circumstances against criteria specified on the gov.uk website https://www.gov.uk/skilled-worker-visa/your-job.
Travelling to work
Staff parking is available onsite; however, this is limited during core working hours. We have more capacity in the evening and at weekends and can usually provide spaces during those hours.
We look to allocate these spaces fairly. Our Travel Office have a set of criteria that staff must meet in order to qualify. If you qualify for a space, you may be placed on a waiting list if we are at full capacity.
The NNUH is served by a number of public buses, and we offer generously discounted monthly passes with First Bus & Konect.
The Costessey Park and Ride runs regularly each day from 06:30 (from P&R) to 20:45 (from NNUH) and this service is free for NHS staff. There is a regular Thickthorn P&R service as well which is free. Applications to the Travel Office are required for this service. We also have a discounted service from the airport P&R if you purchase a bundle. Please see Konect website for further details.
The NNUH host multiple bicycle racks and a salary sacrifice scheme. We also benefit from a Beryl station onsite.
If you work at another Trust site, please discuss travel and parking arrangements at interview.
DBS
If this post involves working with children or adults the application form will ask for information regarding previous convictions as you will be required to undertake a Criminal Record and Barring Check known as a DBS check.
If you are a new employee or registering with the Staff Bank you will need to meet the cost of this unless your salary is less than point 9 of Afc
NHS Service
Should you be appointed to the post we will need to establish any previous NHS service via the ESR IAT and we will accept the submission of your application as your agreement to this.
UK Registration
You will need to have current UK professional registration where this is a requirement of the role.
Application
Following candidate feedback and to reduce our dependency on paper, all our communication with you regarding your application will be by email so could you please check your e-mails (and Spam) regularly.
We value equality in our team and recruit from all sections of the community. We recognise there is a wealth of talent among people who have a disability and if you meet the minimum criteria detailed in the person specification and have a disability, you may wish to be considered under the Guaranteed Interview Scheme by indicating this in the relevant section on your application.
We look forward to receiving your application and if you do not hear within the next four weeks this will usually mean that you have not been short-listed. However, if you wish to confirm this please contact the person indicated on the advert.
Flexibility
Whilst every effort will be made to recruit to the post as it is advertised, there may be occasions where we consider alternative working patterns, such as part time working, or contract types, such as secondments, depending on circumstances. Should you wish to work in a different working pattern to that stated in our advertisement, please indicate this in the supporting statement to your application.
Useful Information
Make sure to follow us on Facebook and Twitter for regular updates about the exciting career opportunities available at NNUH - @NNUHjobs
Norfolk and Norwich University Hospitals NHS Foundation Trust Website
Person specification
Qualifications
Essential criteria
- Degree level or equivalent experience relevant to role.
- Master’s degree or equivalent experience or qualification in relevant area or equivalent experience in a Health Informatics environment.
Experience
Essential criteria
- Extensive experience with Business Intelligence development lifecycle.
- Experience and understanding of data quality issues within the NHS and how to resolve them.
- Experience of managing, developing and recruiting staff.
Skills
Essential criteria
- Exceptional communication skills - written and verbal – able to identify key points from complex issues and explain them appropriately and with clarity.
- Ability to write advanced, complex relational and multidimensional SQL queries and complex stored procedures
- Expert and In-depth knowledge and experience of programming languages, SQL Server Management Studio and scripting languages.
- Expert knowledge of the NHS Data dictionary and Model.
Attitude & Aptitude
Essential criteria
- Effective role model, demonstrating the Collaborative’s values of: • QEHKL’s Living our values • NNUH’s PRIDE values • JPUH’s Proud of the Paget
- Demonstrates understanding and commitment to Equality, Diversity and Inclusion
- Thrives in a fast-paced environment and is adaptable to changing priorities.
- Participate in out of hours work e.g. weekends, evenings as and when required. In particular during peak periods of activity for the EPR programme e.g. key upgrades.
Documents
- EPR Lead SQL Developer Job Description (PDF, 320.4KB)
- Staff Benefits (PDF, 674.5KB)
- Our NNUH Together Staff Network (PDF, 370.4KB)
- Our NNUH LGBT+ Staff Network (PDF, 675.0KB)
- Our NNUH Diverse Ability Staff Network (PDF, 607.0KB)
- Our NNUH Women's Staff Network (PDF, 103.1KB)
- Useful Links (PDF, 184.6KB)
Further details / informal visits contact
- Name
- Pippa Mullan
- Job title
- Data and Analytics Lead Consultant
- Email address
- [email protected]
No longer accepting applications
Sorry, this vacancy is no longer accepting applications.
You can search for similar jobs on the employer's job board, or visit our national jobs board Health Jobs UK.