[ETR #100] 100 Weeks Of Advice In 200 Words


Hi fellow data professional!

This is the 100th week I’m reaching out into the void of the Internet to connect with you in order to democratize data engineering career knowledge.

In the golden age of cable TV, shows would celebrate the 100th episode milestone by airing extended content like a 1-hour special for a sitcom that would typically consume 30 minutes.

But I know your time is valuable so I’m going to do the opposite and make this a shorter newsletter than normal.

Since I live what I preach, I store and analyze performance data in a personal BigQuery project.

I queried that data source to determine the 5 newsletters that have had the most impact, which include:

My goal is to continue to produce personally-informed actionable content that breaks down the barriers to entry.

To avoid having to cater to an algorithm I write here, directly to you.

But soon the PipelineToDE body of work will have a new, platform-less home.

If you’re getting tired of scrolling Medium, mark 6/16 on your calendars.

Back next week with more actionable insights.

Thanks for ingesting for 100 weeks,

-Zach Quinn

Medium | LinkedIn | Ebooks

Extract. Transform. Read.

Reaching 20k+ readers on Medium and over 3k learners by email, I draw on my 4 years of experience as a Senior Data Engineer to demystify data science, cloud and programming concepts while sharing job hunt strategies so you can land and excel in data-driven roles. Subscribe for 500 words of actionable advice every Thursday.

Read more from Extract. Transform. Read.

Hi fellow data professional! SQL Lite, the database you most likely learned SQL on, is built atop 100k lines of source code. Sound like a lot? Compare that to Chromium, the engine for Google Chrome, which boasts 30+ million lines of code under the hood. Shortly after acquiring Twitter/X, the world's first trillionaire, Elon Musk, famously asked engineers to tell him how many lines of code they wrote per day, igniting a debate among engineers throughout the software and data domains. When I...

Hi fellow data professional! If you read my note on Tuesday you’ll know I’m coming off of the data engineering week from hell that seeped into my personal life, and delayed the launch of something cool I was planning to share with you; if you want to know more about that, scroll to the end of this message. Last week a flagship data source had a major problem and since it’s within my ownership area, I was the one with the knowledge and responsibility to fix it. I wanted to share the experience...

Hi fellow data professional! Hardly a work day goes by without receiving a request from a data analyst. They range from the mundane “Can you add this column?” to the occasional emergency “The data didn’t load all weekend and the leadership call starts in 15 minutes!” At the end of a jam-packed week I received an unusual request: Help with a Python script. My teammate wanted to know: Best practices How to commit to GitHub What the best way to deploy is They admitted the task was simple,...