Intermediate · 5–7 months
Analytics Engineer
Own the modelling layer between raw data and trusted metrics.
Roadmap
Analysts who want engineering rigour.
- 01 · Foundation
SQL depth
- Window functions
- CTE patterns
- Performance
- 02 · Core
Modelling
- Star schema
- Slowly changing dimensions
- Metric layers
- 03 · Applied
dbt workflow
- Models & tests
- Docs
- CI
- 04 · Career
Portfolio
- Capstone warehouse
- Data contracts
Courses in this path
What you graduate with
Skills
- SQL
- dbt
- Data modelling
- Testing
- Git
- Warehouse design
Projects
- dbt metrics layer
- Dimensional model refactor
- Data quality test suite
Certifications
- DCS Certified Analytics Engineer
- dbt Analytics Engineering
Interview preparation
- Modelling scenarios
- SQL depth
- Metric definitions
Career outcomes
- Trusted semantic layer skills
- Versioned analytics workflow
Hiring companies
- Atlassian
- Shopify
- Groww
- Zepto
Salary insights
India / remote-global
Entry
₹7–12 LPA
Mid
₹14–24 LPA
Senior
₹26–42 LPA