David Schott Email & Phone Number

- Data Warehouse- ETL- Tableau- DBT

- Technical lead of Data Primitives organization including Foursquare Places which aggregates data from users, crawls, and third-party providers to create a comprehensive and accurate POI (Point of Interest) dataset.- Developed and presented a high-level architecture diagram to guide the project’s technical direction.- Accountable for ensuring operational readiness and smooth deployment of the Places project.- Collaborated across teams to deliver a multi-year product, enhancing engineering discipline and building communications across the organization.- Authored a public blog article highlighting the engineering efforts and data advantages of the Places product

- Built and maintained the most critical ETL data pipeline that powers over a thousand downstream analytics, machine learning, and financial data jobs. Written in Spark running on Google Cloud's Dataproc, it processes billions of clickstream events each night, filters them for bot-like behaviors, and sessionizes them. As experts in data pipelining, my team partnered with engineers and data scientists to help them write performant data jobs.- Organized biannual engineering mentorship program impacting 20% of Etsy engineers fostering career growth and interpersonal skills development.- Trained facilitators and conducted company-wide postmortems, integral to Etsy's culture of continuous learning.- Designed and developed a CDC system for data warehouse migration, facilitating the ingestion of over 600 tables of critical production MySQL data.- Implemented cost-optimizations on 75 pipelines over numerous teams resulting in $7 million annual savings.- Migrated our data warehouse from an on-premise Vertica instance to cloud-based BigQuery. Moved more than a petabyte of data; migrating many systems that rely on the data warehouse; and migrating and validating thousands of batch jobs and reports.- Tech lead for the management of a 40-node on-premise Vertica cluster, enhancing its scalability and stability.

- Led the transformation of Etsy's A/B experimentation tool, enhancing metrics accuracy and enabling data segmentation. - Authored Double-bucketing in A/B Testing Code-as-Craft article.- Co-created Etsy's shipping label system integrating multiple vendors and implemented a tracking mechanism utilized by 97 million buyers and 8 million sellers.

Engineered the PayPal integration and revamped the checkout process, transitioning it into a scalable framework for improved efficiency.

- Spearheaded the integration of AOL authentication, instant messaging and mail services into Bebo's systems.- Built initial AIM Chat product.- Contributed to the development of Aol Pictures