Spencer Payne

I’m a Data Science student at BYU–Idaho (B.S. expected July 2027, minor in Business Analytics). I’m also the Special Projects Manager at Family Psychological Services, where I built the monthly ETL and reporting workflow that cleans about 480,000 CRM records and cut report preparation time by 78%.

I like taking messy, real-world data and turning it into clear answers: cleaning it, testing it statistically, modeling it, and building the pipelines that keep it flowing.

View my resume GitHub LinkedIn Email me

Rexburg, ID · Authorized to work in the U.S. without sponsorship · spayne22802@gmail.com

At a glance

Education	B.S. Data Science, BYU–Idaho (GPA 3.4) · A.S. 2026 · Certificate in Data Science 2026
Experience	Special Projects Manager, Family Psychological Services (2023–present) · IT Lead, Mexico City (2021–2023)
Recent focus	ETL pipelines (Airflow, Snowflake, MongoDB), database design, statistics, machine learning
Spoken languages	English, conversational Spanish

Skills

Area	Tools
Languages	Python, R, SQL, Excel/VBA, PowerShell, JavaScript
Data analysis	pandas, Polars, tidyverse (dplyr, tidyr, ggplot2), Lets-Plot
Statistics	t-tests, ANOVA, nonparametric tests, linear and logistic regression, design of experiments
Machine learning	scikit-learn, XGBoost, TensorFlow/Keras, PyTorch
Data engineering	ETL/ELT, Apache Airflow, Snowflake, MongoDB, Docker, APIs, schema design and normalization
BI and reporting	Tableau, Power BI (DAX), Excel, Quarto, R Markdown

Featured projects

Automated ETL Pipelines with Apache Airflow

Scheduled Airflow pipelines that pull weather, stock, and SFTP data, clean it with pandas, and upsert it into Snowflake, with automatic backfill.

Predicting King County Home Prices

Feature engineering and an XGBoost regressor that explains about 90% of the variance in home sale prices on held-out data.

Newly Reported Medicaid Drugs

Public Data

Data Storytelling

Pulls weekly CMS Medicaid Drug Rebate Program data straight from the web to show what kinds of drug products are being newly reported.

Caffeine, Distractions, and Reaction Time

ANOVA

Experimental Design

Two-way ANOVA on a self-run experiment testing how caffeine dose and audio/visual distractions affect reaction time.

Portlight: Local Network Security Dashboard

A read-only Windows network and security dashboard: a PowerShell collector feeds a hardened Docker container that serves an explainable review queue in the browser.

Finding Relationships in Baseball with SQL

Python

SQL

SQLite

SQL queries against the Lahman baseball database exploring salaries, batting averages, and team comparisons.

Browse by skill

Statistical Analysis
Hypothesis tests, regression, designed experiments Data Cleansing
Multi-format import, reshaping, missing data Data Exploration
SQL, joins, and business questions Story Telling
Visualization for a specific audience Machine Learning
Regression, classification, CNNs Full Stack
ETL pipelines and applications Competition
Timed challenges and contests