Job summary An opportunity has arisen with the Trusts Information Department, and we are looking to recruit a talented, motivation individual to the role of an Information Analyst. The Information Team plays an essential role in the provision of high-quality information for performance and operational management, business intelligence, strategic planning, and patient care. Core requirements of the role will include responsibility for producing and submitting a range of datasets, returns and reports to meet a range of national requirements and performance measures within the organisation as well as responding to ad-hoc requests in a timely manner.Are you someone who has excellent interpersonal skills, is an independent thinker and exceptional analytical skills? We are looking for someone who can understand and discuss an issue, investigate, and aggregate data from a wide range of sources (both internally and externally) analyse the data, and then communicate findings to a range of different audiences succinctly and confidently. The successful candidate must be a good team player, who can manage their own workload and work to deadlines successfully. The candidate will also be an experienced analyst with experience of Microsoft Products especially Excel, T-SQL, Power BI and SSRS.The Information Services team is based at Beacon House in Scunthorpe, however the team run a hybrid of in the office and working from home. Main duties of the job An opportunity has arisen with the Trusts Information Department and we are looking to recruit a talented, motivation individual to the role of an Information Analyst.The Information Team plays an essential role in the provision of high-quality information for performance and operational management, business intelligence, strategic planning and patient care. Examples of some core requirements of the role will include responsibility for producing and submitting a range of datasets, returns and reports to meet a range of national requirements including facilitating the monitoring of performance indicators within the organisation, mortality reporting as well as responding to ad-hoc requests in a timely manner.Are you someone who has excellent interpersonal skills, is an independent thinker and exceptional analytical skills? We are looking for someone who can understand and discuss an issue, investigate, and aggregate data from a wide range of sources (both internally and externally) analyse the data, and then communicate findings to a range of different audiences succinctly and confidently.The successful candidate will be a good team player, who can manage their own workload and work to deadlines successfully. The candidate will also be an experienced analyst with experience of Microsoft Products, especially Excel, T-SQL, Power BI, DAX, and SSRS. About us NLAG is part of one of the largest acute and community Group arrangements in the NHS, seeing well over one million patients every year and managing a budget of over £1.3 billion. Made up of two Trusts - Northern Lincolnshire and Goole NHS Foundation Trust (NLAG) and Hull University Teaching Hospitals NHS Trust (HUTH) - our Group has significant ambitions and is committed to delivering world-class hospital and community services for the 1.65 million people we serve. Together we employ nearly 20,000 staff. Our five main hospital sites are Diana, Princess of Wales Hospital, Scunthorpe General Hospital and Goole and District Hospital, for NLAG and Hull Royal Infirmary and Castle Hill Hospital for HUTH. As Teaching Hospitals working with the Hull York Medical School, we both lead and contribute to research in many areas - biomedical research, primary care, palliative medicine, cardiovascular and respiratory medicine, vascular surgery, cancer surgery and oncology. We believe that by developing a diverse, inclusive, innovative, skilled and caring workforce, we can deliver excellent care to our patients and a great future for our employees, our Group and our community. Should we receive a high volume of applications the advert may be closed earlier than stated. Date posted 05 November 2024 Pay scheme Agenda for change Band Band 5 Salary £29,970 to £36,483 a year pro rata Contract Permanent Working pattern Full-time Reference number 208-988E22-24-1 Job locations Scunthorpe Beacon House, Ridge Way Scunthorpe DN15 7BH Job description Job responsibilities The main duties as laid out in the job description: Present monthly reports to the Trust Board allowing them to monitor against Trust goals and targets, which will monitor Service Level Agreements with local Commissioners. Provide subset of the monthly board reports, producing and communicating this information quickly and accurately at all levels. Attend and represent the team in a confident manner at relevant internal and external meetings, frequently dealing with reactions from managers when reports delivered differ from the managers expectations and understand their differing points of view. Deliver presentations to groups promoting an information and data quality culture or work on a project that has been worked on. Collate and complete accurate and timely information for the Trusts statutory performance returns e.g., Department of Health, NHS England, and Commissioners, negotiating mutually acceptable reporting timescales where appropriate. Respond to any information related queries arising from the submissions using own problem-solving skills and expertise. Communicate effectively with the customer in interpreting the complex and patient-sensitive information thus ensuring the user fully understands and overcomes any lack of understanding and is confident with the information, its limitations, and key messages. Develop and provide reports demonstrating the Trusts Performance for external agencies to assess and ensure the Trust adheres to government targets. Produce regular outpatient/inpatient waiting list reports to Senior Management allowing them to manage the waiting list, ensuring targets are met and potential breaches are identified at the earliest opportunity. Collate the Trusts weekly 18 week wait position for submission to the Department of Health via the UNIFY web-based data collection tool. Produce the Trust monthly data file submissions to the Secondary Users Services (SUS) and agreed datasets to the local Data Services for Commissioners Regional Offices DSCROs in line with National Submissions timetable. Produce accurate Trust Activity and Performance Reports by correctly interpreting a users requirements and advising them on what information would best suit their purpose. Analyse complex and patient sensitive data to show Trust trends and identify and highlight any areas of significance. Investigate any outlying areas using own initiative. Provide monthly outpatient/inpatient activity reports to allow the Trusts Finance & Performance department to obtain income via payment by Results process using complex data/trend analysis and presentation skills. Provide and interpret information to support planning processes across Operational Groups and Strategy & Planning, which will monitor any savings and future service investments. Respond to ad-hoc requests for information as directed. Advise the person making the request as to the best way to provide the information. Utilise available technologies and software to present the information in an appropriate format. Work closely with Business Managers to ensure accuracy when reporting and highlight any data quality issues in relation to data held on the Source Systems and monitor to ensure action is taken to rectify. Analyse complex and patient sensitive data to show Trust trends and identify and highlight any areas of significance. Investigate any outlying areas using own initiative. Develop, automate, and maintain regular performance reports in line with user requirements utilising all available technologies and data analysis tools to bring together the various complex and different information elements. Provide collated summarised, complex information to enable Internal and External Audits and National Patient Surveys on a regular basis. Pull together consultant activity information for the Medical Director to support the Consultant Appraisal Process. Use own judgement to make decisions and recommendations on reported performance, where there are any data shortfalls or potential inadequacies with the data, to ensure an accurate picture as possible, is reported. Document all assumptions for audit purposes. Prioritise, manage, and plan own workload to ensure the Trusts returns meet daily, weekly, monthly, quarterly, and annual reporting deadlines. Responsible for any work undertaken by the Trainee Analyst, including providing training and support, setting work packages and timescales for checking and signing off completed work. Responsible for the creation and implementation of documented procedures for undertaking information tasks. Whilst carrying out day-to-day duties recommend service improvements relating to information issues, which affect other Directorates as well as own. Whilst carrying out reporting, identify and investigate inconsistencies in data to improve data quality, which will enhance Trust performance. Provide support, training, and guidance to other Information staff on areas of expertise such as database concepts and reporting and analysis methods. Develop a sound and effective working relationship with the Trusts Operational Groups, other internal departments, and key external organisations i.e., NHS Digital, NHS England, and local Commissioning Groups. In conjunction with the Development Team identify areas requiring integration and automation and assist in the development and implementation of the chosen solution. Become involved with and contribute to Business Intelligence solutions to reporting issues. Regularly design and develop a range of information systems required to produce reports for others. Maintain complete confidentiality of sensitive information relating to patients and other members of staff in line with Caldicott and Data Protection. Work with the Development Team and other departments within the Trust to implement data collection processes and reporting introduced through either Data Set Change Notices (ISNs) or local requirements from contracting arrangements. To provide other functions appropriate to the grade and role. Provide comparative performance analysis with benchmarking to various target audiences i.e., Operational Groups, Consultants. For more detailed information, please read the job description linked below. As a Trust we are keen to offer and encourage flexible working opportunities to address health and wellbeing and work-life balance for our employees, this will have a positive impact on the care we provide. Flexible working is part of a wider commitment to improve the quality and experience of working life and we recognise that it is a key contributor for the recruitment and retention of our employees. We therefore support and encourage open conversations around a specific working pattern to suit your work-life balance or a multi-role career, if it works for you and works for the role, we'll do our best to make it happen. Local flexible working arrangements are developed in partnership between the line manager and employee in order to ensure equality of access to flexible working, as far as practicable, regardless of role, shift pattern, team or pay, based on: patient/service user and staff experience, service delivery and work-life balance of colleagues. We are committed to creating and maintaining a fair and supportive working environment and culture, where contributions are fully recognised and valued by all and staff feel empowered to carry out their duties to the best of their abilities. As employers we are committed to promoting and protecting the physical and mental health and well-being of all our staff. This underpins our values as set out in the NHS Constitution, supports us to be an Employer of Choice and ultimately enables our employees to support the effective care of our patients. We strongly value the different perspectives and ideas a diverse workforce brings to deliver better outcomes for our patients. We welcome applications irrespective of peoples age, disability, sex, gender identity and gender expression, race or ethnicity, religion or belief, sexual orientation, or other personal circumstances. To learn more about Northern Lincolnshire and Goole NHS Foundation Trust, and discover the unique benefits on offer to employees, view our latest videos, plus more, please visit our recruitment website at https://joinnlag.co.uk/ In line with the General Data Protection Regulation (GDPR), the Recruitment & Workforce team will use and hold your personal data for the intended purpose and in line with the Recruitment & Workforce Privacy Statement. We are committed to safeguarding the welfare of children/vulnerable adults and expect the same commitment from all staff and volunteers. Please be aware that all new employees starting work with us will be charged for the cost of their DBS check, if it is required for their role. Job description Job responsibilities The main duties as laid out in the job description: Present monthly reports to the Trust Board allowing them to monitor against Trust goals and targets, which will monitor Service Level Agreements with local Commissioners. Provide subset of the monthly board reports, producing and communicating this information quickly and accurately at all levels. Attend and represent the team in a confident manner at relevant internal and external meetings, frequently dealing with reactions from managers when reports delivered differ from the managers expectations and understand their differing points of view. Deliver presentations to groups promoting an information and data quality culture or work on a project that has been worked on. Collate and complete accurate and timely information for the Trusts statutory performance returns e.g., Department of Health, NHS England, and Commissioners, negotiating mutually acceptable reporting timescales where appropriate. Respond to any information related queries arising from the submissions using own problem-solving skills and expertise. Communicate effectively with the customer in interpreting the complex and patient-sensitive information thus ensuring the user fully understands and overcomes any lack of understanding and is confident with the information, its limitations, and key messages. Develop and provide reports demonstrating the Trusts Performance for external agencies to assess and ensure the Trust adheres to government targets. Produce regular outpatient/inpatient waiting list reports to Senior Management allowing them to manage the waiting list, ensuring targets are met and potential breaches are identified at the earliest opportunity. Collate the Trusts weekly 18 week wait position for submission to the Department of Health via the UNIFY web-based data collection tool. Produce the Trust monthly data file submissions to the Secondary Users Services (SUS) and agreed datasets to the local Data Services for Commissioners Regional Offices DSCROs in line with National Submissions timetable. Produce accurate Trust Activity and Performance Reports by correctly interpreting a users requirements and advising them on what information would best suit their purpose. Analyse complex and patient sensitive data to show Trust trends and identify and highlight any areas of significance. Investigate any outlying areas using own initiative. Provide monthly outpatient/inpatient activity reports to allow the Trusts Finance & Performance department to obtain income via payment by Results process using complex data/trend analysis and presentation skills. Provide and interpret information to support planning processes across Operational Groups and Strategy & Planning, which will monitor any savings and future service investments. Respond to ad-hoc requests for information as directed. Advise the person making the request as to the best way to provide the information. Utilise available technologies and software to present the information in an appropriate format. Work closely with Business Managers to ensure accuracy when reporting and highlight any data quality issues in relation to data held on the Source Systems and monitor to ensure action is taken to rectify. Analyse complex and patient sensitive data to show Trust trends and identify and highlight any areas of significance. Investigate any outlying areas using own initiative. Develop, automate, and maintain regular performance reports in line with user requirements utilising all available technologies and data analysis tools to bring together the various complex and different information elements. Provide collated summarised, complex information to enable Internal and External Audits and National Patient Surveys on a regular basis. Pull together consultant activity information for the Medical Director to support the Consultant Appraisal Process. Use own judgement to make decisions and recommendations on reported performance, where there are any data shortfalls or potential inadequacies with the data, to ensure an accurate picture as possible, is reported. Document all assumptions for audit purposes. Prioritise, manage, and plan own workload to ensure the Trusts returns meet daily, weekly, monthly, quarterly, and annual reporting deadlines. Responsible for any work undertaken by the Trainee Analyst, including providing training and support, setting work packages and timescales for checking and signing off completed work. Responsible for the creation and implementation of documented procedures for undertaking information tasks. Whilst carrying out day-to-day duties recommend service improvements relating to information issues, which affect other Directorates as well as own. Whilst carrying out reporting, identify and investigate inconsistencies in data to improve data quality, which will enhance Trust performance. Provide support, training, and guidance to other Information staff on areas of expertise such as database concepts and reporting and analysis methods. Develop a sound and effective working relationship with the Trusts Operational Groups, other internal departments, and key external organisations i.e., NHS Digital, NHS England, and local Commissioning Groups. In conjunction with the Development Team identify areas requiring integration and automation and assist in the development and implementation of the chosen solution. Become involved with and contribute to Business Intelligence solutions to reporting issues. Regularly design and develop a range of information systems required to produce reports for others. Maintain complete confidentiality of sensitive information relating to patients and other members of staff in line with Caldicott and Data Protection. Work with the Development Team and other departments within the Trust to implement data collection processes and reporting introduced through either Data Set Change Notices (ISNs) or local requirements from contracting arrangements. To provide other functions appropriate to the grade and role. Provide comparative performance analysis with benchmarking to various target audiences i.e., Operational Groups, Consultants. For more detailed information, please read the job description linked below. As a Trust we are keen to offer and encourage flexible working opportunities to address health and wellbeing and work-life balance for our employees, this will have a positive impact on the care we provide. Flexible working is part of a wider commitment to improve the quality and experience of working life and we recognise that it is a key contributor for the recruitment and retention of our employees. We therefore support and encourage open conversations around a specific working pattern to suit your work-life balance or a multi-role career, if it works for you and works for the role, we'll do our best to make it happen. Local flexible working arrangements are developed in partnership between the line manager and employee in order to ensure equality of access to flexible working, as far as practicable, regardless of role, shift pattern, team or pay, based on: patient/service user and staff experience, service delivery and work-life balance of colleagues. We are committed to creating and maintaining a fair and supportive working environment and culture, where contributions are fully recognised and valued by all and staff feel empowered to carry out their duties to the best of their abilities. As employers we are committed to promoting and protecting the physical and mental health and well-being of all our staff. This underpins our values as set out in the NHS Constitution, supports us to be an Employer of Choice and ultimately enables our employees to support the effective care of our patients. We strongly value the different perspectives and ideas a diverse workforce brings to deliver better outcomes for our patients. We welcome applications irrespective of peoples age, disability, sex, gender identity and gender expression, race or ethnicity, religion or belief, sexual orientation, or other personal circumstances. To learn more about Northern Lincolnshire and Goole NHS Foundation Trust, and discover the unique benefits on offer to employees, view our latest videos, plus more, please visit our recruitment website at https://joinnlag.co.uk/ In line with the General Data Protection Regulation (GDPR), the Recruitment & Workforce team will use and hold your personal data for the intended purpose and in line with the Recruitment & Workforce Privacy Statement. We are committed to safeguarding the welfare of children/vulnerable adults and expect the same commitment from all staff and volunteers. Please be aware that all new employees starting work with us will be charged for the cost of their DBS check, if it is required for their role. Person Specification Education, Experience, and Qualifications Essential Degree level qualification or equivalent experience in an Information/Performance role Desirable Good level of general education 3 A Levels Grades A to C or equivalent A degree in an appropriate discipline Recognised professional IM&T qualification or working towards Occupational Experience and abilities Essential Good knowledge and experience in using SQL, Power BI and DAX or similar products Advanced numeric skills, good knowledge and experience of Analytical and Statistical Techniques Minimum of 3 years' practical working experience in an Information Analyst role Good ability to analyse, summarise, interpret, and present information Desirable Good Knowledge and Experience in using SSRS NHS knowledge and experience (Preferably 2 year's within the NHS) Pro-active and able to identify opportunities for improvement Evidence of on-going personal career development Personal Qualities Essential Attendance to detail Excellent communication skills Desirable Excellent interpersonal skills with an ability to work as part of a team as well as alone Excellent time management and organisational skills Person Specification Education, Experience, and Qualifications Essential Degree level qualification or equivalent experience in an Information/Performance role Desirable Good level of general education 3 A Levels Grades A to C or equivalent A degree in an appropriate discipline Recognised professional IM&T qualification or working towards Occupational Experience and abilities Essential Good knowledge and experience in using SQL, Power BI and DAX or similar products Advanced numeric skills, good knowledge and experience of Analytical and Statistical Techniques Minimum of 3 years' practical working experience in an Information Analyst role Good ability to analyse, summarise, interpret, and present information Desirable Good Knowledge and Experience in using SSRS NHS knowledge and experience (Preferably 2 year's within the NHS) Pro-active and able to identify opportunities for improvement Evidence of on-going personal career development Personal Qualities Essential Attendance to detail Excellent communication skills Desirable Excellent interpersonal skills with an ability to work as part of a team as well as alone Excellent time management and organisational skills 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 Northern Lincolnshire and Goole NHS Foundation Trust Address Scunthorpe Beacon House, Ridge Way Scunthorpe DN15 7BH Employer's website https://www.nlg.nhs.uk/ (Opens in a new tab)