UK

United Kingdom · Technology and data · Mid-Level (2-5 years)

Data Analyst

Here is the whole job, in plain words. What it is, what you decide, how you're judged, how people get here and where they go next. Then the part no course gives you: twelve AI tutors who learn your work.

Start my Data Analyst plan, free

Free to start: a plan built for this role, and a Future Fluency module to try first. No card.

Keep this job description

Where should we send it?

One email: what AI is changing in this job, and where to start free. With a link back here. Nothing else follows unless you confirm your address.

Also at another level: the Junior Data Analyst job description.

Upskilling a team in this role? Talk to us

  • Experience bandMid-Level (2-5 years)
  • Direct reportsNo direct reports
  • Reports toSenior Data Analyst or Analytics Manager
  • UK framework levelUsually a coordinator, or early in a professional job

Also advertised as Analytics Specialist · Business Intelligence Analyst · Reporting Analyst

Built on 43,079 real UK job descriptions we analysed · grounded in qualifications employers recognise

Two short quizzes about you

1From this job to a course

The qualifications matched to this job

NOCN Level 4 certificate for Data Analysts NOCN · Level 4 · covers 4 of 7 standards
Pearson BTEC Level 4 Higher National Certificate in Computing for England Pearson Education Ltd · Level 4 · covers 3 of 7 standards
BCS Level 4 Diploma - Digital Modular Programme for Data Analysts BCS, The Chartered Institute for IT · Level 4 · covers 2 of 7 standards
Highfield Level 3 Diploma for Team Leaders and Supervisors (RQF) Highfield Qualifications · Level 3 · covers 2 of 7 standards
NCFE Level 4 Diploma: Data Analyst NCFE · Level 4 · covers 1 of 7 standards
Pearson BTEC Level 4 Higher National Certificate in Digital Technologies Pearson Education Ltd · Level 4 · covers 1 of 7 standards

Matched from the standards this job is measured against: a suggestion, not an official ruling.

The units you would start with

Data Analytics Primer NOCN Level 4 certificate for Data Analysts
Data Analytics Pearson BTEC Level 4 Higher National Certificate in Computing for England
Data Analysis BCS Level 4 Diploma - Digital Modular Programme for Data Analysts
Data Management NCFE Level 4 Diploma: Data Analyst

The future skills this job leans on

AI Fluency working with AI as a thinking partner
Data Fluency turning numbers into a decision
AI Governance Fluency using AI responsibly
Systems Fluency seeing the whole picture
Start my Data Analyst plan, free
Your Plan Illustration

Built for Data Analyst

4 units that map to this job, from the qualifications that cover it.

  1. Data Analytics Primer NOCN · covers 4 of 7 standards Level 4
  2. Data Analytics Pearson Education Ltd · covers 3 of 7 standards Level 4
  3. Data Analysis BCS, The Chartered Institute for IT · covers 2 of 7 standards Level 4
  4. Data Management NCFE · covers 1 of 7 standards Level 4
These are the real units behind this job, in the order they rank for it. Nothing here is marked done, because this plan has not been started by anyone yet. Yours would fill in as you go.

2AI and this work

Will AI change your work as a Data Analyst?

Nobody can say exactly how. Here is what this job is being asked for next, and where to start.

The new skills this role is being asked for

  • Prompt Engineering & LLM Integration
  • Advanced Data Storytelling & Visualisation
Why each one is rising

The future skills this job leans on

We'll only ever tell you what we can actually back up. No hype, no scare tactics.

What happens when you start

Next, a free account. We build your Data Analyst plan as you set up, starting with a Future Fluency module on using AI in your job. No card.

Your first Future Fluency module is free. After that, your AI tutor is £70 a month.

Start my Data Analyst plan, free Ready to pay? Subscribe for £70 a month

3What this role really is

A data analyst digs into numbers to find patterns and turn raw data into insights that support business decisions.

4What you'd actually use

The tools this job runs on, and how well you'd need to know each one.

SQL (Snowflake, Databricks) Advanced

Writing complex queries to extract, transform, and load data from our enterprise data platforms for analysis and reporting. You'll be using this constantly.

Tableau Desktop / Power BI Intermediate

Building interactive dashboards and reports for various business teams, using features like calculated fields, parameters, and basic LOD expressions.

Python (pandas, NumPy, matplotlib) Intermediate

Performing more complex data manipulation, statistical analysis, and data visualisation that goes beyond what SQL or BI tools can easily do. Think data cleaning, feature engineering, or custom plots.

Cloud Data Services (AWS S3, GCP BigQuery, Azure Synapse) Basic

Accessing and querying data stored in cloud object storage or data warehouses. You won't be architecting, but you'll be using them.

Data Governance & Cataloging (Collibra, Alation) User

Using these tools to find data definitions, understand data lineage, and check data quality rules before you start your analysis.

5What you get to decide, and how that grows

Power in a job isn't your title. It's what you're allowed to decide. Here's how it grows as you move up.

The choiceComing in Where you are nowThe step above
Data Extraction & Query Design Executes pre-defined queries, seeks approval for modifications. Independently designs and executes complex queries; consults manager on highly sensitive data access. Defines best practices for query optimisation and data access; approves complex data pulls for junior team members.
Dashboard & Report Creation Builds basic reports from templates under close supervision. Independently designs, builds, and maintains dashboards for specific business units; seeks feedback on major design changes. Establishes dashboard standards and governance; approves new dashboard deployments; mentors others.
Problem Definition & Scoping Receives clearly defined tasks; escalates any ambiguity. Translates vague business questions into clear analytical problems; proposes initial scope and methodology; consults manager for sign-off. Leads problem definition with stakeholders; defines project scope and success metrics for complex analyses.
Data Quality Issue Resolution Identifies and reports data quality issues to supervisor. Identifies, investigates, and proposes solutions or workarounds for data quality issues; escalates to data engineering with clear context. Drives data quality initiatives; collaborates with engineering to implement permanent fixes and preventative measures.

6How you'll be judged

The scoreboard, and what is not on it. The hard targets, how often each is actually looked at, and the quiet signals that never reach a dashboard.

Report Accuracy
The percentage of your reports and dashboards that are free from data errors, calculation mistakes, or misinterpretations.
Target · >99% accuracy on all data pulls and reports

If you deliver 10 reports in a month, and one has a minor calculation error that's caught before it goes wide, that's a 90% accuracy rate. We're aiming higher, obviously.

Ticket Turnaround Time (SLA Adherence)
How quickly you respond to and complete ad-hoc data requests from business teams.
Target · Fulfill 90% of ad-hoc data requests within a 48-hour SLA

If you get 20 requests in a week, you should aim to complete 18 of them within two working days. The other two might be more complex and need a longer discussion.

Query Efficiency
The performance of your SQL queries, making sure they don't hog database resources or take ages to run.
Target · Queries run below a defined resource consumption threshold (e.g., <5 minutes for standard queries)

A query that takes 30 minutes to pull a simple report when it should take 2 minutes means you'll need to optimise it. Your manager will help you learn how to spot these.

Dashboard & Report Usage
How often the dashboards and reports you build are actually viewed and used by the target audience.
Target · Achieve >70% monthly active users for key dashboards you own

You build a new customer churn dashboard. If 7 out of 10 target users (e.g., Product Managers, Marketing Leads) log in to view it at least once a month, you're hitting the target. If it's 2, we need to understand why.

Clarity of Insights
Your ability to present complex data findings in a simple, understandable way, even to non-technical colleagues.
  • Stakeholders consistently say your explanations are clear and easy to follow. They can immediately see the 'so what?' from your analysis. You're able to summarise key points in an email without needing a follow-up call for clarification.
Proactive Problem Solving
Identifying potential data issues or business questions before they become urgent problems, and proposing solutions.
  • You flag data quality issues you discover during analysis, rather than waiting for someone else to spot them. You suggest a new way to look at a metric that the business hadn't considered. You don't just answer the question, you anticipate the next one.
Stakeholder Satisfaction
How happy your internal clients are with your responsiveness, the quality of your work, and your overall support.
  • You get positive feedback in 1-on-1s or team meetings. People come to you directly with new requests because they trust your work. They feel heard and understood when they explain their needs.
Contribution to Team Knowledge
Sharing your learnings, new techniques, or useful queries with the wider analytics team.
  • You contribute to our internal wiki with new documentation. You share a useful SQL snippet in Slack. You offer to help a new joiner get up to speed on a particular dataset. You participate actively in code reviews, offering constructive feedback.

7Would you like it

Both sides. What people enjoy, and what grinds them down.

What people enjoy
Solving Puzzles

You get a real kick out of taking a complex business problem, breaking it down into data questions, and then finding the answers hidden in the numbers. It's like a daily treasure hunt.

Someone asks 'why are our conversion rates down this month?' and you love the process of diving into the funnel data, segmenting by user type, and pinpointing the exact drop-off point.

Making an Impact

You want your work to actually be used and make a difference. Seeing your analysis lead to a change in strategy or a new product feature is genuinely satisfying.

You build a dashboard showing product usage, and the Product team uses it to decide which feature to build next. That's a direct impact.

Continuous Learning

The world of data and tech is always changing, and you're excited by that. You enjoy picking up new tools, learning new statistical methods, or finding better ways to visualise data.

You spend your lunch break experimenting with a new Python library or reading an article about a different approach to A/B testing.

What frustrates people
  • You'll rerun the same analysis three times because stakeholders keep changing the question or the definition of a metric. It's annoying, but it's part of the job.
  • The 'urgent' request that disrupted your Thursday will often get deprioritised on Friday because something else came up. You need to be okay with shifting gears.
  • You'll build a beautiful analysis that clearly shows X, but the business decides to do Y anyway because of a 'gut feeling' or political reasons. It happens.
  • Garbage In, Garbage Out is your daily reality. Expect to spend a significant chunk of your time cleaning, validating, and trying to make sense of incomplete or inconsistent data from various source systems.
  • You'll often be asked to provide a definitive 'yes' or 'no' answer to a complex question when the data only allows for 'probably' or 'it depends'. Managing those expectations is a skill in itself.
What this role does not give you
  • Direct management responsibilities (that comes later).
  • Full autonomy over strategic direction (you're providing the inputs for strategy, not setting it).
  • A perfectly clean, well-documented dataset waiting for you every morning (that's a dream, not a reality).

8Who you work with

Your work directly influences day-to-day operational and tactical decisions across various departments. You're providing the evidence base for optimising existing processes and understanding user interactions. Think of it as providing the compass readings that keep the ship on course, rather than setting the destination.

Inside the business
  • Product Managers (for feature analysis, A/B test results)
  • Marketing Team (for campaign performance, customer segmentation)
  • Operations Team (for process efficiency, demand forecasting inputs)
  • Sales Team (for pipeline analysis, lead conversion rates)
  • Your immediate Analytics team (for peer reviews, knowledge sharing)
Outside the business
  • No direct external stakeholders in this role, though your insights might indirectly inform discussions with partners or vendors.

9What you need before you start

Not a wish list. The things you would be expected to already have.

  • You'll need at least 2 years of hands-on experience in a dedicated data analysis role, where you were regularly writing SQL queries and building dashboards.
  • Proven ability to translate business questions into analytical problems and deliver actionable insights.
  • Strong foundational knowledge of statistical concepts (e.g., descriptive statistics, hypothesis testing).
  • Experience working with large, complex datasets and understanding data warehousing concepts.
  • A portfolio or examples of dashboards/analyses you've built (even if anonymised) would be a huge plus.

10What to practise next

Where the job is going, and what to do about it starting this week.

Advanced SQL Optimisation & Data Modelling

As datasets grow, inefficient queries become costly and slow. You'll need to write highly performant SQL and understand how to contribute to more robust data models.

Window functions and common table expressions (CTEs) · Indexing and partitioning strategies · Slowly Changing Dimensions (SCDs)

  • This quarter: Take an advanced SQL course focusing on performance tuning and complex functions.
  • Next quarter: Actively participate in data modelling discussions with the data engineering team.
  • Ongoing: Review your own queries and challenge yourself to find more efficient ways to write them.

Quick win: Start using `EXPLAIN` or `ANALYZE` in your SQL environment to understand how your queries are being executed and where the bottlenecks are.

Cloud Data Ecosystems (Beyond Basic Use)

Our data infrastructure is increasingly cloud-native. You'll need to understand more than just querying; you'll need to grasp how different cloud services interact and how data flows through them.

Serverless functions (e.g., AWS Lambda, Azure Functions) · Data streaming concepts (e.g., Kafka, Kinesis) · Cloud cost optimisation for data workloads

  • This quarter: Complete a cloud provider's (AWS, GCP, or Azure) associate-level data certification.
  • Next quarter: Work with data engineers to understand the architecture of one of our key data pipelines.
  • Ongoing: Stay updated on new cloud data services and features through blogs and webinars.

Quick win: Familiarise yourself with the pricing models for our main cloud data platforms (e.g., Snowflake credits, Databricks DBUs) to understand cost implications.

11Staying current once you are in

What people here do to keep up
  • Attending industry webinars and virtual conferences on data analytics, BI, or specific tools.
  • Participating in online data challenges (e.g., Kaggle) to hone your skills on diverse datasets.
  • Contributing to open-source projects or maintaining a personal portfolio of analytical work.
  • Engaging with the local data community through meetups or online forums.
  • Reading relevant books and blogs on data storytelling, visualisation, and advanced SQL techniques.

12The rising capability

The rising capability

Zavmo analysis

What's rising in its place

This is where the work is heading, and the higher pay with it. Get fluent here and the shift stops being a threat and starts being your edge.

Prompt Engineering & LLM Integration

Competitors are already using Large Language Models (LLMs) to draft reports in minutes that used to take hours. Analysts who figure this out will outproduce peers significantly. It's about working smarter, not harder.

  • Context windows and token limits
  • Temperature settings for different tasks
  • RAG (Retrieval Augmented Generation) architectures
  • Output validation and hallucination detection

Advanced Data Storytelling & Visualisation

As data becomes more complex, the ability to simplify and communicate insights effectively becomes even more critical. It's not enough to just build a dashboard; you need to make it compelling and memorable.

  • Narrative structure for data presentations
  • Cognitive load reduction in dashboards
  • Ethical data visualisation
  • Interactive storytelling techniques

13What you’ll use

What you’ll use

Skills this role draws on

Technical

  • Data Modelling Fundamentals
  • Experimentation & A/B Testing Fundamentals
  • Basic Predictive Analytics
  • Data Governance Principles

14The pathway

The pathway

How you actually get there, here

How you become one varies far more by country than what one does. This is the UK route. Most people take one of these ways in; the right one depends on where you're starting from.

  1. 1

    Junior Data Analyst (L1)

    1-2 years

    Skills to master

    • Mastering SQL queries, building basic dashboards, understanding core business metrics, and learning our data ecosystem.

    You're ready to move on when

    • Consistently delivering accurate reports with minimal supervision.
    • Proactively identifying minor data issues.
    • Demonstrating a solid grasp of our key datasets and their relationships.
  2. 2

    Business Intelligence Specialist

    2-3 years

    Skills to master

    • Deep expertise in a specific BI tool (e.g., Tableau, Power BI), advanced dashboard design, and data modelling for reporting.

    You're ready to move on when

    • Building highly performant and user-friendly dashboards.
    • Being the go-to person for complex BI tool features.
    • Successfully training business users on BI tools.
  3. 3

    Analyst from a related field (e.g., Finance, Marketing)

    2-4 years

    Skills to master

    • Transitioning domain expertise into data analysis skills, strengthening SQL and Python, and learning data warehousing concepts.

    You're ready to move on when

    • Successfully applying analytical techniques to new datasets.
    • Demonstrating strong foundational technical skills.
    • Quickly adapting to new data environments and tools.

15Where this role leads

The long view: This work can lead to managing a team of analysts, specialising deeply in a technical area, or moving into roles that shape data strategy for an organisation.

16Pay and demand

ONS's coding index maps “Data Analyst” to more than one occupation, so there is no one median to quote. Rather than pick, here is each one it could be, with its own figure:

  • Programmers and software development professionals £56,914 a year
  • Data analysts £38,572 a year

ONS Annual Survey of Hours and Earnings, from the April 2025 survey, about six months old when published, as ASHE always is, under the Open Government Licence.

The ten Future Fluencies

Zavmo analysis

The credential is what you can do today. These are what keep you valuable.

A qualification proves you can do the job as it's defined today. These ten are what decide whether you're still the obvious person for it in five years. They're the capabilities employers are now writing into senior roles faster than people are learning them. Zavmo weaves them through whatever you study, so you come out with both: the credential and the fluency.

The highlighted ones are the Fluencies your role leans on hardest, from how Data Analyst is actually changing.

Where it leads

Roles this leads to

How you would learn this

One to one, on the work you already do

A tutor sets the task against your own job and marks the reasoning, at your pace. There is no cohort to fall behind.

A lesson from Data Analytics Primer, worked against Data Analyst.

Data Analytics Primer Level 4

Applied to your work in Data Analyst

This unit aims to equip learners with a foundational understanding of data analytics, including its applications and the stages of the data analysis lifecycle. Learners will explore various data types and structures, understand the role of data within an organisation, and recognise the importance of GDPR and compliance requirements in data handling.

How the thinking builds
  1. 1 Remember
  2. 2 Understand
  3. 3 Apply
  4. 4 Analyse
  5. 5 Evaluate
  6. 6 Create
An illustration of a Zavmo lesson, built from this role’s own route. The unit, its objective and every criterion above are the awarding body’s own words, not an example.

It is £70 a month, billed monthly. Your free first module is Future Fluency, and you can cancel any time.

Start my Data Analyst plan, free
See Your Progress Grow Illustration
Data Analyst
  • Data Modelling Fundamentals
  • Experimentation & A/B Testing Fundamentals
  • Basic Predictive Analytics
  • Data Governance Principles
This is your Mind Palace on learn.zavmo.ai. Every skill above comes from this role's own record, not an example borrowed from another job. A node lights up when you evidence it, and what you build stays yours between jobs. That is the part a course cannot do.

17The detail, folded away

Everything else the record holds

The career branches in full, how AI is already showing up in the day-to-day, and the questions people ask about this job. Here when you want them, out of the way while you decide.

Where it leads next, rung by rung

Where it leads

The career path, and where it branches

Data Analyst is a start, not a ceiling. Each step below asks for new skills and hands back more autonomy.

  1. Senior Data Analyst (L3)

    3-5 years from this role

    You'll move from owning individual analyses to leading entire analytical projects and mentoring junior team members. You'll have more autonomy and influence.

    • Advanced Statistical Modelling (e.g., time series, causal inference)
    • Data Architecture & Pipeline Design (contributing to)
    • Advanced Python for Data Science (e.g., scikit-learn, PySpark)
    • Data Governance Implementation
Working with AI on the job

Working with AI

Where AI is starting to help

Let's be real, a lot of data analysis can be repetitive. Imagine having a smart assistant that handles the grunt work, freeing you up for the really interesting stuff. That's what AI-powered tools are doing for data analysts right now.

We're not talking about replacing your brain; we're talking about supercharging it. These tools help you get to insights faster, write better code, and communicate more effectively, giving you back precious hours every week. Here's how you'll actually use AI day-to-day:

Automated Report & Summary Drafting

Use AI to generate initial drafts of your weekly or monthly performance summaries. Feed it your dashboard data and key metrics, and it'll write the narrative, highlight trends, and even suggest insights. You'll then refine it, adding your expert touch.

Data Exploration & Hypothesis Generation

Instead of manually hunting for anomalies, AI tools can proactively flag unusual patterns or interesting correlations in your datasets. Ask an LLM 'what are some hypotheses for why sales dropped in Q3?' and get a list of starting points for your deep dives.

Code & Query Optimisation

Stuck on a complex SQL query or a tricky Python function? AI assistants can suggest optimal code, debug errors, and even translate natural language requests into executable code. It's like having a senior engineer looking over your shoulder, 24/7.

Documentation & Knowledge Management

Automatically summarise complex technical documentation, create clear comments for your code, or draft explanations of your dashboard logic. AI can turn your raw notes into structured, searchable knowledge, making life easier for everyone.

Common questions

Common questions

How do you become a Data Analyst?

Common routes in include Junior Data Analyst (1-2 years), Business Intelligence Specialist (2-3 years) and Analyst from a related field (e.g., Finance, Marketing) (2-4 years). Times vary with prior experience.

Where can a Data Analyst progress to?

This role can lead on to Senior Data Analyst (3-5 years from this role), depending on the skills you build.

What new skills matter most for a Data Analyst?

Increasingly, Prompt Engineering & LLM Integration and Advanced Data Storytelling & Visualisation. These are the skills our record of this role lists as growing.

Free tools

Want a read on where you stand?

Three free tools, no account needed. Each one ends with a role, a level and a way in.

Read the Zavmo manifesto to understand how you will be taught Meet your tutors

Or try another one

18Where to go from here

Other roles at Level 3

Same depth of qualification, different job. Useful if the work appeals but this particular role does not.
This job at other levels
More jobs in technology and data

Stay in the field you know and move sideways rather than up.
If you leave this industry

The skills used in data analysis apply across most industries. Finance, healthcare and e-commerce all need people who can make sense of data, so this work builds a foundation for a wide range of paths.

This role profile is © 2026 Growth Engineering Technologies Ltd. Built from UK occupational standards and regulated qualification data, and written for Zavmo.

You're not behind. You're right on time. The shift is only just beginning. Your role won't look the same in two years. Be the one who leads the change, not the one it happens to. Start my Data Analyst plan, free What happens next: a free account, then we build your plan as you set up. No card. Build your plan, see your roadmap and meet the twelve tutors matched to you. All free. When you're ready to start learning, it's £70 a month, billed monthly. Cancel any time and billing stops.