Data Analyst
Analyzing data for business decisions, building reports and dashboards
Data Analyst is a role in the Data Engineering family. It has 48 skills across 5 levels (from Junior to Principal). 131 skills are mandatory. Key domains: Programming Fundamentals, Backend Development, Database Management.
Technology Stack
Focus by Level
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.
Skill Matrix
48 skills × 5 levels. Click on a cell for details.
AI-Assisted Development
3 skills| Skills | 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 skills| Skills | 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 skills| Skills | Jun | Mid | Sen | Lead | Princ |
|---|---|---|---|---|---|
| System Design Fundamentals | A | W | A | E | E |
Backend Development
3 skills| Skills | 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 skills| Skills | 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 skills| Skills | 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 skills| Skills | 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 skills| Skills | Jun | Mid | Sen | Lead | Princ |
|---|---|---|---|---|---|
| GitHub Actions / GitLab CI | A | W | A | E | E |
Machine Learning & AI
2 skills| Skills | Jun | Mid | Sen | Lead | Princ |
|---|---|---|---|---|---|
| Classical ML (scikit-learn) | A | W | A | E | E |
| Experiment Tracking | A | W | A | E | E |
Observability & Monitoring
2 skills| Skills | Jun | Mid | Sen | Lead | Princ |
|---|---|---|---|---|---|
| Structured Logging | A | W | A | E | E |
| Prometheus & Grafana | A | W | A | E | E |
Programming Fundamentals
7 skills| Skills | 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 skills| Skills | Jun | Mid | Sen | Lead | Princ |
|---|---|---|---|---|---|
| OWASP & Application Security | A | W | A | E | E |
| Secure Coding Practices | A | W | A | E | E |
Testing & QA
2 skills| Skills | Jun | Mid | Sen | Lead | Princ |
|---|---|---|---|---|---|
| Unit Testing | A | W | A | E | E |
| Integration Testing | A | W | A | E | E |
Version Control & Collaboration
2 skills| Skills | Jun | Mid | Sen | Lead | Princ |
|---|---|---|---|---|---|
| Git Advanced | A | W | A | E | E |
| Code Review | A | W | A | E | E |
FAQ
What skills are needed for the Data Analyst role?
The Data Analyst role requires 48 skills, of which 131 are mandatory. Skills are distributed across 5 levels: from Junior to Principal. See full matrix.
How to advance to the next level in the Data Analyst role?
Use the Grade Calculator to assess your current level and get personalized recommendations. The system will show which skills need to be developed for the next level.
What tech stack is used in the Data Analyst role?
The stack includes 5 technologies at different levels. 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...
How does the community define requirements for the Data Analyst role?
Role requirements are shaped by the community through a proposal system. Any member can suggest changes that go through voting and expert review.