Analytics Engineer
Transforming raw data into analytics-ready models using dbt and SQL
Analytics Engineer es un rol en la familia Data Engineering. Tiene 53 habilidades en 5 niveles (de Junior a Principal). 147 habilidades son obligatorias. Dominios clave: Programming Fundamentals, Backend Development, Database Management.
Stack tecnológico
Enfoque por nivel
Writing dbt models. SQL transformations. Documenting models. Data quality tests. Working with data warehouse.
Designing analytical models (Star Schema, OBT). Setting up dbt best practices. Metrics layer. Orchestration.
Analytics stack architecture. Semantic layer. Data contracts. Performance optimization. Self-service analytics.
Analytics engineering strategy. Data modeling standards. Coordination with data and product teams. Data governance.
Enterprise analytics architecture. Data mesh analytics. Semantic layer strategy. Industry best practices.
Matriz de habilidades
53 habilidades × 5 niveles. Haga clic en una celda para ver detalles.
AI-Assisted Development
4 habilidades| Habilidades | Jun | Mid | Sen | Lead | Princ |
|---|---|---|---|---|---|
| GitHub Copilot | A | W | A | E | E |
| Cursor IDE | A | W | A | E | E |
| ChatGPT / Claude | A | W | A | E | E |
| Prompt Engineering for Code | A | W | A | E | — |
API & Integration
3 habilidades| Habilidades | Jun | Mid | Sen | Lead | Princ |
|---|---|---|---|---|---|
| REST API Design | A | W | A | E | E |
| GraphQL Design | A | W | A | E | E |
| API Documentation | A | W | A | E | E |
Architecture & System Design
1 habilidades| Habilidades | Jun | Mid | Sen | Lead | Princ |
|---|---|---|---|---|---|
| System Design Fundamentals | A | W | A | E | E |
Backend Development
4 habilidades| Habilidades | Jun | Mid | Sen | Lead | Princ |
|---|---|---|---|---|---|
| Python Web Frameworks | A | W | A | E | E |
| Apache Kafka | A | W | A | E | E |
| Redis | A | W | A | E | E |
| Elasticsearch / OpenSearch | A | W | A | E | E |
Cloud & Infrastructure
4 habilidades| Habilidades | Jun | Mid | Sen | Lead | Princ |
|---|---|---|---|---|---|
| Docker | A | W | A | E | E |
| Kubernetes Core | A | W | A | E | E |
| AWS | A | W | A | E | E |
| Network Fundamentals | A | W | A | E | E |
Data Engineering
12 habilidades| Habilidades | Jun | Mid | Sen | Lead | Princ |
|---|---|---|---|---|---|
| dbt | A | W | A | E | E |
| Pandas / Polars | A | W | A | E | E |
| SQL-based ETL | A | W | A | E | E |
| Data Lake Architecture | A | W | A | E | E |
| Data Warehouse Design | A | W | A | E | E |
| Data Catalog | A | W | A | E | E |
| Data Lineage | A | W | A | E | E |
| Data Contracts | A | W | A | E | E |
| Data Quality | A | W | A | E | E |
| Apache Airflow | A | W | A | E | E |
| Dagster / Prefect | A | W | A | E | E |
| BI Dashboards | A | W | A | E | E |
Database Management
6 habilidades| Habilidades | Jun | Mid | Sen | Lead | Princ |
|---|---|---|---|---|---|
| PostgreSQL | A | W | A | E | E |
| ClickHouse | A | W | A | E | E |
| Database Indexing | A | W | A | E | E |
| Query Optimization | A | W | A | E | E |
| Data Modeling & Schema Design | A | W | A | E | E |
| Database Migrations | A | W | A | E | E |
DevOps & CI/CD
1 habilidades| Habilidades | Jun | Mid | Sen | Lead | Princ |
|---|---|---|---|---|---|
| GitHub Actions / GitLab CI | A | W | A | E | E |
Observability & Monitoring
3 habilidades| Habilidades | Jun | Mid | Sen | Lead | Princ |
|---|---|---|---|---|---|
| Structured Logging | A | W | A | E | E |
| Prometheus & Grafana | A | W | A | E | E |
| OpenTelemetry | A | W | A | E | E |
Programming Fundamentals
8 habilidades| Habilidades | Jun | Mid | Sen | Lead | Princ |
|---|---|---|---|---|---|
| Algorithms & Complexity | A | W | A | E | E |
| Data Structures | A | W | A | E | E |
| OOP & SOLID Principles | A | W | A | E | E |
| Design Patterns | A | W | A | E | E |
| Multithreading | A | W | A | E | E |
| Async Programming | A | W | A | E | E |
| Code Quality & Refactoring | A | W | A | E | E |
| Type Safety & Type Systems | A | W | A | E | E |
Security
2 habilidades| Habilidades | Jun | Mid | Sen | Lead | Princ |
|---|---|---|---|---|---|
| OWASP & Application Security | A | W | A | E | E |
| Secure Coding Practices | A | W | A | E | E |
Testing & QA
2 habilidades| Habilidades | Jun | Mid | Sen | Lead | Princ |
|---|---|---|---|---|---|
| Unit Testing | A | W | A | E | E |
| Integration Testing | A | W | A | E | E |
Version Control & Collaboration
3 habilidades| Habilidades | Jun | Mid | Sen | Lead | Princ |
|---|---|---|---|---|---|
| Git Advanced | A | W | A | E | E |
| Code Review | A | W | A | E | E |
| Documentation as Code | A | W | A | E | E |
Preguntas frecuentes
¿Qué habilidades se necesitan para el rol de Analytics Engineer?
El rol de Analytics Engineer requiere 53 habilidades, de las cuales 147 son obligatorias. Las habilidades se distribuyen en 5 niveles: de Junior a Principal. Ver matriz completa.
¿Cómo avanzar al siguiente nivel en el rol de Analytics Engineer?
Use la Calculadora de grado para evaluar su nivel actual y obtener recomendaciones personalizadas.
¿Qué stack tecnológico se usa en el rol de Analytics Engineer?
El stack incluye 5 tecnologías en diferentes niveles. SQL, dbt Core, ClickHouse/BigQuery/Snowflake, Git, YAML, Jinja basics, SQL advanced, dbt (macros, packages, tests), ClickHouse/BigQuery, Airflow, Great Expectations, Looker/Metabase, dbt advanced (custom materializations), Semantic layer (MetricFlow/Cube), Data contracts, Data quality frameworks...
¿Cómo define la comunidad los requisitos para el rol de Analytics Engineer?
Los requisitos del rol son definidos por la comunidad a través de un sistema de propuestas. Cualquier miembro puede sugerir cambios que pasan por votación y revisión de expertos.