0:0018:19

How I became an Analytics Engineer

Victoria Perez Mola 18:19 2021

Spotify needed a data role that did not exist yet, so it invented one

Spotify once posted a job for a person nobody had named yet: someone who understood the business and also wrote code like a software engineer. Victoria Perez Mola, a systems engineer who spent years between payroll queries, ERP migrations and data warehouses, now does that job in Berlin. For anyone stuck between analyst and engineer, the open question is which skills actually carry over.

Learn what analytics engineers do, which tools they use and how to start practicing SQL today

Watch on YouTube

In short

Victoria Perez Mola explains the analytics engineer role, which sits between the data engineer and the data analyst, bringing software engineering practices to analytics and business thinking to data engineering. She traces her own path from systems engineering studies and ERP consulting in Argentina to SQL development and analytics engineering in Berlin, and lists the skills and tools a newcomer should learn first.

“But basically what the analytics engineer is going to do is going to introduce the good software engineering practices to the efforts of the data analyst and the data scientists as well.”
“I didn't want it to be 100% technical. I wanted to be something in between.”

What you will learn

  • Distinguish the analytics engineer from the data engineer and the data analyst by responsibilities and focus.
  • Map the tools an analytics engineer uses at each step: storage, loading, modeling and presentation.
  • Recognise how mixed technical and business experience, such as ERP and reporting work, transfers into analytics engineering.
  • Plan a learning path covering database concepts, data modeling approaches, SQL, pipelines, reporting and coding best practices.
  • Practice SQL with a local Postgres or MySQL database, open datasets and HackerRank exercises.

Key takeaways from the speaker

  • data
  • career

Details

Level
Beginner
Format
Talk
Technical depth
Introductory technical
For
Student, Early career, Career changer
Length
18:19
Published
June 2021

Questions this talk answers

What is an analytics engineer?

A role between the data engineer and the data analyst that brings software engineering practices to analytics work and a business mindset to data engineering. It provides clean, transformed data so analysts can focus on analysis.

Where did the analytics engineer role come from?

As the speaker cited, Spotify realised it was missing someone who knew the business and software engineering practices, posted an opening for an expert in building analytical data layers, and hired its first analytics engineer.

Which tools does an analytics engineer need to know?

Cloud data warehouses such as Snowflake, BigQuery or Redshift, loading tools such as Fivetran or Stitch, modeling tools such as dbt or Dataform, and BI tools such as Looker, Mode or Tableau.

What is the best way to prepare and practice SQL?

Download a database such as Postgres or MySQL, get a dataset from an open website and start querying, and use sites like HackerRank whose exercises resemble real-life cases.

Do analytics engineers need Python or R?

Victoria does all her data modeling in SQL and uses neither, though she notes other analytics engineers, for example at Airbnb, use Python and Jupyter, so she recommends Python as well.

About this talk

Have you ever heard about Analytics Engineer? Data roles keep appearing on daily basis and makes it hard to keep track of them. At the end of this talk you should be able to identify what are the tasks and responsibilities of the Analytics Engineer... and maybe even want to become one.

Topics

Related talks

Browse the library