Data Analyst - Public Health

Contract Type: Fixed Term 24 months

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.

Thank you for your interest in working for Nottingham City Council. As one of the largest employers in Nottingham we offer a wide range of roles across a range of services. In return for your skill, drive and commitment to serving the people of Nottingham, we can help you to develop an exciting and rewarding career, with access to the following benefits. 

In addition to working within a great team and a competitive salary you will have access to:

• 26 days annual leave (rising to 33 days after 5 years’ service)  + bank holidays with the ability to buy additional leave annually
• Access to a generous, defined benefit pension scheme offering 17.9%
• Smart Working – to support your work life balance
• Health and wellbeing benefits including access to our Employee Assistance Programme
• Discounted membership at selected local sports and fitness centres, cinema, shopping and much more!

Nottingham City Council is committed to recruiting a talented workforce that reflects the communities we serve. We are a fair and inclusive employer and welcome applications from people from all backgrounds and with different abilities. We recruit for diversity and value difference.
   
We particularly want to hear from you if you are from the Black, Asian and Minority Ethnic community, identify within the Lesbian, Gay, Bisexual and Transgender community (LGBT) and if you are Disabled - these groups of people are underrepresented in our workforce, and we’d like to reflect our local population more through our recruitment processes.    

We are supportive of flexible working arrangements wherever possible and we would encourage you to discuss this with us during the selection process, should this be something you are interested in.