Data Analyst
Turns messy business data into an answer someone can act on, and says clearly when the data can't answer it.
Role at a glance
The shape of the job
Pay bands are TechWaymark practitioner estimates for UK roles, reviewed 2026-09, not survey data. They vary by region, sector and employer.
What the Data Analyst role involves
- You get questions like 'why did sales drop in March?' and turn them into something data can actually answer.
- You write SQL to pull data, then check it: duplicates, missing rows, a date field that means something different in each system.
- You build reports and dashboards, usually in Power BI, Tableau or Excel, that people use without you in the room.
- You explain what the numbers show, what they don't, and where you'd be careful.
Read TechWaymark's full role verdict and reasoning
Data analysis turns a business question into a defensible interpretation of evidence.
- Domain
- Data
- Entry
- Not mapped
- Senior
- Not mapped
- You enjoy SQL, structured questions and clear answers
- You can write a report that changes a decision
- You want to explore analytics engineering or data science responsibilities
- You can be patient with messy data without losing precision
- You wanted to build models or pipelines, this isn't that yet
- You'd resent stakeholder requests that keep changing
- You expect dashboards to be a satisfying long-term identity
What "doing well" looks like in the seat
- Your queries are reused by colleagues
- Your reports surface findings that change behaviour
- Stakeholders ask for you on the rebook
- You're already studying dbt, Python or analytics engineering work
A clean dashboard can conceal inconsistent definitions or a biased sample. Clarify data ownership and how conclusions are challenged before decisions are made.
Illustrative
A day in the role
- A director asks why customer numbers look different in two reports. Start tracing both
- Found it. One report counts accounts, the other counts people. Write that down clearly
- Update the weekly sales dashboard and check the refresh didn't silently fail
- Meeting with marketing. They want proof a campaign worked. Explain what the data can and can't show
- Write SQL for a new report and test it against last month's known figures
- Send a short note with the answer, the caveats and one chart
An example day. Roles and organisations vary, and no two days match.
Day to day
What you'll work with
Systems
Tools
Concepts
Hiring reality
What employers actually expect
Must understand
- Write correct SQL and check the result
- Explain findings in plain English
- Ask what decision the question serves
- Admit uncertainty
Commonly expected
- Power BI or Tableau
- Strong Excel
- Some statistics
- A portfolio or work examples
Sets you apart
- Domain knowledge (finance, retail, health)
- Python for cleaning data
- A story where you corrected a wrong number
- Clear written summaries
What this role isn't
It isn't data science, and it isn't mostly building dashboards. The hard part is working out what the question really is and whether the data is fit to answer it. Pretty charts come last.
How the role changes with seniority
Runs and updates existing reports, writes queries with review, learns the business definitions.
Owns a business area, answers questions end to end, builds reports people rely on.
Sets definitions, challenges bad questions, guides other analysts and advises decision-makers.
Nobody puts this in the advert
The hard parts
Bad data
Most time goes on finding out why numbers don't match. It's rarely glamorous.
Answer-shopping
Some people want data to back a decision already made. Holding the line takes nerve.
Dashboard sprawl
Reports multiply, nobody switches old ones off, and you end up maintaining them all.
A popular career change
Lots of people retrain into it. A portfolio with real reasoning stands out more than a course certificate.
More than one way in
How people actually get into it
From a business role
Very common. The person in finance or operations who became the spreadsheet expert moves across.
Apprenticeship
Data analyst apprenticeships are widely available and well recognised.
Graduate route
Degrees with maths, economics or social science methods fit well.
Self-taught with a portfolio
SQL plus two or three honest analyses of public data. The reasoning matters more than the tool.
Evidence employers value
"Built dashboards in Power BI"
Built a stock report the warehouse team now use daily, replacing three spreadsheets
"Strong SQL skills"
Found a double-count in the monthly revenue query and corrected a figure going to the board
"Data-driven"
Told marketing their campaign data couldn't prove the result, and suggested a test that could
Projects that prove it
Small pieces of work you can do on your own, and what each one shows an employer.
Answer one real question with public data
3-4 eveningsPick a UK open dataset, ask a specific question, and write a one-page answer with a chart and a clear note on the limits.
What it demonstrates
Reconcile two sources
2-3 eveningsTake two datasets that should agree but don't. Work out why, and write a short note explaining the difference.
What it demonstrates
Build a report someone uses
2 weekendsMake a small dashboard for a club, charity or friend's business. Get feedback and change it based on how they use it.
What it demonstrates
Your next hops
Where Data Analyst can take you
Other common branches
There is no single ladder. See the routes on the Atlas.
Interview reality
Questions you may be asked
Loading questions…
Practise with model answers in My WaymarkFor educators
Used in TechWaymark Education
These modules use this page as investigation material in the classroom.
- 1Technology is not one career
An example of work that mainly analyses information to help people decide
Could you realistically get here from where you are?
The Guided Route compares your background with this role and shows the honest route, hop by hop.
Last reviewed 2026-09. Photographs are illustrative.