Data Analyst - Public Health
Working Hours: 37 hours per week
Worker Type: Hybrid Worker
Salary: Starting Salary is £35,235 per annum (Level One) with annual incremental rises to £37,938 (Level Four) per annum (pro rata for part-time)
Location: Loxley House, Station Street, Nottingham, NG2 3NG
We’ve got an exciting opportunity available for talented individuals to join our workforce - perhaps this is the opportunity you’ve been looking for? Read on to find out more…
Working for Nottingham City Council has great benefits. As well as competitive pay, great leave entitlement and access to a generous pension scheme, we strive to create an innovative, inclusive and progressive work culture where everyone is supported to do and be their very best.
In return, we are looking for people like you - people who are innovative, driven and committed to serving and improving Nottingham. So, if you are passionate about making a difference to the lives of those who live and work in our city, we want to hear from you.
- You can read more about the different benefits offered to colleagues working for Nottingham City Council here.
About the Role
Nottingham City Council are committed to the improvement of public health through the use of data, intelligence and evidence based decision making. Our Public Health Data Analysts work with colleagues across a range of portfolios to analyse population and health data, improving the understanding of population health, health inequalities, monitoring trends and assessing the outcomes of public health workstreams.
This is an exciting opportunity for a skilled and motivated Data Analyst to join our team. In this role you will support the provision of robust analysis and insights across the whole Public Health team, work on our Joint Strategic Needs Assessment and Health Needs Assessments, and create innovative and accessible reports to deliver insights to our colleagues and stakeholders to help inform actions to improve population health and reduce health inequalities.
Key objectives of the role will include:
- Preparation of data from a range of sources for loading into the Public Health database, checking for data quality and consistency
- Maintenance and management of the Public Health database as directed by the Senior Principal Analyst
- Downloading, reformatting and manipulation of data to produce charts, tables and complex reports in support of Public Health projects
- The development of SQL scripts to extract and analyse health datasets, including complex statistical calculations such as age/sex standardised rates and confidence intervals
- To work with the Senior Principal Analyst on a variety of projects requiring advanced technical skills such as SQL, advanced Excel and PowerBI to improve access to data
- To support colleagues across Public Health with the interpretation and use of data
The ideal candidate will:
- Have experience of working with NHS, Public Health or other health related data
- Have experience of utilising large databases or datasets e.g. Hospital Episode Statistics (HES) and Civil Registration datasets
- Have demonstrable experience of the use of T-SQL, MS SQL Server Management Studio, MS PowerBI and other business intelligence tools
- Be a graduate in, or have equivalent experience of, a numerate or analytical discipline
The role will be based within our Public Health Knowledge and Intelligence team but will support all portfolios within the Public Health team as required. Please click on the following link for a short introduction to our Public Health team: What is Public Health - VEED
The postholder will be subject to a DBS check, and will need to have the ability to live and work in the UK.
What to do next:
- Locate and review the job description and information pack provided. Consider how you will evidence the required competencies, and prepare your application to include these.
- We are keen to give all applicants an opportunity to shine and show their full potential. Therefore, in addition to your application we are asking all applicants to send us their response to the following question:
“Thinking about where you live, what three things could or already do, make a big difference to the local community’s health and wellbeing?”
You can provide this response in any format you like – it can be a set of Powerpoint slides, a short video, concise word document (1000 words max) or something else entirely! In responding to this question we are interested in your personal thoughts and reflections, as well as how you approach the question and communicate your answer.There is no textbook answer, however in order to make this a meaningful part of the process we ask that you do not use AI text generators such as ChatGPT or similar. Responses will be checked for the likely use of AI and the result of this will be considered during shortlisting.
Responses should be emailed to hannah.stovin@nottinghamcity.gov.uk before the closing date and named using the name provided on your application. Important - Applications will not be considered during shortlisting unless this requirement has been met.
You can find the job description for this post here
At Nottingham City Council we believe that work is what you do, not where you do it. We offer different working arrangements, depending on the role, including hybrid working. Further information on Worker Types and what these mean in terms of how and where you work can be found on the additional information for applicants page.
For informal enquiries please contact hannah.stovin@nottinghamcity.gov.uk
Closing Date: 23rd February 2025
Please note there may be occasions where we close the advert before the closing date and we encourage you to apply as soon as possible.
Interviews will be held: Likely to be held late March 2025 - exact dates to be confirmed
If you have any technical issues when completing your application, please contact our Employee Service Centre: https://emss.freshdesk.com/support/home
By applying to this job, you agree to our Terms & Conditions.