Job summary
The Business Intelligence team at the Norfolk and Norwich University Hospitals NHS Foundation Trust (NNUHFT) is here to make a real impact in healthcare through data. As a member of our team, you'll be joining a close-knit group of 25 information analysts, officers, and developers dedicated to providing valuable insights and analytics.
In our fast-paced environment, we focus on using data to enhance patient care, improve operational efficiency, and make informed decisions. As an integral part of our team, you'll have the opportunity to work collaboratively with different departments across the hospital, contributing to the overall goal of optimizing healthcare services.
We are currently embarking on the largest piece of digital transformation ever undertaken at the Trust.
Alongside two other acute hospitals in the region, we will be moving from paper-based patient records to electronic ones. The Electronic Patient Record (EPR) programme aims to revolutionize how patient health and care information is managed within our acute hospitals.
Business Intelligence plays a crucial role in the EPR project, as we look to develop and promote a new modern data platform for the Trust.
If you're passionate about technology, collaboration, and growth, this opportunity is perfect for you!
Main duties of the job
We're looking to recruit a Higher BI Developer.
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 assist in the administration of 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.
About us
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
Job description
Job responsibilities
- You will supervise and manage the workloads of colleagues within the BI Development team, whilst assisting with their personal development and acting 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.
- To support the delivery of a high quality, safe and compassionate healthcare service, all staff are expected to act as a role model to others in all aspects of their work and consistently demonstrate NNUHs PRIDE values of People focused, Respect, Dedication, Integrity, and Excellence.
Job description
Job responsibilities
- You will supervise and manage the workloads of colleagues within the BI Development team, whilst assisting with their personal development and acting 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.
- To support the delivery of a high quality, safe and compassionate healthcare service, all staff are expected to act as a role model to others in all aspects of their work and consistently demonstrate NNUHs PRIDE values of People focused, Respect, Dedication, Integrity, and Excellence.
Person Specification
Qualifications
Essential
- Relevant Degree (Health Informatics, Computer Studies, Mathematics) or equivalent experience. Relevant postgraduate qualification or equivalent experience
- Relevant professional qualifications in a BI field Certified in the use of Business Intelligence tools
- The post holder will be required to undertake Trust mandatory training as well as other training relevant to the post.
Experience
Essential
- Significant, demonstrable experience in a similar role. Significant experience working and developing with Microsoft BI solutions (including SQL Server, SSIS, SSRS, SSAS);
- Experience of developing ETL routines, working with dimensional data base design and management and reporting solutions. Sound understanding of data quality management principles and best-practice.
- Experience of the Management or supervision of staff. Experience of managing informatics projects over an extended period involving multiple teams and systems.
Skills
Essential
- 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
- Effective role model, demonstrating NNUH's PRIDE values of People focussed, Respect, Integrity, Dedication and Excellence
Person Specification
Qualifications
Essential
- Relevant Degree (Health Informatics, Computer Studies, Mathematics) or equivalent experience. Relevant postgraduate qualification or equivalent experience
- Relevant professional qualifications in a BI field Certified in the use of Business Intelligence tools
- The post holder will be required to undertake Trust mandatory training as well as other training relevant to the post.
Experience
Essential
- Significant, demonstrable experience in a similar role. Significant experience working and developing with Microsoft BI solutions (including SQL Server, SSIS, SSRS, SSAS);
- Experience of developing ETL routines, working with dimensional data base design and management and reporting solutions. Sound understanding of data quality management principles and best-practice.
- Experience of the Management or supervision of staff. Experience of managing informatics projects over an extended period involving multiple teams and systems.
Skills
Essential
- 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
- Effective role model, demonstrating NNUH's PRIDE values of People focussed, Respect, Integrity, Dedication and Excellence
Disclosure and Barring Service Check
This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).
Additional information
Disclosure and Barring Service Check
This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).
