Extras · Lesson 10 of 22

Career: Analytics Engineer

Analytics Engineers build the data models that analysts use.

Daily tasks:

  • Write dbt models to transform raw data
  • Design dimensional data models
  • Document data definitions
  • Ensure data quality with tests
  • Bridge gap between data engineers & analysts

Skills needed:

  • Advanced SQL (CTEs, window functions)
  • dbt
  • Data modeling
  • Git version control
  • Understanding of business metrics

Salary range: $90K - $150K+

SQL usage: 90% of your day Hot role - huge demand right now!

Check your understanding

What tool do Analytics Engineers primarily use?