Intermediate · 5–7 months

Analytics Engineer

Own the modelling layer between raw data and trusted metrics.

Roadmap

Analysts who want engineering rigour.

  1. 01 · Foundation

    SQL depth

    • Window functions
    • CTE patterns
    • Performance
  2. 02 · Core

    Modelling

    • Star schema
    • Slowly changing dimensions
    • Metric layers
  3. 03 · Applied

    dbt workflow

    • Models & tests
    • Docs
    • CI
  4. 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