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.

Upskilling a team in this role? Talk to us

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

Also advertised as Analytics Specialist · Business Intelligence Analyst · Data Insights 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

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
Creating and Interpreting Visualisations in Data Science Qualifi Level 3 Extended Diploma in IT and Data Science
Data Analytics Pearson BTEC Level 4 Higher National Certificate in Computing for England
Data visualisation Cambridge OCR Level 3 Alternative Academic Qualification Cambridge Advanced National in IT: Data Analytics (Extended Certificate)

The future skills this job leans on

AI Fluency working with AI as a thinking partner
Data Fluency turning numbers into a decision
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 7 of 10 standards Level 4
  2. Creating and Interpreting Visualisations in Data Science Qualifi Ltd · covers 3 of 10 standards Level 3
  3. Data Analytics Pearson Education Ltd · covers 3 of 10 standards Level 4
  4. Data visualisation Cambridge OCR · covers 2 of 10 standards Level 3
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 skill this role is being asked for

  • Prompt Engineering & LLM Integration
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 turns raw data into clear insights that support decisions. You look for patterns in spreadsheets and databases, then explain what they mean. Work often involves owning analytical projects from start to finish, with independent work balanced by guidance from a manager or senior colleague when needed.

4What you'd actually use

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

SQL (PostgreSQL, T-SQL) Intermediate

Writing complex queries to extract, transform, and join data from various tables in our data warehouse. You'll be using `JOIN`s, `GROUP BY`s, `WHERE` clauses, and probably some `CASE` statements daily.

Tableau / Power BI Advanced

Designing and building interactive dashboards from scratch that answer specific business questions. You'll manage data sources, create calculated fields, and ensure the visualisations are clear and easy to understand.

Python (pandas, NumPy, Matplotlib) Intermediate

Using pandas for more complex data cleaning, manipulation, and transformations that are harder in SQL. You'll also use it for statistical analysis and automating recurring reporting tasks, often in a Jupyter Notebook.

Snowflake / Google BigQuery Power User

Connecting to the data warehouse, writing optimised queries that make the most of its features, and understanding how our data is structured within it. You'll investigate data lineage and quality issues here.

Git (via GitHub/GitLab) Practitioner

Using Git for all your analytical code. This means managing branches for different projects, creating pull requests for code reviews, and collaborating with other analysts on shared scripts.

Jira / Confluence Power User

Managing your own tasks and project tickets in Jira, tracking progress, and providing updates. You'll also be creating and maintaining well-structured documentation for your analyses and data processes in Confluence.

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
Analytical Approach (e.g., methodology, tools for a specific analysis) Propose to supervisor, execute after approval. Choose independently for routine tasks; consult with manager for novel or high-impact analyses. Define independently, inform manager.
Data Source Selection for a New Report Identify potential sources, seek supervisor's confirmation. Select appropriate data sources; escalate if new integration or significant data cleaning is needed. Identify, select, and champion new data sources; define integration requirements.
Dashboard Design & Publication Build based on template, supervisor reviews before publishing. Design and build new dashboards; peer review before publishing to wider audience. Design, build, and publish; define best practices for others.
Project Prioritisation (for your own workload) Follow manager's priorities, escalate conflicts. Manage your own task queue, flag potential conflicts or missed deadlines to manager. Prioritise own and mentor's work, negotiate with stakeholders, inform manager of significant shifts.

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 & Dashboard Accuracy
The percentage of your reports and dashboards that are free from data errors or miscalculations.
Target · 99.5% accuracy on all published work

You build a new dashboard for the Product team. After a week, they confirm all numbers match their internal checks, and there are no discrepancies reported.

Ad-hoc Request Resolution Time
How quickly you turn around those 'urgent' one-off data requests from business teams.
Target · 85% of ad-hoc requests completed within 48 hours

A Marketing Manager asks for customer segmentation data on Tuesday morning; you deliver the analysis and a summary by Thursday afternoon.

Dashboard Usage & Adoption
How often the dashboards you build are actually used by your target audience.
Target · Maintain >70% monthly active users on key dashboards you own

Your 'Product Feature Usage' dashboard consistently shows 15-20 unique users accessing it daily, indicating it's a go-to resource for the Product team.

Query Optimisation
The efficiency of your SQL queries, especially for recurring reports.
Target · Reduce average query run-time for recurring reports by 15% quarter-on-quarter

You refactor a daily report query from taking 10 minutes to 3 minutes, freeing up database resources and getting data to users faster.

Clarity of Insights
How well you explain complex data findings in simple, actionable terms to non-technical colleagues.
  • Stakeholders consistently say your explanations are easy to understand. They can repeat your key findings and recommendations accurately. They don't need follow-up meetings to 'decode' your reports. You're often asked to present your findings directly to broader teams.
Proactive Problem Identification
Your ability to spot potential issues or opportunities in the data before someone else asks you to look.
  • You bring unexpected trends or anomalies to your manager's attention. You propose new analyses that weren't explicitly requested but could add value. You flag data quality issues you discover during your work, rather than waiting for them to break a report.
Stakeholder Engagement & Partnership
How effectively you work with your business partners to understand their needs and deliver relevant analysis.
  • Stakeholders see you as a trusted partner, not just a data provider. They involve you early in their planning processes. They give positive feedback on your collaborative approach. You ask clarifying questions that help them refine their requests.

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 messy, ambiguous business question and breaking it down into a clear, answerable data problem. Finding that 'aha!' moment in the data is what drives you.

You're given a vague request about 'why sales are down'. You enjoy the process of digging into different datasets, trying various angles, and finally pinpointing a specific marketing campaign that underperformed.

Making an Impact

You want your work to actually be used and make a difference. Seeing your analysis lead to a change in product design or a more efficient process is really important to you.

Your analysis shows that users drop off significantly at a certain step in the sign-up flow. The product team uses your findings to redesign that step, and you see conversion rates improve by 10% next month.

Learning & Growing

You're always keen to pick up new tools, techniques, or ways of thinking about data. You're not afraid to admit you don't know something and will actively seek out ways to learn.

You've been using SQL and Tableau, but you're eager to get better at Python for more advanced statistical analysis. You'll spend some of your own time learning new libraries or asking senior colleagues for advice.

What frustrates people
  • Being a 'data janitor' – spending 60% of your time cleaning and preparing data.
  • Getting vague requests like 'pull data on user engagement' without clear definitions.
  • Stakeholders changing their minds or adding new requirements mid-analysis.
  • Discovering a broken data pipeline on Monday morning, making all your dashboards stale.
  • Explaining statistical significance (or lack thereof) only for it to be ignored.
  • The 'quick question' from a VP at 4 PM on a Friday that isn't quick at all.
What this role does not give you
  • A perfectly clean, ready-to-use dataset every time.
  • A guarantee that every insight you generate will be immediately acted upon.
  • A role where you only do advanced modelling; there's a lot of foundational work.
  • Complete autonomy over strategic direction; you're informing, not setting, strategy.

8Who you work with

Your work directly influences daily operational decisions and contributes to quarterly strategic planning. You'll help teams understand 'why' things are happening, not just 'what' happened. For example, your analysis might show why a certain feature isn't being adopted, leading to a product redesign, or identify a bottleneck in our customer onboarding process, saving us money and improving user experience. You're essentially providing the evidence base for our business to evolve and improve.

Inside the business
  • Product Managers (for feature analysis, A/B testing)
  • Marketing Team (for campaign performance, customer segmentation)
  • Operations Team (for efficiency metrics, process optimisation)
  • Engineering Team (for data quality issues, new data sources)
  • Senior Data Analysts (for peer review and collaboration)
Outside the business
  • None (typically, this role is internally focused)

9What you need before you start

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

  • A solid 2-3 years of experience working as a Data Analyst or in a very similar role, where you were responsible for end-to-end analysis.
  • Proven ability to write complex SQL queries independently, including joins, subqueries, and aggregation functions, to solve business problems.
  • Demonstrable experience building interactive dashboards and visualisations in either Tableau or Power BI from scratch, not just using templates.
  • Practical experience with Python (using libraries like pandas) for data manipulation and exploratory data analysis.
  • A track record of taking vague business questions and translating them into clear analytical plans and actionable insights.
  • Experience collaborating on code using Git (e.g., GitHub or GitLab) for version control.

10What to practise next

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

Advanced Data Modelling & ELT Design

As our data grows and our business questions get more complex, simply pulling data won't be enough. You'll need to understand how to design efficient, scalable data models (like Kimball's dimensional modelling) and build robust ELT (Extract, Load, Transform) pipelines to get data ready for analysis. This isn't just for data engineers anymore.

Star & Snowflake Schemas · Fact & Dimension Tables · Incremental Loading · Data Orchestration Tools (e.g., dbt, Airflow concepts)

  • This week: Read up on Kimball's dimensional modelling principles – there are plenty of free resources online.
  • This month: Take one of our existing recurring reports and sketch out how you would re-model the underlying data for better performance and clarity.
  • Month 2: Ask a Senior Analyst or Data Engineer to walk you through how our current data models are designed in Snowflake/BigQuery.
  • Month 3: Propose a small improvement to an existing data model or ELT process, even if it's just for a single table.

Quick win: Start thinking about the 'source of truth' for every metric you report. Can you trace its lineage? Is it modelled efficiently? This mental exercise is the first step.

11Staying current once you are in

What people here do to keep up
  • Actively participate in online data communities (e.g., Kaggle, Reddit's r/dataanalysis) to learn from peers and share knowledge.
  • Follow industry blogs and thought leaders to stay updated on new tools, techniques, and best practices.
  • Take online courses (e.g., Coursera, Udemy, DataCamp) to deepen your skills in Python, advanced SQL, or statistical methods.
  • Attend local data meetups or webinars to network and learn from others in the field.
  • Contribute to open-source projects, even small ones, to practice collaboration and improve your coding skills.

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

Honestly, competitors are already using tools like ChatGPT and Claude to draft reports in 10 minutes that used to take 2 hours. Analysts who figure out how to use these effectively will outproduce their peers significantly. This isn't future tech; it's happening now.

  • Context Windows & Token Limits
  • Temperature Settings
  • RAG Architectures (Retrieval Augmented Generation)
  • Output Validation & Hallucination Detection

13What you’ll use

What you’ll use

Skills this role draws on

Technical

  • A/B Testing & Experimentation Design
  • Funnel Analysis
  • Statistical Analysis
  • Data Modelling for Analytics
  • Root Cause Analysis (RCA)

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 / Associate Data Analyst

    2-3 years

    Skills to master

    • SQL querying for basic reporting, introductory Python for data manipulation, building simple dashboards, understanding business requirements.

    You're ready to move on when

    • Can independently deliver accurate, well-formatted data pulls for common requests.
    • Has built and maintained at least one functional dashboard.
    • Proactively identifies minor data inconsistencies and flags them.
    • Clearly communicates basic findings to non-technical audiences.
  2. 2

    Business Analyst with Strong Technical Skills

    3-4 years

    Skills to master

    • Translating business problems into data questions, advanced Excel/Google Sheets, basic SQL, understanding of business processes and KPIs.

    You're ready to move on when

    • Consistently uses data to support business recommendations.
    • Can write intermediate SQL queries to answer their own business questions.
    • Has experience presenting data-driven insights to management.
    • Understands the 'why' behind key business metrics.
  3. 3

    Recent Graduate (Master's in Data Science/Analytics) with Internships

    1-2 years (post-grad)

    Skills to master

    • Statistical methods, machine learning fundamentals, Python/R programming, data visualisation theory, project management basics.

    You're ready to move on when

    • Has completed relevant projects during studies or internships, demonstrating practical application of skills.
    • Can articulate complex statistical concepts clearly.
    • Comfortable working with large datasets and common analytical tools.
    • Eager to learn and apply academic knowledge in a commercial setting.

15Where this role leads

The long view: This work can lead to a technical lead role, a management path overseeing a team of analysts, or a specialist role as a principal analyst.

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
  • A/B Testing & Experimentation Design
  • Funnel Analysis
  • Statistical Analysis
  • Data Modelling for Analytics
  • Root Cause Analysis (RCA)
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 in current role

    You'll move from owning projects to owning entire workstreams and tackling more ambiguous, complex business problems. You'll also start mentoring junior colleagues.

    • Advanced statistical modelling (e.g., time series, multivariate regression)
    • Designing and implementing scalable analytical solutions (e.g., new data models)
    • Proactive identification of business opportunities through data
    • Leading data quality initiatives and data governance discussions

  2. Data Engineer (L2/L3 equivalent, with additional training)

    3-6 years in current role + dedicated upskilling

    This is a shift in specialisation. You'd move from analysing data to building and maintaining the robust pipelines and infrastructure that deliver the data.

    • Advanced Python for data engineering (e.g., Apache Spark, Airflow)
    • Cloud platform services (AWS, GCP, Azure for data pipelines)
    • Database administration and optimisation
    • Building and maintaining ETL/ELT pipelines
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 or just plain tedious. Imagine if you could cut down on those mundane tasks, freeing you up for the interesting, challenging stuff. Well, you can. We're bringing AI tools into our daily workflow to help you do just that.

For a Data Analyst, AI isn't here to replace you; it's here to be your super-smart assistant. Think of it as having an extra pair of hands that can write code, spot anomalies, and even draft summaries faster than you can brew a cuppa. We're building an AI Productivity Hub specifically for Technical_roles, and here's a sneak peek at how it'll change your day-to-day.

SQL & Python Co-Pilot

Use AI assistants like GitHub Copilot or ChatGPT to automatically generate boilerplate SQL queries or Python scripts. Need to clean some data or perform a specific join? Just tell the AI what you want, and it'll draft the code for you. You'll still need to review and refine it, of course, but it's a massive head start. This means less time wrestling with syntax and more time on the actual analysis.

Automated Anomaly Detection

Forget manually scanning hundreds of KPIs for weird spikes or dips. AI-powered monitoring tools can automatically scan all your key metrics and flag statistically significant anomalies. It'll point you directly to what's broken or what's suddenly working really well, so you can investigate the 'why' much faster. No more missing critical shifts in data behaviour.

Contextual Code Explainer

Ever inherited a really complex, undocumented SQL query or Python script from someone who's left the company? Instead of spending hours trying to reverse-engineer it, just paste it into an AI tool. Ask it to explain, step-by-step, what the code does in plain English. It's like having a senior developer on call to walk you through legacy code, saving you loads of frustration.

Insight Summary Generator

After you've done all the hard work of analysis, the last thing you want is to spend ages drafting an email or slide deck. Feed your key bullet points, charts, and findings into an AI tool, and ask it to draft a concise summary for a non-technical audience. It'll help you articulate your key message clearly and impactfully, so your insights land better and faster.

Common questions

Common questions

How do you become a Data Analyst?

Common routes in include Junior Data Analyst / Associate Data Analyst (2-3 years), Business Analyst with Strong Technical Skills (3-4 years) and Recent Graduate (Master's in Data Science/Analytics) with Internships (1-2 years (post-grad)). Times vary with prior experience.

Where can a Data Analyst progress to?

This role can lead on to Senior Data Analyst (3-5 years in current role) and Data Engineer (3-6 years in current role + dedicated upskilling), depending on the skills you build.

What new skills matter most for a Data Analyst?

Increasingly, Prompt Engineering & LLM Integration. 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.

 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 built as a data analyst apply across most industries. Tech, finance, healthcare and retail all need people who can turn data into useful insight. Translating complex data into clear findings is useful wherever data exists.

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.