# Analytics Engineer

> A person who cleans raw data into tested tables. Others build on those tables.

**Field:** Data Engineering  
**Category:** Foundations  
**Also known as:** Analytics Engineering

## Think of it like

It is like a cook who chops the food first. Then others can cook fast.

## Definition

An analytics engineer is a person who turns raw data into clean tables. The job sits between the data engineer and the data analyst. They write SQL that cleans, joins and names the data. They add tests and notes so others can trust the tables. Analysts then build reports on top, without fixing the data first.

## Example

Jack is an analytics engineer. He writes one dbt model that joins orders and refunds into a tested table. Five analysts now use it instead of five spreadsheets.

## Why it matters

Without this role, each analyst cleans the same raw data in their own way. Then their numbers do not match.

## Common mistake

Thinking it is the same job as a data engineer. One brings the data in. The other shapes it so people can use it.

## Three principles

- **Model the data.** Turn raw tables into clean, named ones.
- **Test it.** Checks catch bad rows before reports do.
- **Serve analysts.** Build tables people can use without help.

## Related terms

- [Data Engineer](https://learn.benibix.com/term/data/data-engineer)
- [Data Analyst](https://learn.benibix.com/term/data/data-analyst)
- [dbt (Data Build Tool)](https://learn.benibix.com/term/data/dbt)
- [dbt Model](https://learn.benibix.com/term/data/dbt-model)
- [Structured Query Language (SQL)](https://learn.benibix.com/term/development/sql)
- [Semantic Layer](https://learn.benibix.com/term/data/semantic-layer)

## Told apart from

- [Data Engineer vs Analytics Engineer](https://learn.benibix.com/compare/data-engineer-vs-analytics-engineer): People think an analytics engineer is a data engineer with a new title. The data engineer brings raw data in from apps and files. They keep the pipes running. The analytics engineer shapes that raw data into clean, tested tables. One moves the data. The other makes it ready to use.

## Taught in

- [Data Roles and DataOps](https://learn.benibix.com/learn/data-foundations/data-roles-and-dataops): Data Engineering Basics, 2/11

![Raw data from apps, files and APIs flows right to a data engineer, who brings it in, then to an analytics engineer, who makes clean, tested tables. From there it splits in two: a data analyst, who asks what happened and why, and a data scientist, who asks what comes next.](https://learn.benibix.com/diagrams/dat-roles.svg)

---

Source: https://learn.benibix.com/term/data/analytics-engineer
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-20
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
