Interview Pal Start interview
CVs and job hunting

How to get a data analyst job in the UK: skills, portfolio, CV and interviews

Data analyst jobs UK: the skills employers test, routes in without a degree, a portfolio built on UK open data, a CV that shows results, and interview tasks.

By the Interview Pal team · · 7 min read

Illustration of scattered cyan and purple data dots pouring into a funnel and coming out as a rising bar chart with a gold trend line on a dashboard card, next to a small spreadsheet grid with one highlighted cell

Landing your first data analyst job in the UK comes down to one thing: showing an employer that you can take messy data, answer a real question with it, and explain the answer to someone who doesn't care about formulas. Most entry-level adverts test the same core skills, which are Excel, SQL and a reporting tool such as Power BI or Tableau. Plenty of them don't insist on a degree, as long as you can prove you can do the work.

If you're searching for data analyst jobs in the UK and wondering where to start, the route is: learn those three tools properly, build two or three small projects on real data, write a CV that leads with results, and prepare for a practical test. This guide takes each step in order.

What data analysts actually do

Day to day, a data analyst pulls data from a system, cleans it, works out what's changed and why, and turns that into a report, dashboard or recommendation for someone who asked a question: "Why did complaints rise in March?", "Which stores are missing their targets?", "How long are patients waiting at each stage?"

The job titles vary more than the work does. Search for all of these:

Job title Where you often see it
Data analyst / junior data analyst Most sectors
MI analyst (management information) Banks, insurers, contact centres, logistics
Reporting analyst Retail, utilities, housing associations
BI analyst (business intelligence) Larger companies with dashboards and data warehouses
Insight analyst Marketing, charities, retail
Information or performance analyst NHS trusts, councils, police and other public bodies

An MI or reporting analyst role is often the most realistic first step, because regular reports teach you the business and its data at the same time.

The skills UK employers test

Read ten real adverts and you'll see the same list again and again. Aim to be genuinely comfortable with the first three before you apply widely.

  1. Excel. Pivot tables, XLOOKUP or VLOOKUP, IF statements, sorting and filtering large sheets, and charts that make one point clearly. Many interviews include an Excel task.
  2. SQL. Writing queries with SELECT, WHERE, GROUP BY and JOIN. For many entry-level roles, it's the skill that decides who gets shortlisted.
  3. A reporting tool. Power BI is common in UK adverts, especially in organisations that run on Microsoft, and Tableau appears regularly too. Learn one properly rather than both badly.
  4. Python or R (often desirable). Useful for cleaning and automating, and more important in senior or specialist roles. At entry level it's usually a bonus, not a requirement.
  5. Communication. Explaining a finding in plain English, in two sentences, to a manager in a hurry. Adverts mention it often, and it's where career changers often shine.

Routes in, with or without a degree

There are several ways in, and you don't have to choose only one.

  • From inside your current employer. This is the most underrated route. If you already build spreadsheets or track figures for your team, ask to shadow the reporting team or take over a report. An internal move often needs less formal proof.
  • Apprenticeships. In England there are data apprenticeships, including a data technician apprenticeship and a data analyst apprenticeship at a higher level. They're open to adults as well as school leavers and combine paid work with training. Search on GOV.UK.
  • A degree. A numerate subject helps, and some graduate schemes require one, but many entry-level adverts list a degree as desirable rather than essential.
  • Self-study and certificates. Microsoft's Power BI Data Analyst certification and well-known online data analytics certificates give a shortlister something concrete to see. Exam and course costs change, so check the provider's own site. Be wary of anyone selling a course with a "guaranteed job" attached.

If you're torn between data and other tech roles such as IT support, our guide to getting an IT job in the UK covers the support and service desk route.

Build a portfolio on UK data

A portfolio is what turns "I've done a course" into "here's what I found". Two or three finished projects are plenty, as long as each one answers a question.

The UK has a lot of free, public data that makes for good projects:

  • data.gov.uk lists datasets published by government departments, councils and public bodies.
  • The Office for National Statistics publishes data on the labour market, population, prices and much more.
  • Your local council may publish data on things like planning, recycling or local services.

For each project, write a short summary with four parts: the question, the data, what you did, and what you found. For example:

Question: Which areas in my region have seen the biggest change in household recycling rates over the last few years?

What I did: Downloaded the council-level figures, cleaned inconsistent area names in Excel, loaded the data into a small database and used SQL to calculate the change for each area. I then built a one-page Power BI dashboard with a map and a ranked bar chart.

What I found: A handful of areas had improved far more than the rest. Several of them had changed their collection schedules during that period, which would be worth exploring further.

Saying what you'd explore next shows curiosity, and it's honest about what the data can't prove.

Writing a data analyst CV

Your data analyst CV has one job: make the evidence easy to find in a few seconds. A sensible order is a short profile naming the role, a technical skills section, your projects, then your work history and education.

Turn your current job into analysis language wherever it's true:

Before: Kept the weekly repairs spreadsheet up to date.

After: Built a weekly Excel report of overdue repairs for a housing association, using pivot tables to group jobs by contractor; the report became the agenda for the Monday team meeting.

That shows the tool, the audience and the effect. Do the same wherever you've counted, tracked or reported anything.

Name your tools precisely ("SQL: joins, aggregations, subqueries" beats "data skills"), link to your portfolio near the top, and leave off any tool you couldn't use under test conditions, because you may be asked to.

UK CV Fix has a free guide to the standard UK CV format if you need the basics first. Before sending anything, run your CV through our 20-point CV checker.

Where to find data analyst jobs

  • General job boards and Find a Job. Set alerts for each job title in the table above, not just "data analyst".
  • Civil Service Jobs. Government departments recruit analysts in several professions, and adverts spell out exactly what will be assessed.
  • NHS Jobs and council websites. Look for information analyst and performance analyst posts.
  • Specialist data and tech recruitment agencies. Useful for contract and temporary roles, which can be a solid first step.

Every employer must check your right to work before you start. If you're not a British or Irish citizen, GOV.UK explains how to prove it.

What the interview involves

Data analyst interviews usually have two halves. One is the ordinary interview: why this role, why this employer, and "tell me about a time" questions, which the STAR method handles well. The other is practical, and it often takes one of these forms:

  • A live test in Excel or SQL, done in the interview or on a timed online platform.
  • A take-home task: a dataset and a question, with a day or a few days to send back your findings.
  • A short presentation of your take-home task or a portfolio project.

Interviewers watch how you think as much as whether you get the answer. Say your assumptions out loud ("I'm treating blank dates as missing, not zero"), check the data before you trust it, and finish with a clear "so what". If you get stuck on a formula, explain what you're trying to do; that often earns more credit than silence.

Explaining analysis out loud is a skill of its own. Interview Pal asks you tailored questions for the role out loud, listens to your spoken answers, and gives each a score out of 10 with spoken feedback and a recommended answer, so you can rehearse walking someone through a project before the day.

Getting a data analyst job in the UK isn't about collecting every tool. It's about solid Excel and SQL, one reporting tool, a couple of real projects, and a CV and interview that keep coming back to what you found and why it mattered.

Frequently asked questions

Can I become a data analyst in the UK without a degree?

Yes. Many entry-level and apprenticeship roles focus on skills rather than degrees. Strong Excel and SQL, a reporting tool and a small portfolio give you real evidence to apply with.

How long does it take to become a data analyst?

It depends on where you start and how much time you have. Someone already using spreadsheets at work may be ready within months; starting from scratch usually takes longer. Focus on finishing projects rather than counting course hours.

Should I learn Python or SQL first?

SQL first for most people. It appears in many entry-level UK adverts, and technical tests often use it. Add Python once you're comfortable writing queries and want to automate or clean larger datasets.

What's the difference between a data analyst and a data scientist?

A data analyst mainly explains what has happened and why, using reports, dashboards and queries. A data scientist usually builds statistical or machine learning models to predict or automate, which normally needs deeper maths and programming.