BI Developer and Platform Manager

Job summary

North East London is one of the most diverse and fastest-growing areas in the country, with significant health inequalities and changing needs driven by population growth and an ageing population. NEL ICB's strategic commissioning role is to understand those needs and direct resources where they will make the greatest difference, and high-quality population health analysis sits at the heart of that work.

The Intelligence and Insights function is a dynamic team of analysts driven by a shared purpose: improving the health of our local population. We build a clear picture of population need, health inequalities and service utilisation, and identify opportunities to improve outcomes, quality and productivity. Our analysis informs commissioning decisions at every level, from NEL-wide strategy to specific providers, pathways, services, places and neighbourhoods.

Underpinning this is a mature cloud data platform in Snowflake, providing a rich, linked healthcare dataset to ICB analysts and partners. There are two posts in the structure, one already filled, available following the transition of the original dedicated NEL ICB team to the One London hosted service, and you will work closely with One London colleagues as part of a wider regional network.

Main duties of the job

As one of two BI Developer and Platform Managers, reporting to the Director of Intelligence and Insights, you will take ownership of the NEL ICB Snowflake sandpit. You will manage and optimise the environment, loading, transforming and extracting data, building scalable models and pipelines using dbt and SQL, and applying IG-compliant security roles so the right people have safe access to the right data.

You will create and maintain our portfolio of BI outputs, from interactive Power BI and Excel dashboards to public-facing R Shiny and R Markdown outputs and take on the running and development of our population segmentation models, which help us target support to groups with similar needs.

Our analysts use Python, R, Excel and Snowsight, and your knowledge of our datasets will be central to supporting their work, enabling data science and shaping optimised data schemas.

This is an opportunity for a data engineer, data analyst or warehouse manager to lead a function that is the foundation for evidence-based decision making across North East London. You will work with stakeholders at all levels of the ICB and with external partners including One London, Public Health, provider trusts, local authorities, other ICBs and NHS England.

If you want your technical skills to make a real difference to people's health, we would love to hear from you.

About us

NHS North East London Integrated Care Board (ICB) was formed on 1 July 2022.

We are an exciting new organisation putting the needs of communities at the heart of our commissioning arrangements.

We are working with local people and partners across health, social care and the voluntary sector in innovative ways to improve health and wellbeing for all our communities. Our key priority in the next year will be to develop closer integrated and collaborative ways of working with all our partners to implement our Out of Hospital Strategy.

We can only do this with great staff who are encouraged and supported, which is why we invest in them, listen to them, make sure we are representative of our populations and that we foster their health and wellbeing.

Please note that all vacancies will be subject to a probation period in line with the Probation Policy.

Job responsibilities

The successful candidate will have: Educated to masters level in relevant subject or equivalent level qualification or significant experience of working at a similar level in specialist area Highly developed specialist knowledge and significant experience in analytics engineering, data engineering, or a similar role Highly developed specialist knowledge and significant experience in SQL and at least one statistical programming language (e.g., Python, R) Experience working with cloud data platforms (eg Snowflake) Experience of co-ordinating projects in complex and challenging environments Able to provide and receive highly complex, sensitive or contentious information, negotiate with senior stakeholders on difficult and controversial issues, and present complex and sensitive information Highly developed knowledge of data modelling techniques (e.g., star schema, normalization) Expert knowledge of the wide range of data in the following health and/or care and/or wider determinants of health Working knowledge of GDPRR and information governance frameworks in the NHS including the application of small suppression and sharing of data with others Ability to demonstrate knowledge and understanding of equality of opportunity and diversity. Being aware of how individual actions contribute to, and make a difference to, the equality agenda

Other desirable skills for this role would be: Experience working with cloud data storage (eg Azure) Insight into the potential of data science, machine learning and the use of tools such as ChatGPT, Microsoft 365 Copilot, Claude AI in the delivery of analytics.

For further details, please refer to the attached job description, paying careful attention to the essential and desirable criteria in the person specification when completing your application and supporting statement.

Person specification

Education / Qualifications

Essential

• Educated to masters level in relevant subject or equivalent level qualification or significant experience of working at a similar level in specialist area
• Evidence of continued professional development

Experience

Essential

• Highly developed specialist knowledge and significant experience in analytics engineering, data engineering, or a similar role
• Highly developed specialist knowledge and significant experience in SQL and at least one statistical programming language (e.g., Python, R)
• Experience working with cloud data platforms (eg Snowflake)
• Experience of co-ordinating projects in complex and challenging environments
• Able to provide and receive highly complex, sensitive or contentious information, negotiate with senior stakeholders on difficult and controversial issues, and present complex and sensitive information

Desirable

• Experience working with cloud data storage (eg Azure)

Knowledge

Essential

• Highly developed knowledge of data modelling techniques (e.g., star schema, normalization)
• Expert knowledge of the wide range of data in the following health and/or care and/or wider determinants of health
• Working knowledge of GDPRR and information governance frameworks in the NHS including the application of small suppression and sharing of data with others
• Ability to demonstrate knowledge and understanding of equality of opportunity and diversity. Being aware of how individual actions contribute to, and make a difference to, the equality agenda

Desirable

• Insight into the potential of data science, machine learning and the use of tools such as ChatGPT, Microsoft 365 Copilot in the delivery of analytics