Author Image

Hi, I am Garrett

Data Engineer at Lendio and BI Consultant for You.

I am a hungry data engineer that thrives on solving problems by identifying and improving inefficiencies within the organization. I bridge the gap between the technical and strategic stakeholders to find solutions that fit the organization’s needs and budget.

Currently, I have boomeranged to Lendio - the nation’s largest small business lending marketplace - where I am responsible for implementation of business logic and the structure of all reporting layers in the data warehouse. In between my stops at Lendio, I spent a few years at Shutterfly to integrate their customer service and operations and production data to create full insight models. While at Lendio, I oversaw the implementation and strategy of their data viz solution, and helped to launch a franchise division that was ranked in the Entrepreneur Franchise 500 - the only first year network to receive the honor.

I am an avid college football fan, amateur chef and enjoy collecting wet-shaving gear like your grandfather used to.

I hold a BA in Russian from Brigham Young University, as well as an MBA and an MS in Business Intelligence and Analytics from St Joseph’s University.

Skills

Experience

1
Senior Data Engineer
Lendio

Jan 2021 - Present, Lehi, UT

Lendio is the nation’s largest marketplace connecting SMB owners to financing, leveraging a network of 75+ banking institutions

Responsibilities:
  • Senior team member for warehouse integration team
  • Responsible for all business logic driving reporting
  • Train junior team members on BI best practices and technical skill improvement
  • Develop source control procedures
  • Active development on warehouse ingest, reporting layers, and viz tooling.

Shutterfly

Jul 2018 - Jan 2021, Tempe, AZ / Fort Mill, SC

Operations Analytics to enable capturing of life’s greatest moments.

Senior Data engineer

Apr 2020 - Jan 2021

  • Plan, scope and conduct reporting model creation and integration of Lifetouch systems with Shutterfly consumer reporting.
  • Oversee near real-time reporting operations used on manufacturing facility floors to track all Lifetouch Yearbook production.
  • Focus on folding legacy Lifetouch data systems into Shutterfly’s operations data warehouse to provide executives and board holistic views of all brands under the SFLY INC umbrella.
Senior Data Analyst

Jul 2018 - Apr 2020

  • Architect and implement processes to automate data ingest and modeling from 10+ data sources into a centralized data warehouse
  • Write ETL scripts and procedures, cutting ingest time and file storage size by over 80% per data source
  • Collaborate with multiple departments to bring cross department and platform reporting to SFLY
  • Lead team meetings and provide guidance to junior team members on data viz and reporting best practices
  • Help team members improve performance of SQL queries by identifying and sharing efficient query plans
2

3
Head of Data Engagement
Lendio

Aug 2015 - Jul 2018, Lehi, UT

Lendio is the nation’s largest marketplace connecting SMB owners to financing, leveraging a network of 75+ banking institutions

Responsibilities:
  • Produce analytics packages for board meetings and venture capital groups – lead to $20MM Series D
  • Identified and corrected multiple reporting errors, saving the company over $250k in expenses.
  • Drive data and reporting strategies to prospect, forecast and launch franchising division, named the no. 1 franchising opportunity in Financial Services by Entrepreneur in its first year, and the only first year network in the Entrepreneur Franchise 500.
  • Aid in creating ETL scripts for warehouse migration and dimension modeling for self-hosted CRM data, driving all reporting.

Associate Product Manager
SkyCentral

Dec 2014 - Aug 2015, Bountiful, UT

Responsibilities:
  • Manage online content marketing and content creation preparing for product launch
  • Develop KPIs and metrics for internal use with focus on customer acquisition
  • Oversee the development, marketing, sales and support of a newly launched self-service IT portal.
  • Manage all overseas relationships with developers based in Eastern Europe and Indian based QA
  • Find and outsource contractors, building long term relationships and processes which cut production costs by over 70%.
  • Seek new strategic partners and resellers.
4

Projects

Give 'Em Hell, Brigham
Give 'Em Hell, Brigham
Founder May 2020 - Present

GEHB is a pdocast/merchandise brand focused on BYU athletics. My co-host and I host weekly shows covering finance, food, football and other recent events. We maintain a dedicated webstore with apparel shipped international to Cougar fans around the globe.

Give 'Em Data, Brigham
Give 'Em Data, Brigham
Founder March 2021 - Present

Give ‘Em Data, Brigham is a spin-off of GEHB - it is a maintained Metabase instance with public sharing for College Football Analysis and Visualizations. It’s driven with a BigQuery instance and utilizes GCP Cloud Functions/Scheduler to automate data ingest from the CollegeFootballData.com API, 247Sports, and Sports-Reference with Metabase running on a DigitalOcean box.

cflfastR
cflfastR
Creator / Author June 2021 - Present

cflfastR is an R library that wraps the official CFL API. The API is free for fans and nerds alike - this library makes it accesible and provides many of the features shared across the Sports Dataverse libraries and its cousins nflfastR and cfbfastR.

Cougar Sports Insider
Cougar Sports Insider
Staff Writer July 2018 - Present

Cougar Sports Insider is the BYU Affiliate of 247Sports. My role on our editorial staff focuses on projections and data driven analysis around BYU football, basketball, and baseball.

Education

MS Business Intelligence & Analytics
Master of Business Administration
BA Russian
Extracurricular Activities
  • President of Russian Club
  • Communication Director Non-Profit Management Student Association
  • Student Section Committee Member / AD Marketing Intern