Population Health Data Analyst

The Population Health Management (PHM) team is a system-supported programme working across Lewisham in collaboration with local health and care partners. The programme uses data and analytics to understand the health and care needs of the population, identify inequalities and unwarranted variation, and support improvements in health outcomes and service delivery.

The team is building on a newly developed Snowflake data environment, currently in the early stages of release, bringing together integrated health and care datasets into a unified analytical environment. This will support a more comprehensive understanding of population health and enable the development of new analytical tools, metrics and approaches.

The Population Health Data Analyst will contribute to the development and use of this environment, including scripting, querying, developing metrics and supporting the integration and analysis of health and care data.

The analytics workstream within the Population Health Programme supports clinicians, commissioners and programme managers to use data to understand population needs, identify opportunities for improvement and inform decision-making.

• Strong experience of working with health and/or social care data across multiple sources.
• Experience of analysing and interpreting complex health and care data.
• Strong analytical and programming skills, particularly SQL and Snowflake, with experience of Power BI.
• Experience of developing metrics, queries and analytical products.
• Experience of working with integrated health and care datasets.
• Experience of supporting population health, neighbourhood health, proactive case finding or service improvement would be advantageous.
• Understanding of health inequalities and the importance of using data to identify and address inequalities.
• Excellent communication skills, with experience of communicating complex information to clinicians, commissioners, programme managers and other non-technical audiences.
• Understanding of information governance, data quality and the importance of using the right data appropriately.
• Ability to work autonomously, prioritise workloads and manage competing demands.
• A data-led and creative approach to problem solving, with the ability to develop practical analytical solutions to complex questions.

Our people are our greatest asset. When we feel supported and happy at work, this positivity reaches those very people we are here for, the patients. Engaged employees perform at their best and our Equality, Diversity & Inclusion (EDI) initiatives contribute to cultivate a culture of engagement. We have four staff networks, a corporate EDI Team and a suite of programmes and events which aim to insert the 5 aspirations:

• Improving representation at senior levels of staff with disabilities, from black, Asian, and ethnic minorities background, identify as LGBTQ+ and women, through improved recruitment and leadership development
• Widening access (anchor institution) and employability
• Improving the experience of staff with disability
• Improving the EDI literacy and confidence of trust staff through training and development
• Making equalities mainstream

Key Result Areas & Performance

• Work with the Principal Population Health Analyst and Portfolio Manager to deliver the Population Health Analytics work programme.
• Provide analytical support to Integrated Neighbourhood Teams, initially focusing on long-term conditions, frailty and pharmacy.
• Develop and maintain analytical solutions within the Snowflake environment, including SQL queries, scripting and population health metrics.
• Support the development of integrated health and care datasets and reusable analytical products.
• Develop and scope enhanced risk tools to support proactive case finding and preventative care.
• Support primary care practices with population monitoring and data-led improvement.
• Provide analytical support to MDM meetings and other clinical and care teams.
• Support the design, monitoring and evaluation of data-led interventions.
• Undertake analytical work for acute trust improvement projects and other service transformation programmes.
• Support basic costing and ROI analysis where required.
• Ensure health inequalities are considered within population health analysis and outputs.
• Ensure appropriate data security, information governance and data quality standards are maintained.

Workforce

• Work collaboratively with analysts, data engineers, clinical colleagues and programme teams.
• Provide peer support and guidance on analytical approaches, data interpretation and population health products.
• Share knowledge and contribute to the development of analytical capability across the programme.

Communications and Relationships

The post holder will work closely with clinicians, commissioners, programme managers, primary care teams, Integrated Neighbourhood Teams, acute trust colleagues, analysts, data engineers and the AI Data Centre at GSTT.

• Communicate complex analytical information clearly to technical and non-technical audiences.
• Work with stakeholders to understand their key questions and translate these into appropriate analytical approaches.
• Explain data quality, limitations and the importance of using the right data for the right purpose.
• Develop effective relationships with clinical and programme teams to ensure analytics are relevant and actionable.
• Promote a data-led approach to decision-making while recognising the importance of clinical and professional expertise.
• Use creative thinking to develop practical solutions to new and complex analytical requirements.

Key Result Areas & Performance

• Work with the Principal Population Health Analyst and Portfolio Manager to deliver the Population Health Analytics work programme.
• Provide analytical support to Integrated Neighbourhood Teams, initially focusing on long-term conditions, frailty and pharmacy.
• Develop and maintain analytical solutions within the Snowflake environment, including SQL queries, scripting and population health metrics.
• Support the development of integrated health and care datasets and reusable analytical products.
• Develop and scope enhanced risk tools to support proactive case finding and preventative care.
• Support primary care practices with population monitoring and data-led improvement.
• Provide analytical support to MDM meetings and other clinical and care teams.
• Support the design, monitoring and evaluation of data-led interventions.
• Undertake analytical work for acute trust improvement projects and other service transformation programmes.
• Support basic costing and ROI analysis where required.
• Ensure health inequalities are considered within population health analysis and outputs.
• Ensure appropriate data security, information governance and data quality standards are maintained.

Workforce

• Work collaboratively with analysts, data engineers, clinical colleagues and programme teams.
• Provide peer support and guidance on analytical approaches, data interpretation and population health products.
• Share knowledge and contribute to the development of analytical capability across the programme.

Communications and Relationships

The post holder will work closely with clinicians, commissioners, programme managers, primary care teams, Integrated Neighbourhood Teams, acute trust colleagues, analysts, data engineers and the AI Data Centre at GSTT.

• Communicate complex analytical information clearly to technical and non-technical audiences.
• Work with stakeholders to understand their key questions and translate these into appropriate analytical approaches.
• Explain data quality, limitations and the importance of using the right data for the right purpose.
• Develop effective relationships with clinical and programme teams to ensure analytics are relevant and actionable.
• Promote a data-led approach to decision-making while recognising the importance of clinical and professional expertise.
• Use creative thinking to develop practical solutions to new and complex analytical requirements.

Qualifications and Training

• Educated to master's level or equivalent relevant experience
• Qualification in a numerate discipline
• Evidence of continuing professional development

• Experience working in an analytical or information setting within a health or social care organisation
• Experience manipulating, analysing and interpreting large and complex datasets and presenting results in a user-friendly manner
• Experience using SQL for data extraction, manipulation and analysis
• Experience preparing descriptive statistics and analysing trends, variation and population-level measures
• Experience working with Snowflake, including developing queries, scripts and analytical datasets
• Experience using Power BI to develop reports, dashboards and data visualisations
• Experience working with integrated health and care datasets and managing challenges around data quality
• Experience using Python and/or R for data analysis and programming
• Experience of population health, neighbourhood health, proactive case finding, risk stratification or service improvement analytics
• Experience supporting costing or ROI analysis
• Project management experience
• Experience of predictive modelling, risk stratification or evaluation of interventions

Personal Qualities

• Good problem-solving and multi-tasking capabilities with the ability to react to customer requirements and meet tight deadlines
• Ability to focus and accurately complete tasks within given timeframes whilst dealing with unscheduled interruptions e.g. new, urgent, priorities
• Demonstrated ability to work under pressure, plan and manage own workload and plan work in advance to meet deadlines
• Able to prevent and overcome potential challenges proactively and creatively
• Ability to work as part of a multidisciplinary team, self motivate and motivate others

Knowledge - Interview Only

• Good understanding of the aims of Population Health programmes across at least two areas: Acute Care, Social Care, Primary Care, Community Care, Public Health and Mental Health
• Knowledge of a range of qualitative and quantitative methods and approaches and application to complex questions

Skills and abilities - Interview Only

• Demonstrated ability to deliver projects in complex environments, with multiple stakeholders and competing priorities
• Ability to communicate complex findings in a clear and insightful manner, to help inform policy decisions or service design
• Ability to work with complex data sources, and manage challenges around data quality
• A good knowledge of project management principles and techniques, such as Agile working or Prince 2

Communication - Interview Only

• Ability to communicate information clearly, in writing, orally, and in visual presentations, to a range of audiences
• Able to work with people to understand their needs, and how we can best support them
• Ability to interact effectively with staff at all levels in NHS organisations, Social Care, and suppliers
• Strong interpersonal, communication and organisational skills, with a proven ability to forge and maintain relationships

Qualifications and Training

• Educated to master's level or equivalent relevant experience
• Qualification in a numerate discipline
• Evidence of continuing professional development

• Experience working in an analytical or information setting within a health or social care organisation
• Experience manipu