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
- Baton Rouge Traffic Incidents, 2021:
Google Data Studio - Visualizing TV Shows Added in 2021: Tableau, Python
- Surfacing Initial Sales Performance Trends: Tableau, Google Sheets, Google Data Studio
- Looker & LookML Projects: Dashboards, Views, and Project Calendar (Upon Request)
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