What does a data analyst do in the UK? Daily work and salary

A data analyst in the UK takes raw data from a business's systems, cleans it, works out what it says, and explains the answer to people who need to make a decision. In practice that means writing SQL queries, building spreadsheets and dashboards, checking numbers that don't add up, and turning all of it into a short, clear message. Typical pay runs from about £28,000 for starters to £65,000 for experienced analysts, according to the National Careers Service.

That's the job. Here's what it looks like day to day.

What does a typical day look like?

The National Careers Service lists the core tasks as collecting and organising data, checking data quality, using analytical tools to spot patterns and trends, producing visualisations and presenting findings. That's accurate, but it hides how much time goes on the unglamorous bits.

A realistic week for a mid-level analyst might include:

• Refreshing and checking regular reports (weekly sales, monthly performance)
• Answering ad hoc questions: "Why did returns jump last month?"
• Writing and fixing SQL queries against the company database
• Building or updating a Power BI or Tableau dashboard
• Meeting a team to understand what they actually need
• Investigating why two reports show different numbers for the same thing

That last one comes up constantly. A surprising amount of analysis is detective work on definitions: what counts as an "active customer", which date a sale is recorded against, why finance and sales disagree.

Hours are usually standard office hours. The National Careers Service puts them at 37 to 40 a week.

What does an entry-level data analyst do?

Less analysis than you'd expect, at first.

New analysts usually start by maintaining existing reports, cleaning data, checking numbers before they go out, and answering simple questions from colleagues. You'll spend weeks learning where the data lives, which tables to trust and which people know the history.

That can feel slow, but it's where you build credibility. The analyst who catches an error before it reaches a director gets trusted with bigger questions next time.

For example, a typical first task might be: "The regional sales report is taking too long to build every Monday. Can you speed it up?" You'd find out where the data comes from, replace manual copy and paste with a SQL query or Power Query, check your version against the old one line by line, and hand it back with a short note on what changed. Small, useful, visible. That's how most analysts earn their first bigger project.

By the end of your first year you'd normally expect to own a few reports, have built at least one dashboard from scratch, and be the go-to person for a particular area of the business.

Which tools do UK data analysts use?

IT Jobs Watch tracks which skills appear in UK job ads. Across 1,007 permanent data analyst ads in the six months to 8 November 2026, SQL appeared in 32%, Power BI in 27%, Python in 18.6%, Excel in 14.5% and Tableau in 8%.

In plain terms:

SQL pulls data out of databases. It's the most requested skill and the one to learn first.

Excel is everywhere, even when ads don't mention it. Pivot tables, XLOOKUP and Power Query are the bits you'll use most.

Power BI or Tableau turn data into dashboards that other people can explore. Power BI is more common in UK job ads, partly because so many organisations already use Microsoft 365.

Python handles bigger or messier jobs and automation. Useful, but rarely the first thing employers test.

How much does a data analyst earn in the UK?

Pay depends heavily on sector, location and level. Here are the figures from two reliable UK sources.

Two caveats. The junior figure is based on only a handful of ads, so treat it as indicative. And advertised salaries skew towards roles that recruiters advertise, which are often more senior. Expect your first offer to be closer to the starter figure, especially outside London.

The things that push pay up fastest are usually SQL depth, owning a business area end to end, and being able to present confidently to senior people. Sector matters too: financial services and tech tend to pay more than charities and parts of the public sector, though the latter often offer better pensions and flexibility.

Where do data analysts work?

Almost everywhere. Retail, banking, insurance, the NHS, local government, charities, energy, logistics, sport and e-commerce all employ analysts. The National Careers Service lists healthcare, finance, the environment, sports and e-commerce among the sectors.

Job titles vary too. You'll see data analyst, MI analyst, reporting analyst, insight analyst, performance analyst and commercial analyst for broadly similar work. If you're job hunting, search all of them, and read the duties rather than the title. Two "data analyst" jobs can be completely different roles.

How is a data analyst different from a BI analyst or data scientist?

The lines blur, but roughly:

• A data analyst answers business questions with data and reports the findings.
• A BI analyst focuses more on building and maintaining dashboards and reporting systems. Our BI analyst guide covers it in more detail.
• A data scientist builds predictive models and often needs stronger statistics and programming.

Many people start as data analysts and move into one of the other two after a few years.

Is data analyst a good career in the UK?

For the right person, yes. I'd say it suits you if you like puzzles, are comfortable with numbers, and can explain things simply to people who aren't technical. That last skill is underrated. The best analysts aren't the ones with the cleverest SQL. They're the ones whose findings actually get used.

The progression is decent too. The National Careers Service lists senior and lead analyst roles, team management, freelance consultancy and data science as routes forward, and the jump between starter and experienced pay is large.

The honest downside is that the first job is the hardest part. Plenty of people learn the tools and then struggle to get hired without experience. Our guide on how to become a data analyst covers routes in.

How Experiencely can help

If you understand the role and want to get your foot in the door, our data analysis programme combines training and the CompTIA Data+ certification with a live data project. You're placed within 48 hours and work about an hour a day for three months, fully remote. The cost is £2,495. If you're not hired within 60 days of finishing, you get your money back (conditions apply). It's a way to do the work described above before you apply for it.

Frequently asked questions

Sources

Figures are taken from the sources below. Salary ranges are indicative and individual offers vary. Last checked 9 November 2026.

1. National Careers Service: Data analyst-statistician
2. IT Jobs Watch: Data Analyst jobs, UK
3. IT Jobs Watch: Junior Data Analyst jobs, UK