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.
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:
If only our DA gal can do the work that the arrogant DE does without becoming him… Enter dbt (data build tool)! How can a tool like this create an entirely new position in the field, you ask? Let’s see.
And just like that, our DA gal evolves into an AE.
I’m kidding. It does not work like that. It takes time, effort, and commitment to learning new stuff. If you can relate to the story of our DA girl, I think this article will benefit you.
Here is an opinionated list of skills/technologies I think are necessary to become an AE ninja.
Below are the resources that we use at Joon Solutions to onboard our new Analytics Engineer. It works better as a checklist, so perhaps you can copy these to your favorite note-taking app.
I can’t guarantee that by following this, you will be an AE. But I’m sure that you can learn a lot following this path, and with the right environment and team, you will evolve to an Analytics Engineer ninja.