Erika Jacobs

Erika Jacobs

About Me

Hi there! My name is Erika Jacobs, and I’m a data engineer and educator. My professional passions are working with data and teaching others.

Thank you for stopping by!

Interests

  • Data Engineering
  • ETL
  • Cloud Computing
  • STEM Education

Education

  • Masters in Applied Statistics, 2018

    Penn State University

  • Bachelors in Psychology, Theatre, 2013

    Arizona State University

Projects

*

NASA Data Warehouse

Pulls data from NASA DONKI API, and stages data in S3 to load to Redshift using boto3

Beatles Bops

Builds an ETL pipeline of album information by The Beatles using the Spotify API, and loads to PostgreSQL

Excel Python Migration

Migrates hundreds of Excel files with the same format to SQL using Python.

TV Series NoSQL Database

Pulls TV season episode information for longest running TV series and stores in NoSQL database.

ISS Stream

Streams coordinates of the International Space Station (ISS) using Kafka

COVID-19 Data Project

Places Johns Hopkins University COVID-19 data into S3 bucket, and is processed using PySpark in Databricks to create a dashboard.

Consumer Complaints

Reads federal government consumer complaints csv and aggregates summary statistics.

Animal Crossing Popularity Data

Scrapes data on Animal Crossing villager popularity, joins to Kaggle table of villager traits, and appends to MySQL table using a CRON job.

Harry Potter NLP Project

Sentiment analysis conducted on the Harry Potter book series using a naive bayes classifier and natural language processing.

Common Core Intervention Analysis

A time series intervention analysis of average mathematical SAT score before and after the implementation of Common Core curriculum.

Anonymize

A simple find and replace script developed to anonymize confidential code in multiple text-based files without having to physically open them.

Personal Website Project

Created a personal website with the help of R Studio, Blogdown, Hugo, and the Academic theme.