[ETR #75] Your 3-Hour Thanksgiving DE Study Plan


Hi past, present or future data professional!

If you’re in the U.S., Happy Thanksgiving! I’m prepping for my food coma, so I’ll make this week’s newsletter quick.

Like millions of Americans, I’ll be watching NFL football (go Ravens!).

The average NFL game is 3 hours. If you can skip just one of today’s games and carve out that time for professional development, here’s how I’d spend it.

In the spirit of football, I’ll split the time designation into 4 quarters.

  1. Documentation pass - if you read and program regularly, I have no doubt you are amassing some great code in your GitHub. But given the time drain on programming, I’d be willing to bet your repository is either undocumented or under-documented. Take 30-45 minutes to write a Markdown file that includes a quick blurb about your project, rationale for your tech stack and, at the very least, a directory tree.
  2. Refactor - just like every writer begins with a rough draft, very few programmers generate perfect code on the first attempt. As AI coding abilities develop at a rapid pace, your competitive advantage is creating code that is legible, logical and follows best practices.
  3. Diagram - if you want to be a data engineer, system design is an essential skill to develop. Practice it by creating a diagram for a school or professional project that clearly illustrates inputs, downstream dependencies and other relationships.
  4. Read a case study - Too many new engineers worry about coding and not solving business problems. For thorough, applicable case studies of real-life companies, I recommend Vu Trinh’s Medium posts. Or if you want something denser, seek out Google’s Dremel paper, the blueprint for BigQuery.

Have a pleasant holiday and thanks for ingesting,

-Zach Quinn

P.S. look out for a quick Black Friday note from me tomorrow.

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! Next time you think you’ve tried everything in your job search, remember: I once worked with a guy who got hired at a national broadcast network on the strength of his parody rap. The intern, Jake, didn’t have a network or elite contacts, but he wanted an internship at The Tonight Show, a competitive role with over 10,000 applicants per semester. So, he recreated a shot-for-shot parody of a song previously performed on the show, rewritten with lyrics specifically...

Hi fellow data professional! For the past month I’ve been working on my most ambitious personal project: Purchasing and renovating a house. The first major upgrade? Replacing 70+-year-old windows. And while there’s probably a tech work comparison to gutting a legacy system to build anew, what I want to focus on is the deal I brokered and how you can use similar leverage in your interviews. Because I got $1200 off a house’s worth of windows as a result of market research, due diligence and a...

Hi fellow data professional! Big news from my home base of Orlando: Disney hired a new CEO with a pay package of nearly $40 million. If you read beyond the headline you’ll see that his base salary is “only” 2.5 million with the possibility of up to a 250% target incentive and some $26-ish million in stock options. This is why you, the job seeker, need to think beyond base salary and look at TC. Total compensation. Thanks to labor transparency laws passed in hiring hubs like New York and...