Skip to main content
Please wait, loading

Job summary

Main area
Digital Health (BI)
Grade
NHS AfC: Band 6
Contract
Permanent
Hours
  • Full time
  • Flexible working
37.5 hours per week
Job ref
234-23-C2998
Employer
Norfolk and Norwich University Hospitals NHS Foundation Trust
Employer type
NHS
Site
20 Rouen Rd
Town
Norwich
Salary
£35,392 - £42,618 per annum
Salary period
Yearly
Closing
17/07/2024 23:59

Employer heading

Norfolk and Norwich University Hospitals NHS Foundation Trust logo

Business Intelligence Developer

NHS AfC: Band 6

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

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 BI Developer on a full-time basis.  37.5 hours per week.

 As a 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.

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 NNUH’s ‘PRIDE’ values of People focused, Respect, Dedication, Integrity, and Excellence.

Interviews for this position will be held in-person at our Norwich office.

The role will involve working from the office.

Interview date: 30th/31st July 2024

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

  • 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.
  • Undertake continued data validation and maintenance of the data warehouse, ensuring that any core system changes are communicated to you, and are implemented, as appropriate, within the data warehouse.
  • System administration of Business Intelligence software including the monitoring of usage and compliance.
  • Development of applications (web and non-web) to support data capture.

Please refer to the Job Description for the full specification of responsibilities and requirements for this post.

Person specification

Experience

Essential criteria
  • Relevant Degree (Health Informatics, Computer Studies, Mathematics) or equivalent experience.

Skills

Essential criteria
  • Able to manage multiple competing projects and effectively manage the resources at their disposal
  • Ability to use own initiative and work under pressure, possessing good time management skills. Delivering work to the required timescales
  • Practical applied knowledge of database design and the use of SQL

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

Experience

Essential criteria
  • 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

Employer certification / accreditation badges

Apprenticeships logoNo smoking policyAge positiveInvestors in People: GoldImproving working livesStonewall Health ChampionsMindful employer.  Being positive about mental health.We offer Wagestream - A financial wellbeing benefit which lets you access your pay as you earn it.Disability confident employerNHS Pastoral CareStep into healthArmed Forces Covenant

Documents to download

Apply online now

Further details / informal visits contact

Name
Dan Starling
Job title
Senior Business Intelligence Developer
Email address
[email protected]
Apply online nowAlert me to similar vacancies