Perfil de habilidad

Advanced SQL

Esta habilidad define expectativas en roles y niveles.

Database Management Relational Databases

Roles

donde aparece esta habilidad

Niveles

ruta de crecimiento estructurada

Requisitos obligatorios

los otros 5 opcionales

Database Management

Relational Databases

22/2/2026

Selecciona tu nivel actual y compara las expectativas.

Qué se espera en cada nivel

La tabla muestra cómo crece la profundidad desde Junior hasta Principal.

Rol	Obligatorio	Descripción
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.

Rol	Obligatorio	Descripción
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.

Rol	Obligatorio	Descripción
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.

Rol	Obligatorio	Descripción
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.

Rol	Obligatorio	Descripción
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 requisitos

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 requisitos

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 requisitos

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 requisitos

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 requisitos

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.

Cargando comentarios...