Analytics Engineer
Transforming raw data into analytics-ready models using dbt and SQL
Level:
Programming Fundamentals
8 skills · 40 requirements| Skill | Junior | Middle | Senior | Lead | Principal |
|---|---|---|---|---|---|
| Algorithms & Data Structures | |||||
| Algorithms & Complexity | Awareness | Working | Working | Advanced | Expert |
| Data Structures | Awareness | Working | Working | Advanced | Advanced |
| OOP & Design Patterns | |||||
| OOP & SOLID Principles | Awareness | Working | Working | Advanced | Advanced |
| Design Patterns | Awareness | Working | Working | Advanced | Advanced |
| Concurrency & Parallelism | |||||
| Multithreading | Awareness | Working | Working | Advanced | Advanced |
| Async Programming | Awareness | Working | Working | Advanced | Advanced |
| Clean Code & Refactoring | |||||
| Code Quality & Refactoring | Awareness | Working | Working | Advanced | Advanced |
| Type Systems | |||||
| Type Safety & Type Systems | Awareness | Working | Working | Advanced | Advanced |
Backend Development
4 skills · 20 requirements| Skill | Junior | Middle | Senior | Lead | Principal |
|---|---|---|---|---|---|
| Web Frameworks | |||||
| Python Web Frameworks | Awareness | Working | Advanced | Advanced | Expert |
| Message Queues & Event Streaming | |||||
| Apache Kafka | Awareness | Working | Advanced | Advanced | Expert |
| Caching | |||||
| Redis | Awareness | Working | Working | Advanced | Expert |
| Search Engines | |||||
| Elasticsearch / OpenSearch | Awareness | Working | Advanced | Advanced | Expert |
Database Management
6 skills · 30 requirements| Skill | Junior | Middle | Senior | Lead | Principal |
|---|---|---|---|---|---|
| Relational Databases | |||||
| PostgreSQL | Awareness | Working | Advanced | Advanced | Expert |
| NoSQL Databases | |||||
| ClickHouse | Awareness | Working | Advanced | Advanced | Expert |
| Database Optimization | |||||
| Database Indexing | Awareness | Working | Advanced | Advanced | Expert |
| Query Optimization | Awareness | Working | Advanced | Advanced | Expert |
| Data Modeling | |||||
| Data Modeling & Schema Design | Awareness | Working | Advanced | Advanced | Expert |
| Database Migrations | Awareness | Working | Advanced | Advanced | Expert |
API & Integration
3 skills · 15 requirements| Skill | Junior | Middle | Senior | Lead | Principal |
|---|---|---|---|---|---|
| REST API | |||||
| REST API Design | Awareness | Working | Working | Advanced | Advanced |
| GraphQL | |||||
| GraphQL Design | Awareness | Working | Working | Advanced | Advanced |
| API Management | |||||
| API Documentation | Awareness | Working | Advanced | Advanced | Expert |
Cloud & Infrastructure
4 skills · 20 requirements| Skill | Junior | Middle | Senior | Lead | Principal |
|---|---|---|---|---|---|
| Containerization | |||||
| Docker | Awareness | Working | Working | Advanced | Advanced |
| Kubernetes & Orchestration | |||||
| Kubernetes Core | Awareness | Working | Working | Advanced | Advanced |
| Cloud Providers | |||||
| AWS | Awareness | Working | Working | Advanced | Advanced |
| Networking | |||||
| Network Fundamentals | Awareness | Working | Working | Advanced | Advanced |
DevOps & CI/CD
1 skills · 5 requirements| Skill | Junior | Middle | Senior | Lead | Principal |
|---|---|---|---|---|---|
| CI/CD | |||||
| GitHub Actions / GitLab CI | Awareness | Working | Working | Advanced | Advanced |
Testing & QA
2 skills · 10 requirements| Skill | Junior | Middle | Senior | Lead | Principal |
|---|---|---|---|---|---|
| Unit Testing | |||||
| Unit Testing | Awareness | Working | Working | Advanced | Advanced |
| Integration Testing | |||||
| Integration Testing | Awareness | Working | Working | Advanced | Advanced |
Security
2 skills · 10 requirements| Skill | Junior | Middle | Senior | Lead | Principal |
|---|---|---|---|---|---|
| Application Security | |||||
| OWASP & Application Security | Awareness | Working | Working | Advanced | Advanced |
| Secure Coding Practices | Awareness | Working | Working | Advanced | Advanced |
Data Engineering
12 skills · 60 requirements| Skill | Junior | Middle | Senior | Lead | Principal |
|---|---|---|---|---|---|
| Batch Processing | |||||
| dbt | Awareness | Working | Advanced | Advanced | Expert |
| Pandas / Polars | Awareness | Working | Advanced | Advanced | Expert |
| SQL-based ETL | Awareness | Working | Advanced | Advanced | Expert |
| Data Lakehouse | |||||
| Data Lake Architecture | Awareness | Working | Advanced | Advanced | Expert |
| Data Warehousing | |||||
| Data Warehouse Design | Awareness | Working | Advanced | Advanced | Expert |
| Data Governance | |||||
| Data Catalog | Awareness | Working | Advanced | Advanced | Expert |
| Data Lineage | Awareness | Working | Advanced | Advanced | Expert |
| Data Contracts | Awareness | Working | Advanced | Advanced | Expert |
| Data Quality | |||||
| Data Quality | Awareness | Working | Advanced | Advanced | Expert |
| Data Orchestration | |||||
| Apache Airflow | Awareness | Working | Advanced | Advanced | Expert |
| Dagster / Prefect | Awareness | Working | Advanced | Advanced | Expert |
| Data Visualization | |||||
| BI Dashboards | Awareness | Working | Advanced | Advanced | Expert |
AI-Assisted Development
4 skills · 19 requirements| Skill | Junior | Middle | Senior | Lead | Principal |
|---|---|---|---|---|---|
| AI Coding Assistants | |||||
| GitHub Copilot | Awareness | Working | Working | Advanced | Advanced |
| Cursor IDE | Awareness | Working | Working | Advanced | Advanced |
| ChatGPT / Claude | Awareness | Working | Working | Advanced | Advanced |
| Prompt Engineering | |||||
| Prompt Engineering for Code | Awareness | Working | Working | Advanced | — |
Architecture & System Design
1 skills · 5 requirements| Skill | Junior | Middle | Senior | Lead | Principal |
|---|---|---|---|---|---|
| System Design | |||||
| System Design Fundamentals | Awareness | Working | Working | Advanced | Advanced |
Observability & Monitoring
3 skills · 15 requirements| Skill | Junior | Middle | Senior | Lead | Principal |
|---|---|---|---|---|---|
| Logging | |||||
| Structured Logging | Awareness | Working | Working | Advanced | Advanced |
| Metrics & Monitoring | |||||
| Prometheus & Grafana | Awareness | Working | Working | Advanced | Advanced |
| Distributed Tracing | |||||
| OpenTelemetry | Awareness | Working | Working | Advanced | Advanced |
Version Control & Collaboration
3 skills · 15 requirements| Skill | Junior | Middle | Senior | Lead | Principal |
|---|---|---|---|---|---|
| Git & Workflows | |||||
| Git Advanced | Awareness | Working | Working | Advanced | Advanced |
| Code Review | |||||
| Code Review | Awareness | Working | Working | Advanced | Advanced |
| Collaboration Tools | |||||
| Documentation as Code | Awareness | Working | Advanced | Advanced | Expert |