Job summary
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. These insights are realised through the provision of information, research and analysis to customers using products such as SSRS and Power BI. At the very heart of everything is the data warehouse which runs smoothly to feed data to all our products.
Our service enables operational and clinical staff to provide the best patient care possible and aims to alleviate pressure where it matters most.
Full time: 37.5 hours per week
Advert closes: 21st May 2023
Interview date: 1st June 2023
Main duties of the job
As the Senior BI Developer you will lead a team of BI developers and visualization experts and be responsible for the Trust's Data Warehouse environment. The role takes care of engaging with other technical experts, both internal and external, in order to maintain and further expand our repository of data. The role will also play a key part in the upcoming Electronic Patient Record program which will see all major patient systems consolidated into one providing improved data linkages and patient pathway mapping.
- Fully documented on-prem Enterprise Data Warehouse with high availability.
- Suite of PowerBI dashboards with fully automated data pipelines.
- Access to Azure platform as part of the EPR project.
This is a fantastic opportunity to help lead the region in designing and implementing a modern data warehouse.
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
- First and Second line management of a team of informaticians, allocating, prioritising and quality assuring their work. Take responsibility for their performance, training and development. Provide support, direction and leadership whilst dealing with own complex work.
- Develop and maintain a high level of skills and abilities across the team. Regularly evaluate performance and development needs to ensure that development requirements are identified, performance issues are addressed and exceptional work is recognised and rewarded.
- Produce and deliver comprehensive training material to develop and maintain a high level of skills and abilities across the team. Ensuring that technical BI skills are shared and developed. Teach, tutor and, coach, formally or informally as required to ensure effective use of the BI systems.
- 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.
- Assist in the management of budgets allocated to the department and/or delegated budget for projects and on-going maintenance of systems. Assist in the development of business cases and negotiations with external companies.
- Responsible for the support and maintenance and development of the data warehouse and BI infrastructure including the design and implementation of automated Data Extract, Transformation and Load processes to meet new and changing requirements.
- Responsible for the oversight and quality assurance of visual BI reporting produced by the informatics department. This includes ensuring that the requirements are identified and met and that the report design meets agreed standards.
- Develop, Interpret and implement policies and procedures, providing guidance from an information management perspective.
- 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 and assisting in the development of new BI solutions including, but is not limited to, new data warehouse tables/views, Visualisations, R and Python development.+
Please see the attached job description for full details.
Job description
Job responsibilities
- First and Second line management of a team of informaticians, allocating, prioritising and quality assuring their work. Take responsibility for their performance, training and development. Provide support, direction and leadership whilst dealing with own complex work.
- Develop and maintain a high level of skills and abilities across the team. Regularly evaluate performance and development needs to ensure that development requirements are identified, performance issues are addressed and exceptional work is recognised and rewarded.
- Produce and deliver comprehensive training material to develop and maintain a high level of skills and abilities across the team. Ensuring that technical BI skills are shared and developed. Teach, tutor and, coach, formally or informally as required to ensure effective use of the BI systems.
- 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.
- Assist in the management of budgets allocated to the department and/or delegated budget for projects and on-going maintenance of systems. Assist in the development of business cases and negotiations with external companies.
- Responsible for the support and maintenance and development of the data warehouse and BI infrastructure including the design and implementation of automated Data Extract, Transformation and Load processes to meet new and changing requirements.
- Responsible for the oversight and quality assurance of visual BI reporting produced by the informatics department. This includes ensuring that the requirements are identified and met and that the report design meets agreed standards.
- Develop, Interpret and implement policies and procedures, providing guidance from an information management perspective.
- 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 and assisting in the development of new BI solutions including, but is not limited to, new data warehouse tables/views, Visualisations, R and Python development.+
Please see the attached job description for full details.
Person Specification
Qualifications
Essential
- Relevant Degree (Health Informatics, Computer Studies, Mathematics) or equivalent experience.
Experience
Essential
- Significant and demonstrable leadership and people management experience, ideally within informatics
- 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.
Skills
Essential
- Able to manage multiple competing projects and effectively manage the resources at their disposal
- Ability to develop and deliver comprehensive training material with a proven track record
Attitude, aptitude
Essential
- 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
Person Specification
Qualifications
Essential
- Relevant Degree (Health Informatics, Computer Studies, Mathematics) or equivalent experience.
Experience
Essential
- Significant and demonstrable leadership and people management experience, ideally within informatics
- 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.
Skills
Essential
- Able to manage multiple competing projects and effectively manage the resources at their disposal
- Ability to develop and deliver comprehensive training material with a proven track record
Attitude, aptitude
Essential
- 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
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).
