Shipped a lineage tool that gives users visibility into all-in costs for their data workloads: https://select.dev/changelog/2025-01-07-lineage

Built second version of the lineage tool: https://select.dev/changelog/a-redesigned-lineage-view

Built in-app search feature: https://select.dev/changelog/added-global-search-to-quickly-find-any-resource-in-your-snowflake-account

Mozart Data is a modern data platform that you can set up in an hour, managing all your ETL, data warehousing, dbt, and data transformation needs.

• Enabled our app to work with BigQuery. It used to be Snowflake only. Add support for ETL connectors, dbt, custom transformation layer.

• Enabled users from 35+ companies to schedule and run dbt Core jobs on our platform using isolated, secure environments.

• Overhauled our prod and staging deployment process to run in serverless instead of a dedicated VM that we hoped would never get corrupted.

• Created backend for "Out of the Box Reports", where we generate useful transforms and Google Sheets exports/charts for common data sources like Stripe and Shopify.

• Enabled users to bring an existing Snowflake account to our platform if they desired instead of us making one for them.

• Implemented bidirectional sync to GitHub of users' SQL transforms.

Data engineering to unlock value for the staff and students of BloomTech (fka Lambda School). Often on loan to support other verticals with backend engineering work.

Migrated ETL pipelines from Airflow to dbt. Established standards and Continuous Integration checks to ensure that SQL runs properly, passes tests, and passes lint before pull requests can be merged.

Developed a framework to seed dev data for ~200 tables in our monolithic repo. Automatically discover schema changes and emit TypeScript methods that can be used to mock data in integration tests. Generate a file seeding tables in the proper order based on foreign key relationships that can populate the entire dev database with an npm command. Allow for users to provide a config to override default mocking behavior.

Developed pipeline to load curriculum from Github repos into Canvas learning management system, creating courses, loading page content, quizzes, deadlines, etc.

Delivered backend and database layers for student job board and admin student tagging projects.