## about

Hi there, I'm Andrew! Thanks for visiting my personal webpage. I'm a thirty-ish data engineer, working from the northwest USA. I use he/him/his pronouns. I have a degree in Psychology from the College of Idaho (a small liberal arts school), with a minor in History. After graduating in 2013, I moved to Ann Arbor, MI where I helped support several research units associated with the University of Michigan. Gradually my interests in social science broadened to encompass what's now referred to as "data science", as I took on roles involving data management and statistical analysis.


I'm currently working on a second degree in applied mathematics at Boise State. I'm broadly interested in statistical inference, survey design/analysis, data visualization, and data engineering practices that increase organizational capacity.


My previous former work experience includes:

  • working as a data warehouse developer at Boise State University
  • serving in Boise State's Office of Institutional Research
  • assisting with research and program evaluation in UM SSW's Child & Adolescent Data Lab
  • managing and collecting behavioral data in social & cognitive psychology labs

Currently, I'm serving as a senior data engineer in the University of Colorado Boulder's Office of Information Technology (OIT). My team resides with the Data & Analytics group, where we support 100+ automated data pipelines, multiple custom API services, and provide data warehousing support to campus stakeholders.


Please feel free to reach out to discuss any opportunities! Just type 'contact' in the prompt below. You can also check out my resume by typing 'cv' in the prompt, or by visiting /cv.


## now

(This is a now page, if you haven't seen one before.)

Updated 11/30/2024:

  • Living in Boise, ID
  • Working remotely in CU Boulder's OIT, as a senior data engineer
  • I'm learning a lot about CI/CD and Snowflake, primarily through standing up dbt-core at work
  • Still practicing a bit of German every day
  • Finished with my two math courses for the term, enjoying winter break
  • 📖 61% Butter Asako Yuzuki (2017)

## blog

I maintain a blog where I post updates about side-projects and other things I'm working on. You can access it here.


## contact

Here are a few good ways to reach me:


## projects

Here are a few of my personal projects:

  • Riddles & Wyverns: a browser-based trivia game, inspired by Quizzes & Dragons. Very much a WIP; the game is currently unhosted, and isn't ready to be played.
  • Linear regression primer: a set of posts covering the basics of linear regression (OLS and multiple regression).
  • Spotify Listening History: boutique data project, where I'm tracking my Spotify listening history over time.
  • Prefect Sitrep: this is a small web-app I developed as a proof-of-concept. The app is built to surface status information about Prefect deployments, such as the status of a deployment's most recent run. Integrated within each deployent's page is the ability to raise a GitHub issue that's tied to the deployment, allowing customers to request improvements or report problems. Data is gathered from Prefect's REST API.


## website

I built this website from scratch using SvelteKit. Hosting is provided via Vercel. I'm using Bulma as my CSS framework. The inspiration for the CLI-style interface was heavily influenced by Craig Feldman's website. The source code for this website can be found here.