Analytics Engineer
Transforming raw data into analytics-ready models using dbt and SQL
Analytics Engineer是Data Engineering族群中的角色。涵盖5个级别的53项技能（从Junior到Principal）。其中147项为必备技能。关键领域：Programming Fundamentals, Backend Development, Database Management。
技术栈
各级别重点
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.
技能矩阵
53 技能 × 5 级别. 点击单元格查看详情。
AI-Assisted Development
4 技能| 技能 | 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 技能| 技能 | 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 技能| 技能 | Jun | Mid | Sen | Lead | Princ |
|---|---|---|---|---|---|
| System Design Fundamentals | A | W | A | E | E |
Backend Development
4 技能| 技能 | 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 技能| 技能 | 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 技能| 技能 | 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 技能| 技能 | 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 技能| 技能 | Jun | Mid | Sen | Lead | Princ |
|---|---|---|---|---|---|
| GitHub Actions / GitLab CI | A | W | A | E | E |
Observability & Monitoring
3 技能| 技能 | 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 技能| 技能 | 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 技能| 技能 | Jun | Mid | Sen | Lead | Princ |
|---|---|---|---|---|---|
| OWASP & Application Security | A | W | A | E | E |
| Secure Coding Practices | A | W | A | E | E |
Testing & QA
2 技能| 技能 | Jun | Mid | Sen | Lead | Princ |
|---|---|---|---|---|---|
| Unit Testing | A | W | A | E | E |
| Integration Testing | A | W | A | E | E |
Version Control & Collaboration
3 技能| 技能 | 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 |
常见问题
Analytics Engineer角色需要哪些技能？
Analytics Engineer角色需要53项技能，其中147项为必备。技能分布在5个级别：从Junior到Principal。 查看完整矩阵.
如何在Analytics Engineer角色中晋升到下一级别？
使用等级计算器评估您当前的级别并获取个性化建议。系统将显示晋升所需发展的技能。
Analytics Engineer角色使用什么技术栈？
技术栈包含5种不同级别的技术。 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...
社区如何定义Analytics Engineer角色的要求？
角色要求由社区通过提案系统制定。任何成员都可以提出修改建议，经过投票和专家评审后生效。