Justin Lee Email & Phone Number

Tempe, Az, Us

San Francisco, Ca, Us

Austin, Texas, Us

Lead analyst to tackle SQL & python deep dives into complex business problems, define KPIs,and deliver strategic insights to executive management through a mix of Google Sheets,Looker, and Google Slides. Experienced with business unit KPIs, forecasting, and VC levelpresentations to keep a holistic pulse on company performance.Ownership of Looker, DBT, and Redshift analytics stack for efficient data synthesis across acomplex marketplace data model. Hands-on expertise with developing LookML, DBT, and SQL Models.Built a LookML dashboard for the Event Marketing team which highlighted opportunities for market penetration. Recommended retargeted Business Development strategy tounderserved regions which led to 25% improvement in trade show revenue year-over-year.Automated air and sea freight quotations using python API calls and internal Google Sheetapp which resulted in a 80% reduction of manually generated shipping quotes.

Providence, Ri, Us

Optimized query efficiency and built ETL pipelines for healthcare and personal wellness data, supporting a global clientele in 100+ countries.Developed automated KPI reports for external clients using Domo and Microstrategy toprovide data-driven insights on platform goals and user behavior.Utilized Python, SQL, AWS S3, and airflow to orchestrate ETL pipelines for medical plan data,significantly reducing fraudulent claims and platform misuse. Improved data checks from 88% to 98% within two quarters.

Greenwood Village, Colorado, Us

Joined as an early employee for a high-growth B2B SaaS marketplace with 20+ vendors,focusing on implementing reporting solutions to track key sales metrics and stand up 0-1processes in Data Operations and Finance.Implemented strategies to boost the on-time accounts receivable rate from 45% to 85% in 3months, recovering $3 Million of monthly recurring revenue in past due receivables,significantly enhancing cash flow in a startup environment.Developed Power BI reports and dashboards for Sales analytics, empowering Sales teams withclear data visualizations for KPI tracking and informed decision-making on sales strategies.Collaborated with DevOps and Sales leadership to automate CRM Data Operations tasks,resolving 40% of issues in the first month and saving over 300 man-hours by eliminatingmanual ticket entry.

Greenwood Village, Colorado, Us

• Generated $300k+ revenue in first year through solution-based sales approach which leveraged internal ability to manufacture crosssellable goods• Launched company social presence through multichannel marketing and customer driven content which resulted in 50% of net new customers driven from Google Ads

Provide quality customer service to online customers and in retail store. Ensure revenue growth through direct sales strategies. Present items to trade shows and vendor events in order to drive traffic to the store. Market new products and sales to online markets (Amazon, Craigslist, Ebay). Maintain communication to vendors about purchasing and new product releases. Provide technical support through phone. Assist in maintaining IT infrastructure.

Bachelor’S Degree, Business Management

Computer Science