Job summary The overall purpose of Health Informatics has been defined as to: Enable, promote and support the effective use of data, information, knowledge and technology to support and improve health and health care delivery. Therefore, the role of Informatics is to ensure the organisation has the required Business intelligence and Information Services necessary to provide excellent clinical care to it's service users and to give the organisation accurate and timely information onwhich to base the provision and development of services. The post holder will be responsible for building web applications using both object orientated and low code systems. Post holder should be able to translate Trust and departmental needs into functional and appealing interactive applications. Main duties of the job Use mark-up languages to create user-friendly webapplications.Maintain and improve trust-wide web applications.Optimize applications for maximum speed.Design multiplatform features for those web applications.Collaborate with other developers to improve usability and intergrate applications with other systems.Get feedback from, and build solutions for, various internal stakeholders.Write functional requirement documents and guides.Create quality mock-ups and prototypes. Help database developers with coding and troubleshooting.Ensure high quality graphic standards and data consistency.Stay up-to-date on emerging technologies. About us Hertfordshire Partnership University NHS Foundation Trust (HPFT) is an outstanding organisation with ambitions to match. We are one of just five mental health trusts to achieve an overall rating of 'Outstanding' from the Care Quality Commission, and our aim is to be the leading provider of mental health and specialist learning disability services in the country.Our family of over 3500 members of staff provide health and social care for over 400,000 people with mental ill health, physical ill health and learning disabilities across Hertfordshire, Buckinghamshire, and Norfolk, delivering these services within the community and several inpatient settings. We also deliver a range of nationally commissioned specialist services including Tier 4 services for children and young people, perinatal services, plus medium and low secure learning disabilities services.The care we provide makes a fantastic difference to the lives of our service users, their families and carers - everything is underpinned by choice, independence and equality, with our Trust values embedded throughout:Our Trust values are:Welcoming. Kind. Positive. Respectful. Professional.These values are at the core of who we are, everything we do, and how we do itWould you like to be part of the HPFT family? Would you like work with us to ensure our service users live the fullest lives possible they can? Would you like to be supported in your career to be the best that you can be? Date posted 04 February 2025 Pay scheme Agenda for change Band Band 6 Salary £39,205 to £47,084 a year per annum, pro rata (including 5% HCAS) Contract Permanent Working pattern Full-time Reference number 367-CORP-9138 Job locations Waverley Road 99 Waverley Road St Albans AL3 5TL Job description Job responsibilities Develop and maintain a detailed knowledge of information and operational business processes and how these can support the achievement of agreed targets and objectives. Develop the Trusts information and performance management systems to enable better business decision-making. Present highly complex information regarding the implementation of technical reporting solutions in a clear and understandable format to groups or meetings, including making formal presentations to large groups and/or workshops taking into account the background of the audience. Support the scoping, development and implementation of a BusinessIntelligence tool and associated dashboards. Produce, analyse and interpret highly-complex statistical information (which will frequently be of a contentious nature) to groups of users (both internal and external) in a clear and understandable way. Ensure all information outputs of the Data Warehouse are accurate, fit for purpose, delivered to time and follow the agreed development methodology with full written documentation. Develop and maintain a detailed knowledge of information and operational business processes and how these can support the achievement of agreed targets and objectives. Develop the Trusts information and performance management systems to enable better business decision-making. Present highly complex information regarding the implementation of technical reporting solutions in a clear and understandable format to groups or meetings, including making formal presentations to large groups and/or workshops. Produce, analyse and interpret highly-complex statistical information togroups of users (both internal and external) in a clear and understandable way. Design, code, test and implement efficient and robust database schemas plus SQL Queries, Views, Stored Procedures, and Triggers as part of datawarehouse development. Build user friendly web applications for data collection using low code software. Embrace innovation and explore new technologies to enhance processes where improvements are possible. Job description Job responsibilities Develop and maintain a detailed knowledge of information and operational business processes and how these can support the achievement of agreed targets and objectives. Develop the Trusts information and performance management systems to enable better business decision-making. Present highly complex information regarding the implementation of technical reporting solutions in a clear and understandable format to groups or meetings, including making formal presentations to large groups and/or workshops taking into account the background of the audience. Support the scoping, development and implementation of a BusinessIntelligence tool and associated dashboards. Produce, analyse and interpret highly-complex statistical information (which will frequently be of a contentious nature) to groups of users (both internal and external) in a clear and understandable way. Ensure all information outputs of the Data Warehouse are accurate, fit for purpose, delivered to time and follow the agreed development methodology with full written documentation. Develop and maintain a detailed knowledge of information and operational business processes and how these can support the achievement of agreed targets and objectives. Develop the Trusts information and performance management systems to enable better business decision-making. Present highly complex information regarding the implementation of technical reporting solutions in a clear and understandable format to groups or meetings, including making formal presentations to large groups and/or workshops. Produce, analyse and interpret highly-complex statistical information togroups of users (both internal and external) in a clear and understandable way. Design, code, test and implement efficient and robust database schemas plus SQL Queries, Views, Stored Procedures, and Triggers as part of datawarehouse development. Build user friendly web applications for data collection using low code software. Embrace innovation and explore new technologies to enhance processes where improvements are possible. Person Specification Education, Knowledge, and Experience Essential Educated to degree level in a computer related discipline, or equivalent work experience in software development Evidence of substantial software development experience in the full software development lifecycle Knowledge and experience of Information Governance - information security management, GDPR, and Freedom of Information Act. Desirable Evidence of working in a data warehouse environment Development of web based front ends that interact with databases such as Microsoft SQL Server Experience creating web applications for data capture (Power Platform) Experience within a broad and complex corporate IT operational environment. Understanding of the information needs of operational staff at all levels within organisations and experience of working across-organisation Boundaries Experience of manipulating complex data to produce automated reports. Understanding of reporting layers that negate the need to rewrite complex scripts whenever there is a change to the data warehouse structure Knowledge/experience of Mental Health Services Skills and Aptitudes Essential A logical approach to investigating, analysing and resolving data and programming problems. Detailed knowledge of relational database design and implementation (e.g. Microsoft SQL Server, Oracle, Dataverse) An understanding of how applications/systems can integrate using REST APIs. Desirable Knowledge of low code application development using MS Power Platform Experience with SQL Server Reporting Services (SSRS) or Power BI. Proficient database management and querying skills with a proven ability to write stored procedures, functions and triggers. Robust system and unit testing experience, producing relevant test documentation. Knowledge of medical information systems, particularly patient administration and clinical management systems System development quality assurance and best practice Knowledge of data privacy laws and in particular NHS IM&T policies and procedures. Skills for managing relationships with a range of different stakeholders Excellent computing keyboard skills and proven experience in using different software development tools Work experience as a web developer Significant experience with HTML, TypeScript/JavaScript, and CSS Familiarity with browser testing and debugging. Understanding of the entire web development process (design, development and deployment ). In depth knowledge of Java Experience with Microsoft Power Platform (Especially: Canvas Apps, Dataverse & Power Automate Cloud Flows ). Communications Skills Essential Communication of complex information to users at all levels of the organisation, and with external clients, suppliers and vendors. Negotiate on difficult and detailed issues with the ability to communicate technical information clearly at a level understandable by the audience. Desirable Maintains productive relationships with different parties, to understand the software development needs of the Trust. To provide support and training to team members to develop their skills and knowledge Person Specification Education, Knowledge, and Experience Essential Educated to degree level in a computer related discipline, or equivalent work experience in software development Evidence of substantial software development experience in the full software development lifecycle Knowledge and experience of Information Governance - information security management, GDPR, and Freedom of Information Act. Desirable Evidence of working in a data warehouse environment Development of web based front ends that interact with databases such as Microsoft SQL Server Experience creating web applications for data capture (Power Platform) Experience within a broad and complex corporate IT operational environment. Understanding of the information needs of operational staff at all levels within organisations and experience of working across-organisation Boundaries Experience of manipulating complex data to produce automated reports. Understanding of reporting layers that negate the need to rewrite complex scripts whenever there is a change to the data warehouse structure Knowledge/experience of Mental Health Services Skills and Aptitudes Essential A logical approach to investigating, analysing and resolving data and programming problems. Detailed knowledge of relational database design and implementation (e.g. Microsoft SQL Server, Oracle, Dataverse) An understanding of how applications/systems can integrate using REST APIs. Desirable Knowledge of low code application development using MS Power Platform Experience with SQL Server Reporting Services (SSRS) or Power BI. Proficient database management and querying skills with a proven ability to write stored procedures, functions and triggers. Robust system and unit testing experience, producing relevant test documentation. Knowledge of medical information systems, particularly patient administration and clinical management systems System development quality assurance and best practice Knowledge of data privacy laws and in particular NHS IM&T policies and procedures. Skills for managing relationships with a range of different stakeholders Excellent computing keyboard skills and proven experience in using different software development tools Work experience as a web developer Significant experience with HTML, TypeScript/JavaScript, and CSS Familiarity with browser testing and debugging. Understanding of the entire web development process (design, development and deployment ). In depth knowledge of Java Experience with Microsoft Power Platform (Especially: Canvas Apps, Dataverse & Power Automate Cloud Flows ). Communications Skills Essential Communication of complex information to users at all levels of the organisation, and with external clients, suppliers and vendors. Negotiate on difficult and detailed issues with the ability to communicate technical information clearly at a level understandable by the audience. Desirable Maintains productive relationships with different parties, to understand the software development needs of the Trust. To provide support and training to team members to develop their skills and knowledge 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. Certificate of Sponsorship 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. Certificate of Sponsorship 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). Employer details Employer name Hertfordshire Partnership University NHS Foundation Trust Address Waverley Road 99 Waverley Road St Albans AL3 5TL Employer's website https://www.hpft.nhs.uk/careers/ (Opens in a new tab)