Skip to main content

The Modern Data Stack for Analytics Engineers

The modern data stack is the cloud-based set of tools for moving and using data: ingestion tools load raw data into a warehouse, SQL transformations shape it, and BI tools present it. ELT replaces older ETL because the warehouse does the heavy transformation, which is where analytics engineers work.

Stage: Role and Foundations · Part of the Analytics Engineer roadmap · Last reviewed 19 November 2026

What to learn in The Modern Data Stack

The Modern Data Stack interview questions

Why does the modern data stack favour ELT over ETL?

ETL transforms data before loading it into the destination, while ELT loads raw data first and transforms it inside the warehouse. ELT works well because modern warehouses scale compute cheaply and keep raw data available for reprocessing. Cloud warehouses make in-warehouse transforms cheap.

How does an analytics engineer differ from a data engineer?

Data engineers focus on pipelines, infrastructure and getting data into the warehouse. Analytics engineers work after that, modelling data into trusted tables and metrics with SQL and dbt. The boundary varies by company, and the roles overlap.

Where The Modern Data Stack fits in the Analytics Engineer roadmap

The Modern Data Stack belongs to the Role and Foundations stage (beginner level), which takes about 6 hours. Where analytics engineering sits.

Back to the full Analytics Engineer roadmap