Data Analyst是Data Engineering族群中的角色。涵盖5个级别的48项技能（从Junior到Principal）。其中131项为必备技能。关键领域：Programming Fundamentals, Backend Development, Database Management。
技术栈
各级别重点
Writing SQL queries for reports. Building dashboards (Tableau/Superset). Data collection and cleansing. Preparing presentations with insights.
Running A/B tests. Cohort analysis. Building product metrics. Report automation (Python/SQL). Working with product team.
Designing metrics systems. Complex statistical analysis. Forecasting. Mentoring. Presenting insights to management.
Data-driven culture in the company. Metrics standards. Coordinating analysts. Self-service analytics strategy.
Analytics strategy. Data democratization. Advanced analytics (ML for business). Influencing business strategy.
技能矩阵
48 技能 × 5 级别. 点击单元格查看详情。
AI-Assisted Development
3 技能| 技能 | Jun | Mid | Sen | Lead | Princ |
|---|---|---|---|---|---|
| GitHub Copilot | A | W | A | E | E |
| ChatGPT / Claude | A | W | A | E | E |
| Prompt Engineering for Code | A | W | A | E | 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
3 技能| 技能 | Jun | Mid | Sen | Lead | Princ |
|---|---|---|---|---|---|
| Python Web Frameworks | 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
10 技能| 技能 | 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 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 |
| BI Dashboards | A | W | A | E | E |
Database Management
6 技能| 技能 | Jun | Mid | Sen | Lead | Princ |
|---|---|---|---|---|---|
| PostgreSQL | A | W | A | E | E |
| MySQL / MariaDB | 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 |
DevOps & CI/CD
1 技能| 技能 | Jun | Mid | Sen | Lead | Princ |
|---|---|---|---|---|---|
| GitHub Actions / GitLab CI | A | W | A | E | E |
Machine Learning & AI
2 技能| 技能 | Jun | Mid | Sen | Lead | Princ |
|---|---|---|---|---|---|
| Classical ML (scikit-learn) | A | W | A | E | E |
| Experiment Tracking | A | W | A | E | E |
Observability & Monitoring
2 技能| 技能 | Jun | Mid | Sen | Lead | Princ |
|---|---|---|---|---|---|
| Structured Logging | A | W | A | E | E |
| Prometheus & Grafana | A | W | A | E | E |
Programming Fundamentals
7 技能| 技能 | 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 |
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
2 技能| 技能 | Jun | Mid | Sen | Lead | Princ |
|---|---|---|---|---|---|
| Git Advanced | A | W | A | E | E |
| Code Review | A | W | A | E | E |
常见问题
Data Analyst角色需要哪些技能？
Data Analyst角色需要48项技能，其中131项为必备。技能分布在5个级别：从Junior到Principal。 查看完整矩阵.
如何在Data Analyst角色中晋升到下一级别？
使用等级计算器评估您当前的级别并获取个性化建议。系统将显示晋升所需发展的技能。
Data Analyst角色使用什么技术栈？
技术栈包含5种不同级别的技术。 SQL, Excel/Google Sheets, Tableau/Superset/Metabase, Python basics (pandas), Git, SQL advanced, Python (pandas, numpy, scipy), Tableau/Superset, A/B testing tools, Airflow basics, ClickHouse/BigQuery, SQL expert, Python (statsmodels, scikit-learn basics), ClickHouse/BigQuery, dbt, Airflow, Statistical modeling...
社区如何定义Data Analyst角色的要求？
角色要求由社区通过提案系统制定。任何成员都可以提出修改建议，经过投票和专家评审后生效。