← All roadmaps
● CAREER ROADMAP
Data Engineering & Analytics
Turn raw data into trusted pipelines, models and decisions.
Data Engineers and Analysts build the pipelines and models that turn messy raw data into trusted, decision-ready information. Demand is high across every industry, and the work spans hands-on engineering and business-facing analysis.
The complete Data Engineering & Analytics field roadmap - everything worth learning, from fundamentals to advanced. Highlighted core topics are the ones we take you through in the UstackSchool programme.
Core - taught in the programmeRecommendedOptional / advanced
1
Programming
PythonAdvanced SQLBashScalaJava
2
Relational Databases
PostgreSQLData modellingIndexing & query tuningTransactions & ACIDMySQL
3
NoSQL
RedisMongoDBCassandraDynamoDB
4
Data Warehousing
SnowflakeStar / snowflake schemaBigQueryRedshiftKimball dimensional modellingSlowly changing dimensions
5
ETL / ELT & Transformation
dbtBatch pipelinesPandasApache SparkData validation
6
Orchestration
Apache AirflowDAG designPrefectDagster
7
Ingestion & Integration
APIs & connectorsFivetran / AirbyteWebhooksChange data capture (Debezium)
8
Streaming
Apache KafkaSpark Structured StreamingFlinkKinesis
9
Storage & File Formats
Data lakes (S3)Parquet / ORC / AvroDelta Lake / IcebergPartitioning & compaction
10
Cloud & Infra
AWS coreIAMDockerCI/CD for dataTerraform basics
11
Data Quality & Governance
Data tests (dbt)Great ExpectationsData lineageCataloguingGDPR & privacy
12
Analytics & BI
Metrics / semantic layerLooker / Power BI / TableauReverse ETLStakeholder reporting
13
Get job-ready
End-to-end pipeline capstonePortfolioCertifications (dbt / AWS)Interview prep
Tools & technologies
SQLPython & pandasdbtAirflowSnowflake / BigQueryPower BI / Looker / TableauGitSpark (intro)
Ready to start the Data Engineering & Analytics path? Get the skills, portfolio and support to actually land the role.