Analytics engineer vs data analyst: which role, and which funded route, is yours?

By James Cotton, Founder, iO-Sphere

What we compared

We compared two data roles a career-changer or upskilling professional actually chooses between, data analyst and analytics engineer, on the axes that decide which suits you: the day's work, the tools, the funded route in, cost, salary, time to competence, and where each leads next. The salary figures are dated inline (data analyst from ONS ASHE 2025 provisional; analytics engineer from a 2026 advertised-market source, so treat it as one sample). Comparison correct as of July 2026.

Our view, stated plainly: choosing a decade of daily work off a median salary difference is how people end up in jobs they quietly hate. Read the work, not the rank. An analyst answers questions; an analytics engineer builds and feeds the plumbing that makes those answers trustworthy. Neither sits above the other: they're different jobs, not tiers.

Data analyst: the widest door in

A data analyst answers business questions with data: pulling the numbers, cleaning them, building the dashboard, and, the part that actually matters, telling someone what to do about it. If you like the moment where a messy question becomes a clear recommendation, this is your work. The core toolset is SQL to reach the data, a BI tool like Power BI or Tableau to show it, and Excel more often than anyone admits.

It's also the widest door into the whole domain. There is a Skills England-approved Data Analyst apprenticeship standard at Level 4 with a typical duration of 24 months (skillsengland.education.gov.uk); our Data Analyst apprenticeship delivers that standard in 15 months of training plus a 3-month end-point assessment. Entry needs English and maths to Level 2 (a GCSE pass, grade 9 to 4), and if you're aged 19 or over you can work toward those on-programme rather than holding them up front (analysisfunction.civilservice.gov.uk).

Where it falls short: if you want to live in code, build pipelines and rarely present to stakeholders, analyst work will feel thin. That pull toward the engineering side is the signal you might be an analytics engineer.

Analytics engineer: the builder in the middle

An analytics engineer sits between the raw data and the analysts, turning messy source tables into clean, tested, reusable data models: so that when an analyst asks a question, the numbers are already trustworthy. The day's work is code: SQL and increasingly dbt for modelling, Python for the trickier transformations, and a working grip on the data pipeline and warehouse underneath. If you get more satisfaction from a well-built model than a well-received slide, this is you.

The honest catch for the funded route: there is no Skills England-approved apprenticeship standard named "Analytics Engineer." The nearest funded path is the Level 5 Data Engineer standard (ST1386), which our Data Engineering apprenticeship delivers, again in 15 months plus a 3-month assessment against a standard whose typical duration is 24 months. Most people don't start here cold, though. Analytics engineering is usually entered from adjacency: after you've done analyst work, seen where the data breaks, and started fixing it.

Where it falls short: it's a poor first door for a complete beginner, and if you love the business conversation more than the build, you'll miss it.

Which should you choose?

If you want to turn data into decisions and talk to the business, choose the data analyst route. It's the widest door in, it has a real funded Level 4 standard, and the median UK salary for the role is £38,107, rising to £46,152 at the 75th percentile where senior roles begin (ONS ASHE Table 14, 2025 provisional). It is not for you if you want to live in code and rarely present.

If you'd rather build the models everyone queries, analytics engineering is the work, but the funded route runs through the Level 5 Data Engineer standard, not a role-named one. Advertised mid-level packages sit around £60,000 to £85,000 in London, per one 2026 market source (dataengineeringjobs.co.uk, accessed July 2026): treat that as an advertised sample, not a national measure.

If you're a complete beginner unsure which fits, start as an analyst. You'll see real data problems, and analytics engineering is far easier to move into once you're inside doing the work than to jump into cold. The cost of "choosing wrong" is low: it's one domain with many doors.

If you already work near data and want the engineering side: the Data Engineer (Level 5) route is the honest funded answer. The analyst route would be a step sideways, not up.

Key figures at a glance

If the analyst door is the one that fits, our Data Analyst apprenticeship delivers the Level 4 standard through real, coached work on live-scale data. Explore it, or talk to us about which door is yours →