Join Camdens Public Health Intelligence team and helpshape a healthier future for our communities.

Were looking for a Senior Public Health Analytics Engineerto play a pivotal role in transforming health data into actionable intelligencein Camden. This is a unique opportunity to work at the intersection of publichealth, data engineering, and analytics, enabling evidence-based decisions thatimprove population health and reduce inequalities. Youll contribute toambitious initiatives such asRaise Camden, where were building linked,longitudinal records to better understand child wellbeing, and ourEstatesMission, which uses integrated data to improve services for those with the greatestneed.

Main duties of the job

Developand maintain robust, scalable datasets and reproducible analytical pipelinesbringing together datasets spanning all areas of public health.

Collaborateacross Camdens data functions to align with corporate data models andstandards, which include data virtualisation.

Engageand manage stakeholders throughout complex projects involving data collection,linkage, and analysis and process automation.

Navigatingand resolving technical and governance challenges to enable more effective andsecure data sharing.

Builddimensional data models and tools that empower analysts and decision-makers.

Supportanalysts with software development practices using R, Python, SQL, and Git.

Leadon data integration, quality assurance, and governance, especially in healthand care contexts.

Shape ourtech stack and contribute to innovative data solutions.

About us

Camdenis changing on the inside to make life better for everyone. Our residents andcommunities are at the heart of everything we do. Were home to the mostimportant conversations happening today and were making radical social changea reality, so that nobody gets left behind. Heres where you can help decide a betterfuture for us all.

Job responsibilities

The post holder will join Camdens growing Public Health Intelligence team. The remit of the team is to turn health data and information into intelligence that underpin policy decisions that improve population health and reduce inequalities. The Senior Public Health Analytics Engineer is a key enabling role that ensures our data is robust, and analytics scalable, and code of high quality. This will entail developing and maintaining our datasets, ensuring reproducible pipelines feed our analytical outputs, and supporting with the development of data analysis tools. The post ensures the efficient and effective use of data for evidence-based decisions that underpin work to improve the health and wellbeing of Camden through projects such as establishing person-level, longitudinal records for research and undertaking data linkage of disparate datasets.

The post-holder will report to the Head of Health Intelligence but work in collaboration with the Councils wider data functions including Data Architecture, Data Engineering, and Data Governance to ensure alignment across the Council. We recognise that Analytics Engineering is a relatively new profession and welcome applications from those coming from a data analytics, data science, or engineering skillset.

Your work will involve:

Gathering requirements and translating these into clear deliverables, including proactively developing relationships to break down data barriers on behalf of the team

Working with data analysts, engineers, architects, and other data professionals to prioritise, plan and deliver work against organisational standards such as our corporate data model. Specifically, you will lead on work to create Enterprise, Integration, and Presentation data layers for use by Data Analysts from Base and Enterprise layers provided by other Data Professionals, linking across datasets while tackling data quality gaps

Proactive and responsive development and maintenance of flexible, quality-assured, dimensional models for use by analysts, ensuring dimensions are conformed wherever possible

Developing tools to collect, store and present data, metadata, and documentation that enable people to gather and apply insights from data effectively

Drawing attention to data quality and data governance issues, including issues affecting equity of services, and support with efforts to improve problems in these areas where they arise

Helping data users to automate their work, supporting them with approach such as Reproducible Analytical Pipelines and data normalisation as well as technologies such as Denodo and Microsoft Purview

Supporting data analysts write robust, reuseable, and assured analytical code though functionisation, modularisation, version control, unit testing, and package development

Working with data analysts to develop business intelligence tools and process automation to routinely monitor service data and support end users with the use of these tools

In this post you will work with teams using a variety of software including R, Python, SQL, VQL, Denodo, and Git, with the opportunity to help shape our tech stack.

Person Specification

Qualifications

• Suitable undergraduate or postgraduate qualification in a relevant field such as data analysis, data science, or computer science, or equivalent professional experience (3+ years)

Experience

• Strong knowledge of SQL, data modelling, and the use of Denodo or similar data virtualisation and integration software to support Reproducible Analytical Pipelines and ETL/ELT processes
• Experience in data governance, particularly within the public sector or with health or social care
• Experience with undertaking analysis with R or Python and/or supporting analysts who use R and/or Python to embed software development practices
• Expertise in collecting user needs and translating these into actionable work plans and products

Head of Population Intelligence&Statistical Method