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
Login changes are coming
From July 2025 onwards, Multi-Factor Authentication (MFA) will be introduced to this site. This will add an extra step to the login process: a requirement to enter a One Time Passcode (OTP) upon login to minimise fraud and maintain security. See our summary page here for more details.
Higher Business Intelligence Developer'
Closed for applications on: 4-Jan-2024 00:02
Vacancy status: Closed
Closed for applications on: 4-Jan-2024 00:02
Key details
Location
- Site
- 20 Rouen Rd
- Town
- Norwich
- Postcode
- NR4 7UY
- Major / Minor Region
- Norfolk
Contract type & working pattern
- Contract
- Permanent: and Fixed Term/ Secondment Opportunity until 31st March 2025
- Hours
- Full time
- Flexible working
Salary
- Salary
- £43,742 - £50,056 per annum, pro rata
- Salary period
- Yearly
- Grade
- (NHS AfC: Band 7)
Specialty
- Main area
- Digital Health (BI)
- Interview date
- 17/01/2024
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
One permanent and two fixed term contract/ secondment opportunities - until 31st March 2025.
The Norfolk and Norwich University Hospitals NHS Foundation Trust (NNUHFT) Digital Health team is responsible for the delivery of digital services across the Trust to support its clinical and administrative obligations.
Across the three acute hospitals in Norfolk and Waveney, NNUH, JPUH and QEHKL, the NNUHFT is starting one of the biggest pieces of digital transformation work we’ve ever undertaken – moving from paper-based patient records to electronic ones. The Electronic Patient Record (EPR) programme is currently at the beginning of a journey to transform how information about patients’ health and care is stored, viewed, and used within our acute hospitals. The EPR will use cutting edge technology to create a new digital system where staff will be able to access your health and care information quickly and securely, meaning you experience quicker and better care.
The Business Intelligence department are the custodians of all the data within the Trust which employs approx. 10,000 staff. The Department is comprised of a team of 25 Analysts and Developers whose focus is providing insights for decision makers all over the Trust.
Interview date: 17th January 2024.
If you are considering applying for this post on a secondment basis, please discuss with your Line Manager prior to applying to ascertain whether this could be supported.
Advert
We’re looking to recruit three Higher BI Developers on a full-time basis, one substantive and two fixed terms until March 2025. As a Higher BI Developer, you will consult with stakeholders to collate reporting requirements, translate them into Dimensional models and implement the ETL solutions into our existing Data Warehouse. Alongside your colleagues, you will also support the maintenance of the Data Warehouse to ensure that it is running efficiently, configure bespoke data feeds to further expand our repository of data, and fully administer our Test and Production SQL Servers. You will have access to various products to support you with this work such as (but not limited to) T-SQL, SSRS, SSIS, SSAS and Power BI. You will supervise and manage the workloads of colleagues within the BI Development team whilst assisting with their personal development and will also act as a subject matter expert for the wider department. The BI Development team will be pivotal in developing a new Data Warehouse for the up-and-coming EPR deployment. This role presents a good opportunity for developers looking for a new challenge and wanting to take the next step in their careers. The role will offer hybrid/remote working and involve working from home as well as occasional attendance in the office. |
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
Technical Responsibilities:
- Responsible for the supporting the maintenance and development of the data warehouse including the design and implementation of automated Data Extract, Transformation and Load processes to meet new and changing requirements.
- Based on customer consultation design functional specifications for development work. Using creative and problem solving skills, support the changing information requirements of the trust through the design, development, creation and deployment of data warehouse tables and other BI developments.
- Work with the wider informatics team in the documenting workflow and designing specification of new BI solutions including, but is not limited to, new data warehouse tables/views, Visualisations, R and Python development.
- Development and deployment of pro forma and report templates to support efficient table and report design and development across the trust.
- Identify, investigate and resolve problems in the production of routine and ad-hoc reports and ensure all work is fully validated and quality assured prior to distribution and that reports meet the end users need. Unresolved discrepancies must be reported to the senior management.
Communication Responsibilities:
- Be a single point of contact for a subset of the work produced by the department, attending meetings as a representative of the department and advising senior managers on the best use of the information available.
- Effective use of communication and persuasion skills to discuss tasks with customers capture and analyse their information requirements. Highlight the benefits of a particular approach and negotiate a term of reference to ensure a focus on answering the right questions in the right way.
- Be responsible for the development, production, and delivery of a number of performance and business change projects, managing conflicting demands and communication sometimes sensitive and/or contentious issues with senior managers and external stakeholders.
Management Responsibilities:
- Supervise and support a team of BI Developers and Technical Analysts prioritising, allocating and quality assuring their work and taking responsibility for their performance, training, and development, providing direction and leadership whilst dealing with own complex work.
- Develop and maintain a high level of skills and abilities across the team and regularly evaluate performance and development needs, escalating exceptional performance and/or any concerns to the Senior BI Developer.
- Take ownership of individual and team workloads, keeping people informed of progress and managing expectations where necessary, ensuring that all departmental routine and ad-hoc reporting is produced to meet the agreed deadlines.
Please refer to the Job Description for the full specification of responsibilities and requirements for this post.
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
Experience
Essential criteria
- Significant experience working and developing with Microsoft BI solutions (including SQL Server, SSIS, SSRS, SSAS)
- Experience of managing informatics projects over an extended period involving multiple teams and systems.
- Experience of developing ETL routines, working with dimensional data base design and management and reporting solutions.
Skills
Essential criteria
- Ability to supervise, support and develop a team. Managing workload, conflicting priorities and quality
- Demonstrates excellent interpersonal skills with proven experience of forming and maintaining internal and external relationships.
Attitude, aptitude
Essential criteria
- Effective role model, demonstrating NNUH’s PRIDE values of People focussed, Respect, Integrity, Dedication and Excellence
- Demonstrates understanding and commitment to Equality, Diversity and Inclusion
Qualifications
Essential criteria
- Relevant Degree (Health Informatics, Computer Studies, Mathematics) or equivalent experience.
Further details / informal visits contact
- Name
- Dan Starling
- Job title
- Senior Business Intelligence Developer
- 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.