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 Senior SQL Developer
Closed for applications on: 2-Nov-2024 00:00
Vacancy status: Closed
Closed for applications on: 2-Nov-2024 00:00
Key details
Location
- Site
- Norfolk and Norwich university hospital
- Town
- Norwich
- Postcode
- NR47UY
- Major / Minor Region
- Norfolk
Contract type & working pattern
- Contract
- 18 months (Fixed Term/ Secondment opportunity until 31st March 2026)
- Hours
- Full time
- Part time
- Home or remote working
- Compressed hours
Salary
- Salary
- £46,148 - £52,809 Per annum (Pro Rate)
- Salary period
- Yearly
- Grade
- (NHS AfC: Band 7)
Specialty
- Main area
- Digital Health
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
The Senior SQL Developer will become a Meditech data model expert, have extensive data warehousing & SQL experience and will need to currently understand business objectives, NHS statutory & contractual deliverables, questions, and problems. They will have the ability in obtaining and presenting data to address these.
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
- Ensure that the full reporting system is configured to meet new best practice ways of working to achieve cash releasing and qualitative benefits with improved workflows whilst being compliant with statutory and contractual commitments. Work across application modules to meet integration needs and to ensure the full patient pathway is correctly supported by the system.
- Works with stakeholders to understand extremely complex reporting needs across multiple existing systems. Applies Meditech build and design expertise to analyse current business practices to enable full documentation and provide the recommended reporting solutions
- Lead where appropriate the workstream planning of complex and multi system dynamic processes including inception, technical design, development, testing and delivery of BI solutions.
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 the role.
- Postgraduate qualification (master’s degree) or equivalent experience or qualification in relevant area or equivalent experience in a Health Informatics environment. Management qualification or equivalent experience. Qualification in Project Management.On-going evidence of personal development.
Experience
Essential criteria
- Experience of training staff on technical systems. Database administration experience.
- Experience with Business Intelligence development lifecycle. Experience and understanding of data quality issues within the NHS and how to resolve them.
Skills
Essential criteria
- In-depth knowledge and experience of programming languages, SQL Server Management Studio and scripting languages. Ability to write advanced, complex relational and multidimensional SQL queries and complex stored procedures.
- Good knowledge and understanding of mandatory reporting requirements, NHS data standards and definitions. Good knowledge of the NHS Data dictionary and Model.
- Strong communication skills - written and verbal – able to identify key points from complex issues and explain them appropriately and with clarity. Advanced key board skills and VDU use.
Attitude, Aptitude
Essential criteria
- To act in ways that support equality and diversity and the rights of individuals, ensuring own practice is in accordance with Trust policies. Thrives in a fast-paced environment and is adaptable to changing priorities.
- Ability to identify and embrace change in the drive towards continuous improvement. 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.
- Be responsible for, working autonomously to plan and organise own workload to meet multiple and often conflicting deadlines. Ability to listen and interpret users' needs and to inspire confidence.
Further details / informal visits contact
- Name
- Pippa Mullan
- Job title
- Data & 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.