Hi, I'm
Steve Pisani
I'm a data architect in the always sunny city of Philadelphia. By day I design the systems that turn raw data into something a business can actually use. This site is where I keep everything else: writing, experiments, books, and whatever I'm tinkering with this week.
Day job
Founder & lead data architect, Tabby Stack
Tabby Stack is my data consulting firm. I lead engineering teams and architect data platforms, from ingestion pipelines to ML models running in production.
- Snowflake
- dbt
- Airflow
- Python
- ML in the warehouse
- Healthcare analytics
Recent writing
All posts →- Building Modern Data Pipelines: Lessons from the Trenches Key insights and best practices for building scalable, maintainable data pipelines in modern organizations.
- The Art of SQL Optimization: Beyond the Basics Advanced SQL optimization techniques that go beyond basic indexing and query structure.
- SQL Guide When writing SQL, it is important to stay consistant to help anyone reading your queries (including future you) quickly understand the lo...
From the lab
Everything →SQL Formatter
Paste ugly SQL, get it back in my style: lowercase, leading commas, explicit aliases. It's real SQLFluff running in your browser via WebAssembly.
- sqlfluff
- pyodide
- webassembly
Recipe Tracker
A shared tracker for working through NYT Cooking's most popular recipes of 2025. Ratings, notes, and photos, synced with Supabase.
- supabase
- vanilla js
- food
Terminal Mode
Hit the theme button in the top-right until the site turns green-on-black. For when you miss 1983.
- css variables
- theming
Things I like
Things I like, in no particular order: technology, my cat, all things energy, rockets, well-formatted SQL, and arguing about where to get the best cheesesteak.