Job summary
We are seeking an intelligent and enthusiastic Database Solutions Developer (primarily using Microsoft SQL Server and SSIS) with the aptitude to help us lead the way in innovative clinical intelligence delivery. We have a track record of mutually supportive team working and, for individuals with the ambition and ability to learn quickly, there are excellent prospects for career progression within the team.
Applicants must be eligible to work in the UK, as we regret that we are unable to offer visa sponsorship for this role.
For more information, please contact Carl Davis at carldavis1@nhs.net
** STRICTLY NO AGENCIES, PLEASE **
This post is subject to receiving references which are deemed satisfactory by the ICB and must cover 3-5 years of employment or studying history. It would be helpful if you could advise referees in advance that they will be approached promptly and a punctual response would be much appreciated.
The ICB operates a non-smoking policy. Smoking is not permitted on any ICB premises or whilst on duty.
The ICB is committed to being an equal opportunities employer and in order to reflect the diversity of its population, positively encourages applications from all areas of the community, regardless of gender, race, faith, disability, age or sexual orientation. We are fully committed to equality and diversity and encourage applications from all sections of the community including users of mental health services.
Main duties of the job
- Design, build, develop and maintain database solutions using Microsoft SQL Server, SQL Server Integration Services (SSIS), Python and other technologies, in collaboration with other members of the team;
- Provide technical knowledge to support ad-hoc projects and tasks;
- Transfer knowledge to co-workers;
- Develop innovative technical solutions to ensure the ICB complies with Information Governance guidelines whilst supporting the availability of patient level information to clinical users.
This role requires a blend of skills - technical proficiency in the Microsoft Business Intelligence tools, an open and team-centred approach to delivery, an enquiring and analytical style of working, plus the ability to communicate with a diverse range of stakeholders and customers.
You will be a highly motivated, intelligent individual who is an excellent problem solver capable of working both in a team and autonomously. Probably a graduate, you will have skills and experience in analytics, database / web development / programming, though not necessarily to an advanced level in every one of the areas in which we operate. You might already have some NHS experience, but will certainly be able to demonstrate the application of logical and creative thinking, and the aptitude and willingness to learn challenging programming techniques and apply them to the healthcare sector. We will coach you to develop your full potential in this important role.
About us
NHS Nottingham and Nottinghamshire Integrated Care Board (ICB) is a strategic component of the Integrated Care System (ICS) across Nottingham and Nottinghamshire. We were formed with the intention to improve population health and collaborate with local partners (NHS, Local Authority and Third Sector) to deliver high quality health and social care provision to our local population.
We have accountability for the system delivery of the ICS' priorities such as improving outcomes in population health and healthcare, tackling inequalities in outcomes, experience, and access, enhancing productivity and value for money, and helping the NHS support broader social and economic development.
We seek to improve the patient experience and are committed at looking at innovative ways we can improve care and offer access and choice to our patients. Patients are at the heart of everything we do and it's important that they are involved not just in decisions about their individual care, but also in the decisions that shape the health services delivered locally. In conjunction, with patient experience and the growing demands of our population; we are facing significant financial challenge. We are required to reduce expenditure to sustainable levels (ICS 5-year strategic plan).
The ambitions are great, but so are the opportunities to be part of our new and evolving organisation, to make positive impactful change to the health and social care agenda across Nottingham and Nottinghamshire.
Job description
Job responsibilities
Business Intelligence Development
- Use your SQL skills to work with all members of the Data Management Team to maintain stored procedures which form the data access part of a two-tier architecture.
- Work alongside other team members to assist with maintenance of the web-based content management system
- Automate and schedule reports, processes and ETL projects within the Data Management Team. In particular to proactively seek robust, automated solutions to information and reporting requirements that ensure the team can evolve in an increasingly demanding climate.
- Work with clinical groups (e.g. GPs and hospital consultants) and ICS managers to rapidly develop new functionality that supports innovative ways of delivering healthcare.
- Responsible for troubleshooting and problem solving within the data warehouse and SQL environment ensuring data loading, translation and user-reported issues are systematically resolved.
- Responsible for documentation, improvement and maintenance of the products including rollout of upgrades and bug fixes.
- To work with the Head of Data Management and colleagues in the Nottinghamshire Health Informatics Service (NHIS) to ensure that databases and applications are configured efficiently and to input into the development of new and existing products and processes.
- To review, evaluate and test SQL and other scripts, including those developed by other members of the team, providing support and advice on best practice.
- Responsible for ensuring availability and performance of the products that support the wider Information Teams.
- Support the Head of Data Management in advising on prioritised requests for new reporting solutions, and existing report/reporting systems enhancements.
- Adhere to our formal change management process to ensure that all products are developed and tested in line with our framework and thoroughly tested before final use and roll-out to end users.
- Maintain a log of changes you have made and comment your code as required.
- Work with the Head of Data Management to ensure that data quality is systematically improved and that any changes to national coding methodologies are appropriately taken into account when benchmarking the quality of data from external organisations.
- Ensure the ICBs are compliant with the processing and storage requirements of the NHS Minimum Data Sets (Community, CSDS, MHMDS, A&E ECDS etc.), including the identification and investigation of problems with data quality in liaison with the respective teams
Additional Tasks
- Serve as first point of escalation on user support issues and technical difficulties relating to the Business Intelligence platform.
- Research and make recommendations to the Principal Developer on best practices for metadata, database design and development, and Business Intelligence platform development and design including ETL, Data Quality, Data Governance Processes, Report Delivery & OLAP solutions.
- Act as a committed team member to ensure a positive work environment and successful project / task completion.
- Proactively work with users to ensure existing systems are meeting business needs.
- Be prepared to develop your skills to meet new demands and technology change. Proactively progress your personal development in building your skills-base and exposure to new technologies.
- Work flexibly around the need to share tasks and deal with conflicting priorities as these arise.
- Take ownership of tasks or projects that you have been allocated, planning your workload and communicating what you are doing to other team members.
- Write and maintain help information for users.
- Be prepared to start data processes off out-of-hours on an occasional basis and in exceptional circumstances be prepared to work out-of-hours on essential maintenance tasks.
- Be prepared to evaluate new products and technologies and consider their usage as solutions within the development work program.
- Be willing to work away from the base should this be required.
- Comply with and actively promote the organisations equal opportunities policy
Performance, Risk Management, Audit, Education and Training
- Mentor junior staff and support administrative staff on the team as required.
- Assist in the training of other members of the Data Management team.
- Maintain physical skills for managerial, administrative and professional tasks where accuracy is important.
Management and Liaison
- Contribute to the line management of junior members of the Data Management Team including conducting their annual appraisals with regular review of development plans throughout the year to assess progress.
- To assist with disciplinary procedures as required.
- Where appropriate ensure patient and public involvement within the Data Management Team by working directly with patients, carers, and patient public and carer support groups.
- Establish an effective working relationship with all staff at GP Practice level and within all ICS organisations.
- Liaise with secondary care colleagues where joint products are developed and where data quality issues have been identified and require improvement
Confidentiality and Data Security
- All employees are required to comply fully with the duties and responsibilities outlined in the NHS Information Governance Policy. You are required to preserve the confidentiality of any information regarding patients, staff records in your area (in connection with their employment) and the Trust business and this obligation shall continue in perpetuity.
- You have a responsibility to comply with the Data Protection Act 2018, NHS Confidentiality principles (e.g. Caldicott guidelines) and any code of practice on Confidentiality and Data Protection, as adopted by the ICB. Departmental codes of practice and procedures for confidentiality are available from the head of department.
- In addition you are required to ensure that all information collected, stored and used is done so in compliance with the above Act and any relevant ICB Policy
COMMUNICATION AND WORKING RESPONSIBILITIES
- The post holder will be required to communicate and provide information to a wide range of internal and external stakeholders (see below).
- Support collaborative working across ICBs, NHS Trusts and the wider Health and Social Care system.
- Assist with Freedom of Information requests; keep under review the framework and in accordance with the legislation
Internal
- ICB staff including clinicians, managers, analysts and Information Governance experts
- Nottinghamshire Health Informatics Service (NHIS) staff
External
- Clinicians in primary and secondary care
- NHS Digital staff, both centrally and within their regional Data Services for Commissioners Regional Office (DSCRO) teams
- Commissioning Support Units
- Social Care staff
- Patients, public and carers
Job description
Job responsibilities
Business Intelligence Development
- Use your SQL skills to work with all members of the Data Management Team to maintain stored procedures which form the data access part of a two-tier architecture.
- Work alongside other team members to assist with maintenance of the web-based content management system
- Automate and schedule reports, processes and ETL projects within the Data Management Team. In particular to proactively seek robust, automated solutions to information and reporting requirements that ensure the team can evolve in an increasingly demanding climate.
- Work with clinical groups (e.g. GPs and hospital consultants) and ICS managers to rapidly develop new functionality that supports innovative ways of delivering healthcare.
- Responsible for troubleshooting and problem solving within the data warehouse and SQL environment ensuring data loading, translation and user-reported issues are systematically resolved.
- Responsible for documentation, improvement and maintenance of the products including rollout of upgrades and bug fixes.
- To work with the Head of Data Management and colleagues in the Nottinghamshire Health Informatics Service (NHIS) to ensure that databases and applications are configured efficiently and to input into the development of new and existing products and processes.
- To review, evaluate and test SQL and other scripts, including those developed by other members of the team, providing support and advice on best practice.
- Responsible for ensuring availability and performance of the products that support the wider Information Teams.
- Support the Head of Data Management in advising on prioritised requests for new reporting solutions, and existing report/reporting systems enhancements.
- Adhere to our formal change management process to ensure that all products are developed and tested in line with our framework and thoroughly tested before final use and roll-out to end users.
- Maintain a log of changes you have made and comment your code as required.
- Work with the Head of Data Management to ensure that data quality is systematically improved and that any changes to national coding methodologies are appropriately taken into account when benchmarking the quality of data from external organisations.
- Ensure the ICBs are compliant with the processing and storage requirements of the NHS Minimum Data Sets (Community, CSDS, MHMDS, A&E ECDS etc.), including the identification and investigation of problems with data quality in liaison with the respective teams
Additional Tasks
- Serve as first point of escalation on user support issues and technical difficulties relating to the Business Intelligence platform.
- Research and make recommendations to the Principal Developer on best practices for metadata, database design and development, and Business Intelligence platform development and design including ETL, Data Quality, Data Governance Processes, Report Delivery & OLAP solutions.
- Act as a committed team member to ensure a positive work environment and successful project / task completion.
- Proactively work with users to ensure existing systems are meeting business needs.
- Be prepared to develop your skills to meet new demands and technology change. Proactively progress your personal development in building your skills-base and exposure to new technologies.
- Work flexibly around the need to share tasks and deal with conflicting priorities as these arise.
- Take ownership of tasks or projects that you have been allocated, planning your workload and communicating what you are doing to other team members.
- Write and maintain help information for users.
- Be prepared to start data processes off out-of-hours on an occasional basis and in exceptional circumstances be prepared to work out-of-hours on essential maintenance tasks.
- Be prepared to evaluate new products and technologies and consider their usage as solutions within the development work program.
- Be willing to work away from the base should this be required.
- Comply with and actively promote the organisations equal opportunities policy
Performance, Risk Management, Audit, Education and Training
- Mentor junior staff and support administrative staff on the team as required.
- Assist in the training of other members of the Data Management team.
- Maintain physical skills for managerial, administrative and professional tasks where accuracy is important.
Management and Liaison
- Contribute to the line management of junior members of the Data Management Team including conducting their annual appraisals with regular review of development plans throughout the year to assess progress.
- To assist with disciplinary procedures as required.
- Where appropriate ensure patient and public involvement within the Data Management Team by working directly with patients, carers, and patient public and carer support groups.
- Establish an effective working relationship with all staff at GP Practice level and within all ICS organisations.
- Liaise with secondary care colleagues where joint products are developed and where data quality issues have been identified and require improvement
Confidentiality and Data Security
- All employees are required to comply fully with the duties and responsibilities outlined in the NHS Information Governance Policy. You are required to preserve the confidentiality of any information regarding patients, staff records in your area (in connection with their employment) and the Trust business and this obligation shall continue in perpetuity.
- You have a responsibility to comply with the Data Protection Act 2018, NHS Confidentiality principles (e.g. Caldicott guidelines) and any code of practice on Confidentiality and Data Protection, as adopted by the ICB. Departmental codes of practice and procedures for confidentiality are available from the head of department.
- In addition you are required to ensure that all information collected, stored and used is done so in compliance with the above Act and any relevant ICB Policy
COMMUNICATION AND WORKING RESPONSIBILITIES
- The post holder will be required to communicate and provide information to a wide range of internal and external stakeholders (see below).
- Support collaborative working across ICBs, NHS Trusts and the wider Health and Social Care system.
- Assist with Freedom of Information requests; keep under review the framework and in accordance with the legislation
Internal
- ICB staff including clinicians, managers, analysts and Information Governance experts
- Nottinghamshire Health Informatics Service (NHIS) staff
External
- Clinicians in primary and secondary care
- NHS Digital staff, both centrally and within their regional Data Services for Commissioners Regional Office (DSCRO) teams
- Commissioning Support Units
- Social Care staff
- Patients, public and carers
Person Specification
Qualifications
Essential
Desirable
- Specialised qualifications
Experience
Essential
- Experience in data management / programming / analytical role
- Complex projects with tight deadlines
Desirable
- NHS experience
- Working with sensitive data
- Report development using web programming
Knowledge
Essential
- SQL
- Problem solving
- Continuing self development
- Communication skills
Desirable
- SSIS
- Data warehousing principles
- IT security
- Data protection / IG
- Flexibility and attitude
Person Specification
Qualifications
Essential
Desirable
- Specialised qualifications
Experience
Essential
- Experience in data management / programming / analytical role
- Complex projects with tight deadlines
Desirable
- NHS experience
- Working with sensitive data
- Report development using web programming
Knowledge
Essential
- SQL
- Problem solving
- Continuing self development
- Communication skills
Desirable
- SSIS
- Data warehousing principles
- IT security
- Data protection / IG
- Flexibility and attitude
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.
Employer details
Employer name
NHS Nottingham and Nottinghamshire Integrated Care Board
Address
Sir John Robinson House
Sir John Robinson Way, Arnold
Nottingham
NG5 6DA
Employer's website
https://notts.icb.nhs.uk/ (Opens in a new tab)
