Hi there! I’m a data craftsman passionate about user experience, self-service, and automation.

Summary

I am a data craftsman, building tools focused on user experience, self-service, and automation. My recent (8+ years) work experience encompasses BI, data analysis, data visualization, and analytics engineering. My toolkit includes ELT tools (dbt, Snowflake), query languages (LookML, SQL, Python), and BI/reporting tools (Looker, Tableau, Data Studio, and Excel/Sheets).

Sample Projects

Recent Experience, Highlights

Senior Business Intelligence Analyst: Enervee, Apr ’22 – Present

  • Developed the design template for internal, company-wide dashboards (for online marketplaces); set a Looker Style Guide for front-end dashboard development, which combined native Looker dashboard elements with custom HTML and CSS; employed inclusive design using colorblindness tests in building dashboard color palettes
  • Built data models using LookML for core business segments, including claims (rebates) reporting; spearheaded data modeling for consumer lending, which involved handling JSON objects
  • Served as lead contributor to the migration of derived tables from a PostgreSQL-connected project to a Snowflake-based one

Senior Business Analyst: Angi, Jan ’22 – Apr ’22

  • Served as the Looker SME within Finance Analytics; set a Looker Style Guide capturing best practices for both front-end and back-end development; conducted trainings on building dashboards, managing LookML files, LookML, and SQL Runner
  • Built data models for core business processes including lead (HVL) conversion and attribution, flexible agent scheduling (Flex Pilot), contact rates, and Salesforce event records

Sr. Analyst: Go Disco — Feb 2020 – Oct 2021

  • Scoped and implemented technical components of Sales Ops initiatives; generated about 11K+ business leads in Auckland and Sydney using Jupyter Notebook and Python (BeautifulSoup)
  • Defined key metrics for GTM (Portland, Auckland) campaigns; built the ELT pipeline using Sheets connector and Google Data Studio
  • Streamlined the lead conversion process by automating workflow across systems (Zendesk, PandaDoc, Slack); implemented process automation initiatives across the organization, using tools such as Zapier, Slack (Workflow Builder), Mailchimp, and Rippling

Sr. Analyst, Business (Care & Operations): ShopKeep by Lightspeed — Feb ’15 – Sep ’19

  • Built the data story of Care and Operations; developed the department’s semantic layer using Redshift SQL, LookML, InContact and Salesforce objects; created Looker dashboards for departmental key metrics; served as SME of the department’s Looker space
  • Reduced CRM spend by spearheading customer and ticket records clean up and reduction; provided exploratory and ad-hoc insights to cross-functional initiatives impacting Customer Success, Sales, Product, Marketing, and People Ops
  • Streamlined Customer Care’s 24/7 workforce by building a Google Sheets-based scheduling tool that included a time-off tracker, attendance scorecards, timezone support, and management dashboards

Education

Data Scientist In Python (Data Science), Dataquest.io — 2020

Full Stack Web Development, PDX Code Guild — 2015

MIS, Information Technology, University of Phoenix — 2012 – 2014

IE was a force to be reckoned with during his time at ShopKeep… His passion for data and creating reports that answer critical questions made him an extremely valuable part of my team. I love IE’s drive to build great things, answer complex questions with data, and desire to help others succeed.

Kyle Thiemke, Senior Director at Lightspeed