Every public service produces data. Hospital appointments, bin collections, benefit claims, school admissions, bus trips — all of it leaves a trail of numbers. Somebody has to turn those numbers into decisions: which clinic needs more staff, which streets flood first, which service is quietly failing. That somebody is a data analyst, and the public sector employs them almost everywhere.
It is also one of the most realistic routes into skilled, well-structured work for people without a traditional professional background. Plenty of public sector analysts started in admin jobs, taught themselves spreadsheets properly, and worked their way across. Others came from maths or science degrees, or retrained later in life.
This guide covers where analysts actually work, what the job feels like day to day, the tools involved, how the Civil Service organises its analytical careers, and two practical questions: how to build a portfolio from public data, and how to move across from an admin role.
Where analysts work
The job title changes, but the work appears across the whole public sector:
- NHS informatics and performance teams. Hospitals and health boards run large teams that track waiting lists, bed occupancy, staffing and clinical outcomes. Integrated care boards employ analysts to plan services across whole areas. Titles include "information analyst", "performance analyst" and "data quality officer".
- Council performance and insight teams. Councils analyse everything from social care demand to housing waiting lists and school places. Look for "insight", "intelligence", "performance" or "business intelligence" in council adverts.
- Central government. Departments employ analysts for policy, operations and statistics — from measuring whether a programme works to producing the official figures the country runs on.
- Police, fire and justice. Forces employ analysts to understand crime patterns and demand; probation and the courts have their own analytical teams.
- Regulators and arm's-length bodies. Inspectorates and agencies of all kinds need people who can find the story in returns and inspection data.
The common thread: none of these organisations lacks data. What they often lack is people who can clean it, question it and explain it.
What the work looks like day to day
Forget the film version of a lone genius staring at glowing screens. A typical week mixes a few kinds of work. There are recurring reports — the weekly waiting list position, the monthly performance pack — which need producing accurately and on time. There are one-off questions from managers: can you tell me how demand changed since we moved the service online? There is data cleaning, which nobody advertises but everybody does; real public sector data is full of duplicates, gaps and mistyped dates, and half the skill is dealing with that honestly.
Then there is the part that makes the job worthwhile: presenting findings to people who will act on them. A good public sector analyst spends real time writing plain-English summaries, building charts a busy director can read in ten seconds, and sitting in meetings explaining what the numbers can and cannot say. The analysts who progress are rarely the ones with the fanciest code — they are the ones who can be understood.
The rhythm is generally humane. Deadlines exist, but the always-on culture of some private-sector analytics jobs is rare. Hybrid working is common across analytical teams.
Tools of the trade
Tooling varies wildly between organisations, and that is worth knowing before you spend money on courses. Broadly, the ladder runs like this:
Spreadsheets remain the everyday workhorse. Deep, honest Excel skill — lookups, pivot tables, tidy formulas, clean layouts — still carries many analyst roles, especially in councils and smaller bodies. SQL, the standard language for pulling data out of databases, is the single most requested technical skill in analyst adverts and the best first thing to learn after spreadsheets. Dashboard tools such as Power BI and Tableau turn tables into interactive charts, and many teams now expect at least one of them. Beyond that, code — usually R or Python — appears in statistical and data science roles, and increasingly in ordinary analyst teams that want reproducible work.
Two reassurances. First, almost no advert expects all of these; read the person specification and match it. Second, employers consistently care more about judgement — did you sense-check the numbers, did you spot the bias in the sample — than about any particular tool. Tools can be taught in weeks. Scepticism takes longer.
Analytical careers in the Civil Service
Central government takes analysis seriously enough to organise it into recognised professions, each with its own community, standards and development routes. Statisticians produce and quality-assure official figures. Operational researchers model systems and options — queues, forecasts, what-ifs. Economists, social researchers and data scientists each have their own badged profession too.
For a job seeker, this matters in three ways. Membership of a profession usually comes with structured development and a clear promotion ladder. Recruitment for these roles often includes a technical assessment alongside the standard Civil Service process, so expect to demonstrate skills, not just describe them. And adverts signal the profession in their titles — "assistant statistician", "operational research analyst" — which helps you target the flavour of work you actually want. Departments also employ plenty of general data analysts outside the badged professions, often within digital and data teams.
Pay and grading follow normal Civil Service arrangements, with the advert stating the salary for each role — check there rather than relying on rules of thumb.
Building a portfolio from public data
Here is the genuinely good news for career changers: the public sector publishes its data. You can build interview-ready evidence of your skills without anyone's permission, using the same kind of data you would handle in the job.
The Office for National Statistics publishes open datasets on population, work, health and much more. Councils publish open data on spending, planning and services. The NHS publishes regular statistical releases. Pick one question you actually find interesting — how has A&E attendance in my region changed? which wards in my town have the oldest populations? — and take it from raw download to short write-up with two or three clear charts.
Then put it somewhere visible: a simple GitHub repository, a blog post, even a tidy PDF. Two or three small, finished projects beat one grand unfinished one. In an interview, walking through a real analysis you chose and completed yourself answers the "no professional experience" objection better than any certificate, because it shows the full job: finding data, cleaning it, making choices, explaining results.
Moving across from an admin role
Admin work is the unofficial training ground for public sector analysts. If you already book appointments, maintain records or produce returns, you are closer than you think — you understand the data because you helped create it, and you know why it goes wrong. NHS admin roles in particular sit next door to informatics teams; our guide to NHS administration and clerical jobs explains that world and why it is such a common starting point.
The path usually looks like this. Volunteer for the data tasks in your current job — the rota spreadsheet nobody wants, the monthly figures, the audit return — and do them conspicuously well. Learn SQL and one dashboard tool in your own time using free materials. Build the small portfolio described above. Then apply sideways: internal vacancies, "data officer" and "information assistant" roles, and apprenticeship-style data routes that let you train while working. When you write your application, translate your admin experience into analytical language — accuracy, handling sensitive information, working to deadlines, spotting errors — and evidence each claim. Our public sector CV guide shows how to structure that evidence the way sifting panels expect.
Analyst vacancies appear steadily across every part of the sector. Browse the live listings on GovJobs — all public sector jobs with a search for "analyst", or jump straight to council jobs and Civil Service jobs — to see what is being asked for at each level right now.
Sources and further reading
This article is general careers information, not formal advice. Always check the official source and the specific job advert for current details.
