[ETR #50] 4 Years of DE Content In 1 Post


Extract. Transform. Read.

A newsletter from Pipeline

Hi past, present or future data professional!

For the first time since the birth of the Internet, the prevalence of AI summaries has damaged Google’s Search business, possibly irreparably. And while this might simply be a sign the times they are a changin’ (I just watched that new Bob Dylan movie), it points to a harsher reality.

These days search universally sucks; I’ve found this is especially true when readers, like yourself, want to dig deeper into my publication’s body of work.

My goal when beginning Pipeline was to create a sort of public notebook, recording the practical lessons I learned on the job. But like old notebooks, pages get torn, tossed aside and buried.

To help resurrect old data engineering content I believe is useful but overlooked, I went old school, making an index containing hundreds of searchable, scrollable hyperlinks in 1 post called, appropriately, “Every Pipeline Story Ever.” This effectively serves as the publication’s archive, allowing ready access to 250+ stories from November 2021 to present.

That means you can explore older content like my primer on GCP’s logging query language or working with streaming data in Python. If you’ve read my project guide you’ll know I’m a fan of unique projects like when I helped a Wall Street banker scrape data from 3,000 companies. And if you want to know what the day in the life of a working data engineer is, you can read about my typical work day, with a European twist.

As a bonus, I wrote a piece detailing the simple process I used to programmatically create this webpage. My only tools were Pandas, a few HTML tags and markdown syntax. And, to be honest, a bit of guidance from my pair programmer AI.

My hope is to fight the ever-picky algorithms by allowing you, the reader, to choose how and when you consume.

Take notes, Google.

Thanks for ingesting and enjoy your trek through the archives,

-Zach Quinn

Extract. Transform. Read.

Reaching 20k+ readers on Medium and nearly 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.

Extract. Transform. Read. A newsletter from Pipeline Hi past, present or future data professional! One of the most loaded terms, after AI, is upskilling. It’s something everyone should always be doing, yet, only the most dedicated can consistently dedicate time to learning and expanding beyond their comfort zones. If you’re on the path to becoming a data professional, you’ve probably spent countless hours learning, only to find yourself wondering if you’re actually making progress. I’ve been...

Extract. Transform. Read. A newsletter from Pipeline Hi past, present or future data professional! When I worked as a resume consultant, the toughest mental block for clients was identifying and expressing material contributions at work; avoiding this communication is why so many job hunters revert to regurgitating their job duties rather than clarifying the outcomes of their work. In addition to overcoming the hurdle of distilling a complex technical role for non-technical recruiters to...

Extract. Transform. Read. A newsletter from Pipeline Hi past, present or future data professional! Data science just cracked the top 40… of jobs whose main functions are most likely to be replaced by AI. If you’re up to speed on your AI doomerism news you’ll know that at the end of July, Microsoft released a list of jobs across disciplines and industries that could be majorly disrupted by AI. On a more positive economic outlook, data engineering is specifically cited as a growing role in the...