Garrett McClintock

• Own and operate SOL Veterinary, a full-service companion animal practice in Scottsdale, Arizona; direct every back-office function including finance, operations, HR, payroll, and technology.
• Built the clinic’s data platform on Snowflake with dbt transformations and dlt ingestion pipelines pulling from the EzyVet practice management system, Divvy spend, and Plaid banking data.
• Deployed Nao, a self-hosted AI analytics assistant, so the clinical team can query operations, finance, and marketing data in plain language.
• Automated reporting end to end, including a daily financial and operational recap to leadership and automated month-end book closes.
• Built internal admin tools (Next.js) for scheduling, inventory, and credentials, cutting manual back-office work.

• Complete ownership of the data platform: Data Ops, modeling standards, and governance.
• Architected and executed a greenfield migration to Snowflake and Sigma, lowering platform cost by 40%.
• Implemented an AI-ready enterprise data model to enable natural-language querying (NLQ) through proper policies and guardrails.
• Led efforts on implementing AI through data and analytics engineering product cycles.
• Engage vendors and manage relationships, negotiating contracts with Snowflake, Sigma, and peers.
• Created the reporting model that operationally tracks OKRs.

• Executed budget and implementation of all ETL tooling, identifying unnecessary tools and cutting annual spend by $50k.
• Identified bottlenecks in data transformations, leading to a 60% reduction in Snowflake spend, nearly $1MM annually.
• Refactored the legacy dbt project, cutting runtime 40% on pipelines operating over billions of records per run.
• Architected and built a new enterprise dimensional model with full testing and documentation.
• Designed the reporting process to automate month-close ARR reporting end to end.

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

• Senior team member for the 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.

• 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.

• 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.

• Produce analytics packages for board meetings and venture capital groups, leading to a $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 the 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.

• 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.