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
- Compare the responsibilities of data analyst, analytics engineer and data engineer
- Explain ELT and why it replaced ETL for most warehouse work
- Trace data from source system through ingestion to a dashboard
- Identify which stack layer owns a given problem
- Describe how each tool in the stack is replaceable
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.
Other units in this stage
Back to the full Analytics Engineer roadmap