Jacob Lawyer

Data & Automation Developer

I build Python tools, data pipelines, and internal automation

that help businesses move faster and see more clearly.

Based in Austin, TX.

See My Work

Experience

Texas Monthly

Product Development Intern. Built Python scripts that reduced site storage by 15%, led a CSS framework migration to Tailwind, and contributed to company-wide analytics dashboards surfacing growth metrics for editorial leadership.

Auxius

Software Developer. Designed and shipped a fintech analysis platform integrating Ramp, ERPNext, Frappe, and Plaid APIs. Deployed on a custom Ubuntu server and managed the full database architecture end-to-end.

Applied Optoelectronics

Intern / Software Developer. Built a Capital Expenditure Manager in Flask + Python to digitize purchase order workflows for the finance department. Integrated Looker for reporting and used SQL to expand the tool across business units.

Projects

SEO Data Pipeline

SEO Data Pipeline

Custom Python scripts to parse, restructure, and optimize content data at scale. Reduced storage footprint by 15% across thousands of pages at Texas Monthly.

Fintech Analysis Platform

Fintech Analysis Platform

Full-stack financial reporting tool combining Ramp, ERPNext, Frappe, and Plaid APIs. Self-hosted on Ubuntu with custom database architecture.

CapEx Manager

CapEx Manager

Internal Flask + Python web app to digitize purchase order workflows for the Accounting department. Integrated with Looker for executive reporting.

Analytics Dashboard

Analytics Dashboard

Company-wide growth metrics dashboard built with GA4, SQL, and Looker to surface audience and content performance data for non-technical stakeholders.

Raspberry Pi Network Tools

Raspberry Pi Network Tools

Configured a Raspberry Pi as a whole-home ad blocker and DNS server using Pi-hole. Introduced me to Linux networking and self-hosted infrastructure.

Tailwind CSS Migration

SCSS → Tailwind Migration

Led backend CSS framework migration from SCSS to Tailwind for a high-traffic media site, improving build times and mobile responsiveness.

The Lab

Small builds · experiments · iCodeThis challenges

Python CSV Cleaner

CLI tool that normalizes messy CSV exports — strips whitespace, fixes headers, detects encoding issues, and outputs a clean file ready for SQL import.

Python CSV CLI
View on GitHub

SQL Query Builder

Simple Python class that generates common SQL query patterns (filter, aggregate, join) from plain dictionaries — useful for quick data exploration without an ORM.

Python SQL
View on GitHub

iCodeThis: Pricing Card

Daily challenge — responsive pricing card UI built with HTML and Tailwind CSS. Focus on clean layout and hover states.

HTML Tailwind iCodeThis
View on GitHub

Profile

Name Jacob Lawyer

Location Austin, Texas

Resume Download PDF

Email jacobglawyer@gmail.com

LinkedIn jacob-lawyer-developer

Languages English · Mandarin (business) · Japanese (intermediate)

Skills

Python 85%

SQL / Looker 80%

JavaScript / HTML / CSS 75%

Flask / Backend 70%

Data Visualization / GA4 70%

Linux / Server Admin 65%

Email

Connect

Copyright © Jacob Lawyer