Approachable Array Aggregations

Solve a real-life SQL array problem in an easy-to-follow walkthrough.

These Hobby Coding Projects Saved Me 50+ Hours This Year

4 unconventional but useful data engineering applications I built that saved me at least 50 hours of work and personal time.

1 Sheet To Get You Hired Or Promoted This Year

How data engineers can wield the power of the “brag sheet” to achieve career-altering results.

Visualizing 48 Months Of Credit Card Spending With PyPDF, SQL & Looker

Constrained by the limitations of my credit card’s pre-filtered dashboards, I used Python, SQL & Looker to create my own.

Testing… Testing… Environments

Categorizing data engineering IDEs to facilitate professional, production-adjacent development.

Can’t-Ignore Data Engineering Advancement Habits

Habits for data engineering job seekers, entry-level engineers and veterans looking to level-up.

Coding An End-To-End Credit Card Spend Pipeline In 1 Weekend

Visualizing 48 Months Of Credit Card Spending With PyPDF, SQL & Looker (Part II).

Data Engineering’s 3rd “I”

Explaining state: How to maintain it, why pipeline runs need to be identical and breaking down an abstract term.

Auto-Tag Sensitive BigQuery Data & Never Touch The UI Again

Eliminate a tedious data governance chore after understanding privacy taxonomies and a simple BigQuery API implementation.

Why Your BigQuery SQL Query Will Or Won’t Run

Delve into the subtle technical and situational factors that determine whether your SQL query runs, stalls or fails.

Engineering Custom Email Alerts For Reddit In 3 Steps

Creating real-time email alerts in Python with the Reddit and Gmail APIs.

Why No One Can Find Your GitHub

Optimize your GitHub portfolio to increase discoverability and discover the new tool to push your repo to the masses.