Jonathan Northrup

About Jonathan Northrup

Supported and mentored guild of DBT power users in creating certified data models- Wrote macros for bulk importing sources in DBT- Migrated queries from LookML to DBT- Used Fivetran to extract data from PostgreSQL databases, S3 buckets, and Google Sheets into Snowflake- Used Airflow and Redshift to create an ELT pipeline- Expanded the transformation capabilities of ETL framework using PySpark and AWS Glue- Used machine learning in Python to perform analysis on product offerings- Used Kimball principles to model facts and dimensions for a data warehouse- Interviewed stakeholders to identify data and reporting needs- Created hundreds of custom reports using complex SQL queries- Worked closely with stakeholders to make far-reaching changes to vital reporting tables- Designed a framework for quickly deploying custom report dashboards in PHP- Built a dashboard for the sales department using PHP and PostgreSQL- Wrote an R program to predict grocery store sales based on precipitation- Designed a web application and database for data collection and analysis using PHP and MySQL- Determined effect of expansions in UTA network on its revenues and expenditures

Experience

1. Senior Analytics Engineer

   Angel

   Mar 2024 — Present · Provo, UT, US

Education

• Brigham Young University

  Bachelor of Science (BS), Economics, Minor in Management

  2007 — 2010

• Lamar Community College

  Associate of Arts (AA)

  2002 — 2005

Skills

• Editing
• Microsoft Word
• Financial Analysis
• Software Testing
• Teaching
• Leadership
• Data Analysis
• Management
• Customer Service
• Mysql
• Postgresql
• Forecasting
• Strategic Planning
• Public Speaking
• Research
• Microsoft Office
• Econometrics
• Sql
• Php
• Python
• Tableau
• Powerpoint
• Microsoft Excel
• R
• Analysis
• Statistical Data Analysis