Become an Analytics Engineer in 90 Days

The tale of a Data Analyst who evolves into an Analytics Engineer and resources so you can use to be like her.

Image credit

Analytics Engineer is a new position coined (and made possible) by dbt. If a Data Engineer (DE) marries a Data Analyst (DA) and they have a baby girl, that baby girl will be an Analytics Engineer (AE). Well, it does not work that way, but you get the point.

Image Credit

The context

An AE often starts off as a DA creating dashboards and doing ad-hoc queries. She wants to do more because that DE guy works like a snail. She knows her data well because she spent hours per day navigating it using her mad SQL skill. She also knows the business inside out, having to interact with them on a daily basis. But she is faced with enormous challenges wanting to take on the work of the DE guy. Here are some of them:

• The pipelines were built in Python, and she doesn’t know how to code (besides SQL).
• The DE guy mentioned something about using git to keep track of changes in the source code. She has her SQL codes stored in word files…