Aside

Contact

Education

2007 - 201 1
B.S. in Finance
Miami University,
Farmer School of Business
Oxford, OH

Technology Skills

Disclaimer

Made w/ R & pagedown

The source code is available at github.com/808sandbr/resume

Last updated on 2023-07-24.

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.