Jonathan Loh Email & Phone Number

San Francisco, California, US

San Francisco, California, US

• Lead team of Analytics Engineers / Data Scientists to contribute to Airtable's Datawarehouse through ELT (dbt) and build accurate models, insights, and metrics (Looker, Mode) for stakeholders to utilize self serve.
• Created ACV pipeline and backend tables which support all company performance reporting,including reporting to Airtable's external investors and Board of Directors
• Created schema to reverse ETL much of Airtable's product information from the DataWarehouse back into Salesforce to provide strategic guidance to GTM teams

San Francisco, California, US

Lead team of 7 Data Engineering/Analytics members to drive tables within ETL (fact and dimension tables related to sales, measure and report on key KPIs across DoorDash, and build various dashboards and scripts to automate and inform stakeholders on company success.

San Francisco, California, US

• Creator and leader of DoorDash Sales Analytics team supporting the Pre-Sales and Post-Sales teams, including creation of the metrics in SQL and owning OKR metrics dashboards in Tableau.Key projects supported:
• Sales Rep Lead List - Created optimization algorithm in Python to evaluate and prioritize top restaurant leads to 300 sales reps quarterly
• Merchant Services - Started up DoorDash's first OKR measurement for Merchant Services performance and raised on-time SLA from 15% to 70% in one quarter by working with cross-functional teams to create the business.
• Contract Compliance - Started up analytics workstream and team to validate agreement compliance across 3 data sources, created a Python API data pipeline, and utilized SQL to compare/aggregate data with Tableau.
• Sales Compensation Design - Subject matter expert for advising metrics to sales leaders and driving payout curve strategy for sales

San Francisco, California, US

• Manage team to provide strategic sales support for Partner sales and Post Salesorganizations
• Lead team to manage company Earned Commissions to determine positive sales initiatives
• Identify/execute opportunities for efficiency gains. Created VBA Tool to generate input filesfor internal sales compensation systems, saving 200 hours per fiscal year

San Francisco, California, US

• Lead of Business Process Innovation (BPI), which involves evaluating processes and workingwith cross-functional teams and programming solutions to fix inefficiencies
• Managed small analytics team to create KPI Decks and Dashboards and presented data andinsights to regional sales leaders
• Researched new method to measure executives and key sales representatives and executedpilot to determine effectiveness

San Francisco, California, US

• Worked on a data integration project with products team, requiring learning their processesand methods in two months to deliver a robust set of tools to migrate and validate data
• Created Excel model to forecast Sales army commissions for current year based on abottoms-up approach by looking at distribution of attainment
• Worked with designers to design various SPIFFs between $10K and $1M to promoteincreased sales attainment and product focus
• Conducted multiple adhoc analyses with Excel and SQL and became team lead to solvebusiness needs of sales leaders

Evanston, IL, US

• Manage daily schedule of 2 associates in international office by determining client needsand analytics required
• Presented results of project with client to create promotional target lists of 40,000 targetssplit between 100 sales representatives
• Brainstormed with client to develop project plan and timeline to support data analyticsteam, created VBA tools to automate data input/output and error checking, and presentedfinal results and deliverables to team

Evanston, IL, US

• Created call plan for over 2,000 sales representatives and 100,000 prescribers for majorpharmaceutical client
• Planned over 1,000,000 samples for sales representatives to increase prescriberaccessibility by programming in SAS
• Created sales goals of over 200 million units split between approximately 200 salesrepresentatives using SAS and Excel modeling

Lake Forest, Illinois, US

• Worked with many functional areas of Grainger to obtain information andrecommended a solution to adjust Graingerʹs labeling requirement, resulting in apotential net savings of $12.3 million annually and $3.0 million.
• Teamed with 8 cross‑functional employees in Graingerʹs supply chain to understandhow the current labeling requirements affect Grainger and its suppliers
• Became project manager for 2 weeks and lead team through the final presentation withsenior management

Master Of Science (M.S.), Industrial Operations Engineering

Bachelor Of Science (B.S.), Industrial Operations Engineering