Main
Scott Brenstuhl
Experience
Jul 2023Apr 2020
Senior Data Engineer (First Data Hire)
Extend San Francisco, CA- Designed and built the initial data warehouse and pipelines from scratch, coalescing data on thousands of merchants (including their Segment clickstreams), tens of millions of products, warranties, chatbot logs, sales deals (from Salesforce), etc. eventually growing to a ~130TB datalake and ~16TB warehouse.
- Worked with various teams to build warehouse based microservices including: providing data to Iterable’s API for Peloton’s mass-marketing email campaigns, automating merchant support tasks of providing data to partners, custom dbt alerting to notify model stakeholders via Slack.
- Assisted in growing the data eng team to 8 and the data sciance/analytics org to ~30 and collaborated with them to provide data and empower them to develop their own dbt models.
- Implement CI/CD for our data pipelines with linting, test builds in dbt cloud, service-level code owner approval, etc.
Feb 2020Oct 2018
Data Scientist / Data Engineer
Brandless San Francisco, CA- Developed Airflow pipelines to extract data from APIs and various data stores, transform disparate data to be concise, actionable, and structured, and load these into Redshift, data feeds, email services, etc.
- Analyzed and made recommendations on promotions, customer acquisition, customer segmentation, and retention.
- Increased team output by mentoring teammates, implementing testing, developing an internal R package, and implementing major refactors.
Oct 2018May 2017
Data Analyst (First Data Hire)
MasterClass San Francisco, CA- Developed the proof of concept for our class recommendation engine.
- Created analysis to drive the transition to subscriptions, explore free trials, and empower Growth to double year-over-year revenue.
May 2017Nov 2012
Director of Operations
Piazza Technologies Palo Alto, CANov 2012Aug 2011
Rates and Residuals Support Specialist
Reynolds and Reynolds Dayton, OHConsulting
20202017
Data Engineering / Data Science
Clients including: Huckberry, Modsy, MasterClass- Built out and/or extend dbt implementations for dimensional data, marketing attribution, reporting, etc.
- Developed microservices to consume data from 3rd party webhooks, transfer data to/from sftp servers, and produce standardized reports for any of the client’s products.