Welcome.

Hello, I am

Jon McEwen

And I am a

I work as a data engineer, and I am passionate about data analytics, statistics, and business development.

In my current role, I play a crucial part in supporting an enterprise data warehouse, focusing on data vault and Kimball models. I always strive to set the tone with clear communication and quality work.

Be sure to check out my writing on Medium, where you’ll find several helpful articles about SQL and Python.

If you’d like to connect about an opportunity, need analytics work, or technical content, drop me a line using the form below.

✅ Just make sure the message is between 200 and 250 characters. No robots allowed. ✅

Recent Projects

Web Projects

Ollie Connect

Ollie is a social platform for finding connections. Originally, I built Ollie with a MongoDB + Express backend. But I eventually migrated to Supabase.

Visual Database of College Football Seasons

A quick way to explore individual team records and view basic statistics like win rates and conference rankings.

Analytics Writing

Impact of Recruiting Talent In College Football’s 2022 Season

An exploratory data analysis of how well recruiting rankings predict season victories.

Exploring Instagram Growth Metrics with Python

I set up a Selenium script to track Instagram growth metrics for several content creators. Here's what I learned about building an audience on Instagram from exploring the data.

Explaining Home Team Advantage in College Football

Using team data to establish a tenable explanation for why home teams have more success than away teams.

Tutorials

Understanding Lateral Joins

A practical introduction to SQL's most mysterious join, one of my top-ranked Medium articles.

Your first Python Automation Project

A comprehensive walkthrough of how to organize files with an automated python script. This is a great place to start for those learning the power of Python.

Introduction to SQL Built-In Functions

A beginner's guide to SQL's built-in functions and how to use them.