Domäne
Data Engineering
Skill-Profil
Medallion architecture, data zones, partitioning, compaction, storage organization
Rollen
2
wo dieser Skill vorkommt
Stufen
5
strukturierter Entwicklungspfad
Pflichtanforderungen
10
die anderen 0 optional
Data Engineering
Data Lakehouse
17.3.2026
Wählen Sie Ihr aktuelles Level und vergleichen Sie die Erwartungen.
Die Tabelle zeigt, wie die Tiefe von Junior bis Principal wächst.
| Rolle | Pflicht | Beschreibung |
|---|---|---|
| Analytics Engineer | Pflicht | Understands data lake zone architecture (raw, curated, consumption). Queries data from curated layers using SQL and dbt models. Follows team conventions for partitioning, file formats, and naming standards. |
| Data Engineer | Pflicht | Understands medallion architecture principles (bronze/silver/gold). Ingests data into raw landing zones using batch loaders and schema registries. Follows established patterns for Parquet/ORC file layout and catalog metadata. |
| Rolle | Pflicht | Beschreibung |
|---|---|---|
| Analytics Engineer | Pflicht | Independently builds analytics data products on top of data lake layers using dbt and Spark SQL. Optimizes query performance through intelligent partitioning and Z-ordering. Ensures data quality with Great Expectations checks at zone boundaries. |
| Data Engineer | Pflicht | Independently designs ETL pipelines across data lake zones with schema evolution support. Optimizes storage costs using lifecycle policies, compaction, and tiered storage. Implements data quality gates between medallion layers with automated validation. |
| Rolle | Pflicht | Beschreibung |
|---|---|---|
| Analytics Engineer | Pflicht | Architects data systems with Data Lake Architecture. Optimizes for big data. Implements data governance and quality frameworks. |
| Data Engineer | Pflicht | Designs data architecture with Data Lake Architecture. Optimizes for big data. Implements data governance and quality frameworks. |
| Rolle | Pflicht | Beschreibung |
|---|---|---|
| Analytics Engineer | Pflicht | Defines the data lake architecture for the analytics platform: medallion approach (bronze/silver/gold), storage format selection (Parquet, Delta, Iceberg). Implements partitioning and retention standards for cost optimization. |
| Data Engineer | Pflicht | Defines data lake standards: zone architecture (bronze/silver/gold), file formats, partition strategies. Implements access control and data classification. Coordinates between data producers and consumers. |
| Rolle | Pflicht | Beschreibung |
|---|---|---|
| Analytics Engineer | Pflicht | Architects the enterprise lakehouse: Delta Lake/Iceberg as open table format, integration with dbt for transformations, unified governance. Defines the strategy for combining data lake and warehouse for different analytical workloads. |
| Data Engineer | Pflicht | Designs data lakehouse architecture: unified storage layer, query engine federation (Trino/Spark), governance framework. Defines when lakehouse vs traditional DWH vs data mesh. |