Projects

dbt sample project

I created this sample project on GitHub using a public dataset in BigQuery (Google Analytics session data) and dbt. This is meant to illustrate basic knowledge in dbt, but in my day-to-day I have created a much more robust dbt project utilizing features like snapshots, third party packages, more macros, and more complex lineage.

Skills showcased:

🖥️ SQL

🤝 dbt familiarity

🔢 Tool setup w/ BigQuery (service account management)

🧠 Macros & code reusability w/ Jinja and dbt packages
💪🏻 Custom configurations

🧹 Data modeling & transformation

Visit the sample project on GitHub.

SQL & Python sample snippets

A few sample projects to showcase advanced SQL skills

Skills showcased:

🖥️ advanced SQL & Python

🛠️ Data notebooks

🤓 Git/GitHub

📈 Basic data viz

Code:

Intermediate SQL snippets (grouping, calculating min/max, counts, math) Project
Advanced SQL snippets (windows functions, de-duping, cleaning, calculating distance) and some dbt examples Project
Retrieving data from API w/ Python. Project
Analysis of 211 data in Pittsburgh with Python Project
Fivetran usage explorer (this actually is not functional but an example of an automated report I built at a previous job) Notebook
Exploring UFO sightings data set Notebook
Scraping web data with Python Notebook

Various writings

I'm really trying to level up my technical and professional writing skills. It's hard to make time! When I have downtime or an idea that sounds moderately interesting i'll post it in this section.

reusable SQL/Python reports that i've built to make my life easier
tiny tidbits that I have found helpful as I am learning (ex: generating a UUID in SQL)
documentation templates that I use while working to make stakeholder communication easier
and more!

You can check it out here.