Skill-Profil

Advanced SQL

Dieser Skill definiert Erwartungen über Rollen und Level.

Database Management Relational Databases

Rollen

wo dieser Skill vorkommt

Stufen

strukturierter Entwicklungspfad

Pflichtanforderungen

die anderen 5 optional

Database Management

Relational Databases

22.2.2026

Wählen Sie Ihr aktuelles Level und vergleichen Sie die Erwartungen.

Was wird auf jedem Level erwartet

Die Tabelle zeigt, wie die Tiefe von Junior bis Principal wächst.

Rolle	Pflicht	Beschreibung
Data Scientist		Writes SQL queries for data extraction and analysis: JOIN, GROUP BY, HAVING, subqueries. Conducts EDA via SQL in data warehouses. Works with aggregate functions and basic window functions for analytical queries.

Rolle	Pflicht	Beschreibung
Data Scientist		Writes complex analytical SQL queries with window functions: LAG, LEAD, RANK, running totals. Creates CTE-based queries for feature engineering in data warehouses. Optimizes queries through EXPLAIN ANALYZE and proper indexing.

Rolle	Pflicht	Beschreibung
Data Scientist		Designs SQL-based feature pipelines for production ML systems. Optimizes queries for BigQuery/Redshift/Snowflake with partitioning, clustering, materialized views. Creates dbt models for reproducible data transformations.

Rolle	Pflicht	Beschreibung
Data Scientist		Defines SQL development standards for the data science team. Establishes shared SQL models and naming conventions. Coordinates data engineering and data science for effective data warehouse workflows.

Rolle	Pflicht	Beschreibung
Data Scientist		Shapes data warehouse strategy for ML workloads at organizational level. Defines architecture for feature computation: SQL-first vs Python-first approach. Evaluates emerging SQL engines and their fit for ML use cases.

Junior 1 Anforderungen

Data Scientist

Writes SQL queries for data extraction and analysis: JOIN, GROUP BY, HAVING, subqueries. Conducts EDA via SQL in data warehouses. Works with aggregate functions and basic window functions for analytical queries.

Middle 1 Anforderungen

Data Scientist

Writes complex analytical SQL queries with window functions: LAG, LEAD, RANK, running totals. Creates CTE-based queries for feature engineering in data warehouses. Optimizes queries through EXPLAIN ANALYZE and proper indexing.

Senior 1 Anforderungen

Data Scientist

Designs SQL-based feature pipelines for production ML systems. Optimizes queries for BigQuery/Redshift/Snowflake with partitioning, clustering, materialized views. Creates dbt models for reproducible data transformations.

Lead / Staff 1 Anforderungen

Data Scientist

Defines SQL development standards for the data science team. Establishes shared SQL models and naming conventions. Coordinates data engineering and data science for effective data warehouse workflows.

Principal 1 Anforderungen

Data Scientist

Shapes data warehouse strategy for ML workloads at organizational level. Defines architecture for feature computation: SQL-first vs Python-first approach. Evaluates emerging SQL engines and their fit for ML use cases.

Kommentare werden geladen...