Deputy Head of Business Intelligence - Service Transformation

Job responsibilities

Main duties continued:

They will lead on all aspects of data gathering, analysis, visualization and presentation for large complex healthcare service transformation programmes (£bn pounds plus) requiring attention to detail, accuracy and speed of response, while being sensitive to differing needs and desires of stakeholders with competing views, lack of clarity and a constantly changing environment.

They must have excellent analytical and presentation skills with substantial experience of developing and presenting complex analytics to very senior managers with clear data driven arguments and a compelling narrative.

They must have a solid understanding of population health management, statistical analysis, correlation, regression; and the ability to set up end to end analytics pipelines to set up and maintain key reporting required for complex service transformation programmes bringing in support from technical experts in the BI team and Programme of Care leads.

Job overview continued:

5. Have a solid understanding of population health management, statistical analysis, correlation, regression; hands on experience of SQL Server SSMS and competence in setting up databases, tables, views, stored procedure, the ability to refine and improve complex legacy scripts within SQL and competence in building reports and dashboards with both Power BI and Tableau

6. Have more than 5 Years hands on experience in an Acute CDS data management with a strong understanding of key datasets across SUS, DLP, ICNARC, Clinical Registries and SitReps with a good understanding of Primary Care, Community and Mental health datasets.

Salary progression Applicants will commence at the bottom of Band 8c with a full-time starting salary of £78,163, with a pay step increase after 5 years service. These salaries are offered in accordance with NHS Terms and Conditions and the HEE Pay Progression Policy and are subject to annual cost of living review. Secondment Applicants from within the NHS will be offered on a secondment basis only,agreement should be obtained from their employer prior to submitting the application

Qualifications

Essential

• Educated to Masters level in Health Informatics, Business Information Systems, Economics, Statistics, Operational research or similar subject OR substantial (5+ years) experience of working within this area.

Knowledge and experience

Essential

• NHS Specialised/Direct Commissioning Services: differences and relationship to ICB commissioned services and strategic direction of travel for devolution
• The NHS LTP: rationale for ICBs and experience of working in collaboration with senior BI, Commissioning, Operation and Clinical leads across Providers, CSUs and STPs and NHSE&I
• Acute and Mental Health Datasets: collection, submission routes and storage systems and processes used across the health system for healthcare commissioning, contract monitoring and planning across A&E, Inpatient, Outpatient, Critical Care, Drugs and Device commissioning
• Acute & MH Health Care Commissioning: NHS England standard contract schedules and the Information schedule in particular, Sch.2B, NTPS Guidance, National Tariff, HRG4+,OPCS, ICD, PSS IR Rules, Mental Health Provider Collaboratives and key changes to acute and mental health commissioning approach
• Substantial experience of using SUS and SLAM/ DLP (non-SUS) specialised commissioning acute and mental health data sets for developing, agreeing and monitoring contract performance positions
• Population Health Management: principles, benefits of, data required, systems and IG requirements needed with some experience of linking data at a person level appropriately across the health system to answer business questions
• Relationship between DoH, National Programmes of Care, NHSX, NHS-D, NHS England & Improvement, Public Health England and the GIRFT team: inter-relationships and how support from each agency can be combined to deliver robust health service transformation
• Sound understanding of the background to and aims of current healthcare policy and appreciate the implications of this on engagement
• Evidence of post qualifying and continuing professional development
• Ability to lead on all aspects of data gathering, analysis, visualization and presentation for large complex healthcare service transformation programmes (£bn pounds plus) requiring attention to detail, accuracy and speed of response, while being sensitive to differing needs and desires of stakeholders with competing views, lack of clarity and a constantly changing environment.
• Excellent analytical and presentation skills with substantial experience of developing and presenting complex analytics to very senior managers with clear data driven arguments and a compelling narrative
• In depth understanding of population health management, statistical analysis, correlation, regression; and the ability to set up end to end analytics pipelines to set up and maintain key reporting required for complex service transformation programmes bringing in support from technical experts in the BI team and Programme of Care leads.
• Ability to work with incomplete data, drawing on content from multiple sources to develop clear arguments, while highlighting any key gaps in data used and potential ways to mitigate against these to answer the question at hand
• A proven track record of senior complex programme management responsibilities, develop and refine business cases and be able to manage a team of staff at varying levels to effectively deliver outputs in line with strict programme delivery deadlines
• Competence in working with senior clinical leads for complex healthcare service transformation programmes translating clinician asks to data analysis tasks and then effectively use their own resources and the multi-disciplinary teams supporting the programme to help deliver against programme tasks
• An in-depth, hands on understanding of the National Tariff Payment System (AKA PbR) rules and guidance and be technically competent in identifying and linking data at a patient level from multiple relevant sources and perform in-depth analysis of relationships, trends and root-causes of trends
• Ability to use analysis to draw key messages and actionable insight, and confidently present to Directors across the health system in order to support key decisions related to health care commissioning and care pathway re-design.
• Substantial experience of using SUS and DLP flowing (non-sus) data sets to understand contracted activity positions and quality, innovation, productivity and prevention opportunities along with a wide range of performance, quality and clinical datasets that flow through systems such as WL MDS, ICNARC, TARN and BADGERNET.

Skills and Capabilities

Essential

• Substantial hands-on experience of using a range of analytical techniques within the NHS context across A&E, Outpatient, Inpatient, Critical Care and Pharmacy settings for commissioning and care delivery purposes
• Sound understanding and competence in relational database systems, database objects and creating, updating and managing Microsoft SQL Server queries, stored procedures, functions, databases, tables, views, facts, dimensions/look-up reference tables, SQL Server Jobs, data import wizard and key SQL Server Management Studio features
• Advance MS Excel user with confidence in cleaning, collating, grouping and analysing complex high volume, multi-variate datasets with the ability to describe summary statistics, and present trends using a range of tools such as tables, charts, graphs and pivots.
• Able to confidently use one or more data visualization/reporting tools such as SSRS, Tableau or PowerBI to present trends, and develop drill-down capability to help answer business questions on key drivers of trends
• Experience of using statistical tools or programming languages such as R or Python OR Excel add-ins for regression analysis and predictive analytics to support business decision making
• Working knowledge of Microsoft Office with intermediate keyboard skills.
• High level of analytical skills and the ability to draw qualitative and quantitative data from a wide range of sources and present key messages and inferences, in a clear concise manner to a non - technical audience through verbal power point presentations and written reports
• Demonstrates sound judgement in the absence of clear data, guidelines or precedent, seeking advice as necessary from more senior colleagues when appropriate to deliver requests
• Ability to develop, maintain and monitor reporting and information systems to support innovation initiatives and a dynamic business environment and changing need
• Member of relevant professional body Communication, Planning, Collaboration
• Able to work together with, and communicate effectively and confidently with Executive team and Directors and operational heads of service, third party data service providers and other technical, clinical and operational colleagues both within the organization and in the wider health system
• Comfortable with receiving clear directions at times, while working using own initiative when needed and managing multiple competing deadlines, prioritising work as necessary and liaising with multiple customers to manage expectations within challenging time frames
• Able to work with multiple third party data and BI service providers, delegating work, leading and monitoring performance of third party suppliers to ensure delivery of requests for data, analysis and improvements to current reports
• Able to identify key individuals within the organisation and across other stakeholder organisations, form working relationships quickly, collaborate as required, to deliver improvements in provider data quality, data reporting and business intelligence and analysis tools that support operational efficiency and delivery of improved services to patients
• Experience of working within a formal project or programme environment with confidence in planning and delivering tasks within project schedules, and requirements
• Ability to identify risks, anticipate issues and propose solutions to resolve problems in relation to project or service delivery
• Ability to provide and receive, convey and present highly complex, sensitive and/or contentious information to large groups

Values and behaviors

Essential

• Commitment to and focused on quality, promotes high standards in all they do
• Able to make a connection between their work and the benefit to patients and the public
• Consistently thinks about how their work can help and support clinicians and frontline staff deliver better outcomes for patients.
• Works well with others, is positive and helpful, listens, involves, respects and learns from the contribution of others.
• Consistently looks to improve what they do, look for successful tried and tested ways of working, and also seeks out innovation
• Actively develops themselves and supports others to do the same.
• Demonstrates honesty and integrity and promotes organisational values.

Equality, diversity and inclusion

Essential

• Will consider the most effective way to promote equality of opportunity and good working relationships in employment and service delivery and has the ability to take actions which support and promote this agenda. Values diversity and difference, operates with integrity and openness. Self-awareness in teams of emotional intelligence, biases and personal triggers with cultural sensitivity and awareness.

Other

Essential

• Ability to change focus between detail and the bigger strategic picture with regard to own role and organisational strategic direction of travel Embrace change, viewing it as an opportunity to learn and develop. Able to work remotely using video conference tools and physically across multiple NHSE sites and health system partners' sites

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).