• Lead 0 to 1 development of all the core Cotera systems. Architected authentication, authorization, job processing, error handling and other SaaS components that processed +1 billion customer actions using Postgres, Typescript, and React for customers such as Bilt, Coterie and Peloton.
• Shaped the company’s business strategy by providing technical insights during leadership meetings, advising on product-market fit, scalability, and feature prioritization.
• Created an abstraction over data warehouse specific SQL so that common business queries like user retention could be written once and applied to other customer's data stacks and sources.
• Built an original design for a caching layer that could often transparently turn 10 minute plus data warehouse queries into <1ms results via applying relational algebra transforms to prior cached query results. https://numbersandnarratives.beehiiv.com/p/how-era-brings-last-mile-analytics-to-any-data-warehouse-via-duckdb
• Built a change data capture system that scaled to billions of events per tenant to allow for data warehouse changes to trigger side effects in the real world.
• Added an asynchronous read/write system to add in LLM / HTTP requests to run as part of declarative queries while handling large scales and respecting rate limits.