Grant Pendrey
Chicago,IL
Summary
Analytics Engineer with over 6 years of experience in designing scalable data models and building unified data warehouses. Successfully led cross-functional data initiatives and implemented modern BI platforms to enhance self-service analytics. Proficient in dbt, BigQuery, Python, and SQL, with a strong focus on translating complex data into actionable insights.
Overview
10
10
years of professional experience
Work History
Lead Analytics Engineer
Fuego Leads, LLC
Columbus, OH
01.2020 - Current
- Built unified data warehouse aggregating 50+ sources (CRMs, advertising platforms, health insurance sales, accounting, 7 in-house applications), enabling analytics access for hundreds of users
- Designed data pipelines feeding Google/Bing Ads platforms, scaling marketing spend 8.9x in year one ($1.1M to $9.8M) and reaching $48M+ annually by 2026
- Led Sigma Computing BI implementation, migrating 120+ users from legacy solutions and reducing report build time by 50% through curated self-service data models
- Administered Zoho CRM for 90-agent health insurance call center, implementing custom fields, workflows, and automations to streamline agent operations
- Evolved data infrastructure through 4 major platform migrations: Google Sheets → MySQL/Plotly Dash (2020): Established first centralized reporting database, enabling reliable performance data that drove the 8.9x marketing spend expansion, SQL Server Agent Jobs (2021): Reduced query time from minutes to seconds, dbt/BigQuery (2023): Reduced backfill time from weeks to minutes, Established data contracts with backend development team to define upstream data requirements, enabling reliable measurement of key business metrics, Implemented dbt testing framework for data quality validation, Sigma Computing (2025): Enabled enterprise self-service analytics
- Built Python/FastAPI data API for cross-platform integrations with Slack, internal tools, and third-party systems
- Established data office hours program across 8 business verticals, evangelizing data literacy and analytics adoption company-wide
Junior Salesforce Developer
WillowTree (formerly DYNAMIT)
Columbus, OH
11.2018 - 01.2020
- Main developer on Salesforce CRM project for one of the largest hotel chains in the world
- Translated 13 Excel spreadsheets into technical requirements and solution architecture
- Implemented brand standards tracking program ensuring compliance across hotel renovations and updates
- Served as in-house expert on Conga Composer, creating 30+ document templates across multiple client use cases
Junior Data Scientist
DYNAMIT
Columbus, OH
07.2016 - 11.2018
- Maintained Postgres/SQL data pipelines for ~$5 billion healthcare client's marketing analytics
- Implemented Google Tag Manager and Google Analytics across 20+ client websites
- Designed and executed A/B tests across 12+ client websites
- Increased regional food chain's online revenue by $1.1M annually through improved coupon visibility
- Identified underperforming variant for nationwide restaurant chain, avoiding $2.0M in estimated losses
- Created and delivered Google Analytics and Tag Manager training program for regional utility company, upskilling a team of 5 technical staff
- Conducted statistical analysis in R Studio for pizza chain client project analyzing promotional menu item cannibalization
Education
Bachelor of Science - Informatics
Indiana University
Bloomington12.2015
Skills
- dbt / dbt Cloud
- SQL
- Python
- Google BigQuery
- Data Modeling
- ETL/ELT
- Data Warehousing
- SQL Server
- Sigma Computing
- FastAPI
- SQL Server Agent Jobs
- Google Cloud Platform (GCP)
- Git
- Zoho CRM
- Salesforce
Timeline
Lead Analytics Engineer
Fuego Leads, LLC
01.2020 - Current
Junior Salesforce Developer
WillowTree (formerly DYNAMIT)
11.2018 - 01.2020
Junior Data Scientist
DYNAMIT
07.2016 - 11.2018
Bachelor of Science - Informatics
Indiana University