Main
Scott Brenstuhl
Experience
Senior Data Engineer (First Data Hire)
Extend
San Francisco, CA
Jul 2023 - Apr 2020
- 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.
Data Scientist / Data Engineer
Brandless
San Francisco, CA
Feb 2020 - Oct 2018
- 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.
Data Analyst (First Data Hire)
MasterClass
San Francisco, CA
Oct 2018 - May 2017
- 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.
Director of Operations
Piazza Technologies
Palo Alto, CA
May 2017 - Nov 2012
Rates and Residuals Support Specialist
Reynolds and Reynolds
Dayton, OH
Nov 2012 - Aug 2011
Consulting
Data Engineering / Data Science
Clients including: Huckberry, Modsy, MasterClass
N/A
2020 - 2017
- 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.