Skip to content

00 / Data Engineer — Chicago, IL

William Gerstung

I build
data pipelines 

Data engineer in Chicago. I turn messy, manual processes into systems people can actually trust.

Things I've built

A live look at what I've been building.

Featured

typer

Typing practice in your terminal. Like monkeytype, but in the CLI.

clicommand-line-toolcurseskeyboard
Python136

stringer

A web app for keeping a tally of your fishing catches — a digital stringer for what you reel in.

Web AppFishing
stringer.fish

fretwork

A guitar teacher that listens. Tune up, learn chords, and practice with live feedback from your own guitar, all in the browser.

Next.jsWeb AudioDSPGuitar
fretwork.willgerstung.com

qrart

QR codes hidden inside original artwork. The picture is the code, so people scan it out of curiosity.

Next.jsQR ArtStudio
qrart.willgerstung.com

woodshed

Couldn't afford guitar pedals or amps, so I built a free studio where I can make any pedal.

C++JUCEAudioOpen Source
C++1

resy-mcp

MCP server for searching restaurants, checking availability, and making reservations through the Resy API. Works with Claude Code and Claude Desktop.

PythonMCPFastMCPResy
Python2

William-Ger

About me, list of my repositories, and contact information

1

The short version

Data engineer by title, builder by habit.

I'm a data engineer based in Chicago. Most of my work lives in the unglamorous middle of a project — the place where data is messy, processes are manual, and nobody's quite sure if the numbers are right. I build the pipelines, ETL, and tooling that make that part dependable, so the people downstream can actually trust what they're looking at.

I'm now at Epiq, building AI tools inside client legal teams' environments. Before that I led data engineering for implementation projects at Gibson Consulting, where the goal was usually the same: replace slow, manual work with automation that holds up in production. I built pipelines that automated large-scale supplier processing, ETL that fed multi-client reporting dashboards, and the internal tools that took the friction out of day-to-day workflows.

I also build the web apps that sit on top of the data — internal tools and client-facing workflows in Next.js and FastAPI — and I tinker constantly outside of work, mostly on developer tools and AI projects you'll find below. I like clean systems, fast feedback loops, and shipping things that quietly do their job.

Location
Chicago, IL
Education
B.S. BAIS, Iowa '23
Focus
Data Engineering + Web
Currently
Epiq

The tools I reach for most

  • Python
  • Spark
  • Databricks
  • Azure
  • Next.js
  • FastAPI
  • TypeScript
  • React
  • Tailwind CSS
  • Git

Where I've been

Roles, results, and the path that got me here.

Résumé (PDF)

2026–Present

Associate Forward Deployed Engineer

Epiq — Chicago, IL

Work directly with client legal and compliance teams to design, build, and deploy AI solutions in their own environments: the integrations, automations, and workflows that connect AI to the systems they use every day, handed over so their teams can run them.

PythonAILLMsMCPIntegrations

2023–2026

Data Engineer

Gibson Consulting — Chicago, IL

Led data engineering for implementation projects, building data pipelines that automated RFQ/RFI processing across 3,000+ global suppliers and reduced manual processing time by ~90%. Designed ETL pipelines for multi-client reporting dashboards and developed custom web applications for client workflows.

PythonSQLAzureSparkNext.jsFastAPI

2020–2022

Data Analyst Intern

Danley's Garages — Elk Grove Village, IL

Identified and resolved critical database integrity issues with SQL queries. Automated sales analytics dashboards through Excel VBA programming, eliminating manual reporting. Created monthly sales performance reports and managed procurement planning for building materials.

SQLExcel VBAData Analysis

2019–2023

B.S. Business Analytics & Information Systems

University of Iowa — Tippie College of Business

Graduated May 2023 from the Tippie College of Business with a focus on Business Analytics and Information Systems.

AnalyticsInformation Systems

Let's build something dependable.

Whether you're hiring, have a data problem that needs untangling, or just want to compare notes on pipelines and developer tools — my inbox is open.

Email me