Job summary The post holder will provide a data modelling and visual analytics function delivering well designed and innovative products, such as dashboards and reports, built upon Microsoft Azure and Power BI Platform, delivering outputs using data visualisation methodologies to convey key messages to the products users. Each product developed will need both user and technical documentation, including the completion of design templates, change control requests, testing plans and results. Main duties of the job The post holder will provide a data modelling and visual analytics function, delivering well designed and innovative products, such as dashboards and reports, built upon Microsoft Azure and Power BI Platform, and delivering outputs using data visualisation methodologies to convey key messages to the products users. Each product developed will need both user and technical documentation, including the completion of design templates, change control requests, testing plans and results. Flexible working: As one of the few Trusts in London we are proud to offer flexible working as part of our new ways of working, and we are happy to talk flexible working at the interview stage. In this role you will be able to work Monday to Friday in the time frames from 8am to 6pm, giving you the very best of good work life balance. About us About the team: The informatics team is split into two areas, data delivery and requirements & engagement. These teams work together to deliver against our service model to the organisation. We work in an environment of collaboration, and whilst we endeavour to deliver information in a right the first-time environment, we have also created the space for teams and individuals to test out new technologies or interest projects within ring-fenced time - often in collaboration with external consultancies who support and encourage learning within the team. About the location: The Digital Services Informatics team is based at Jeanette Wallace House, in-between Bromley and Croydon (CR0 1FE) Our Trust headquarters is located at Denmark Hill less than 5 minutes from the train station (zone 2). We also provide services and operate across other locations, such as London boroughs of Croydon, Lambeth, Lewisham and Southwark; and substance misuse services for residents of Bexley, Lambeth, Greenwich and Wandsworth. Date posted 12 February 2025 Pay scheme Agenda for change Band Band 7 Salary £51,883 to £58,544 a year per annum inclusive of HCAS Contract Permanent Working pattern Full-time Reference number 334-NCL-6954303-TA Job locations Jeanette Wallace House 1 Edridge Rd Croydon CR0 1FE Job description Job responsibilities Ensure reports and dashboards are designed to a high standard using latest data visualisation methodologies and can be used in a self-service environment. Provide a high level of documentation which underpins the on-going success of the Technical Intelligence service. This includes internal technical documents but also friendly business user focused documentation. Participate or lead projects ensuring they are aligned to the key organisational objectives of the Trust, providing options and recommendations to support those objectives. Ensure that all new developments and amendments follow the change control process. This requires rigorous testing procedures and detailed impact analysis. To work with clinicians and service managers to undertake analysis of business/care delivery processes, advising on how these might be changed or refined to improve their efficiency, and how such changes would be enabled by the appropriate use of information systems and communications technology. Participate or lead on the development of data quality monitoring tools and techniques to support the accurate reporting of all internal and external reports and lead on the development of reporting from the Trust's data warehouse. Presenting of highly complex information to a wide range of stakeholders. This includes dealing with complex ad hoc queries and where necessary making solutions accessible and available trust wide. Supporting research and development by using specialist research methods. This may include the management of discrete projects. The post holder will lead in the provision of customer support, interfacing and maintaining business and supplier relationships. Lead and manage a small focused team to ensure delivery of reports, dashboards and other similar products against an agreed schedule. Ensure that report writers and dashboard developers adhere to the policies and procedures of the Technical Intelligence Department, Digital Services, Trust and are supervised accordingly. Job description Job responsibilities Ensure reports and dashboards are designed to a high standard using latest data visualisation methodologies and can be used in a self-service environment. Provide a high level of documentation which underpins the on-going success of the Technical Intelligence service. This includes internal technical documents but also friendly business user focused documentation. Participate or lead projects ensuring they are aligned to the key organisational objectives of the Trust, providing options and recommendations to support those objectives. Ensure that all new developments and amendments follow the change control process. This requires rigorous testing procedures and detailed impact analysis. To work with clinicians and service managers to undertake analysis of business/care delivery processes, advising on how these might be changed or refined to improve their efficiency, and how such changes would be enabled by the appropriate use of information systems and communications technology. Participate or lead on the development of data quality monitoring tools and techniques to support the accurate reporting of all internal and external reports and lead on the development of reporting from the Trust's data warehouse. Presenting of highly complex information to a wide range of stakeholders. This includes dealing with complex ad hoc queries and where necessary making solutions accessible and available trust wide. Supporting research and development by using specialist research methods. This may include the management of discrete projects. The post holder will lead in the provision of customer support, interfacing and maintaining business and supplier relationships. Lead and manage a small focused team to ensure delivery of reports, dashboards and other similar products against an agreed schedule. Ensure that report writers and dashboard developers adhere to the policies and procedures of the Technical Intelligence Department, Digital Services, Trust and are supervised accordingly. Person Specification Qualifications Essential Educated to Degree level or equivalent experience Evidence of professional/managerial development Desirable Higher post-graduate education in a relevant subject Relevant Professional qualifications Knowledge and Skills Essential Extensive experience in developing data models and reports in Microsoft SQL Server (SSIS/SSRS/SSAS/T-SQL) or Microsoft Power BI to meet the business needs of the organisation Highly developed specialist reporting knowledge underpinned by theory and experience Knowledge of project based and continuous Dev-Ops approaches Evidence of change management practices The facilitation of a customer focussed culture within a team Excellent written, verbal, and other media communications /Presentation skills A logical and sensible approach to problem solving Ability to organise and prioritise their workload, and be able to work under pressure To analyse and apply user information to problem solving Ability to express complex issues, both orally and in writing in an easily understood manner for a range of audiences Negotiation, influencing and persuading skills Pro-active and self-motivated in completing work to a high standard in conjunction with other staff Excellent team skills and ability to work with members of own and other teams and departments at all levels of the organisation. Desirable Experience of developing data pipelines using Microsoft Azure Data Factory, PolyBase and Synapse Understand quality improvement concepts such as Statistical Process Control Prince 2, Agile or other Project Management methodologies Use of ITIL in a work environment Knowledge of mental health services Person Specification Qualifications Essential Educated to Degree level or equivalent experience Evidence of professional/managerial development Desirable Higher post-graduate education in a relevant subject Relevant Professional qualifications Knowledge and Skills Essential Extensive experience in developing data models and reports in Microsoft SQL Server (SSIS/SSRS/SSAS/T-SQL) or Microsoft Power BI to meet the business needs of the organisation Highly developed specialist reporting knowledge underpinned by theory and experience Knowledge of project based and continuous Dev-Ops approaches Evidence of change management practices The facilitation of a customer focussed culture within a team Excellent written, verbal, and other media communications /Presentation skills A logical and sensible approach to problem solving Ability to organise and prioritise their workload, and be able to work under pressure To analyse and apply user information to problem solving Ability to express complex issues, both orally and in writing in an easily understood manner for a range of audiences Negotiation, influencing and persuading skills Pro-active and self-motivated in completing work to a high standard in conjunction with other staff Excellent team skills and ability to work with members of own and other teams and departments at all levels of the organisation. Desirable Experience of developing data pipelines using Microsoft Azure Data Factory, PolyBase and Synapse Understand quality improvement concepts such as Statistical Process Control Prince 2, Agile or other Project Management methodologies Use of ITIL in a work environment Knowledge of mental health services 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 South London and Maudsley NHS Foundation Trust Address Jeanette Wallace House 1 Edridge Rd Croydon CR0 1FE Employer's website https://www.slam.nhs.uk/ (Opens in a new tab)