Resume

Experience, education, and skills — all in one place.

Prefer a PDF? Download a copy of my resume below.

Download PDF

Jace Iverson

Data Engineer
[email protected] jaceiverson.com linkedin.com/in/jaceiverson github.com/jaceiverson
Summary

Data Engineer with a background in Management Information Systems and 5+ years of experience building distributed ETL/ELT pipelines, cloud infrastructure, and developer tooling. Deep expertise in Python, dbt, Snowflake, AWS, and Prefect. Track record of automating complex workflows, reducing costs, and enabling data-driven decisions at scale.

Experience
Senior Data Engineer
Apr 2025 – Present
Terakeet — Syracuse, NY (Remote)
Data Engineer
Sep 2023 – Apr 2025
Terakeet — Syracuse, NY (Remote)
  • Plan, build, and maintain ETL/ELT pipelines storing billions of rows of data in Snowflake and Google BigQuery.
  • Develop and maintain deployment automation for Data Engineering pipelines through GitHub Actions.
  • Primary maintainer of multiple private GitHub repos, each with custom CI/CD strategies and workflows.
  • Collaborate with Data Science team to align pipeline architecture with modeling and AI needs.
Senior Business Intelligence Analyst
Jun 2022 – Aug 2023
Terakeet — Syracuse, NY (Remote)
  • Built automated reports to analyze raw HTML data and identify website changes period-over-period.
  • Developed custom API wrappers and ETL pipelines for keyword tracking and analytics platforms.
  • Analyzed 30+ GSC properties for CTR patterns using Snowflake; delivered Tableau dashboards to leadership.
SEO Analyst
Sep 2020 – Jun 2022
Terakeet — Syracuse, NY (Remote)
  • Built data pipelines using Python and Google App Script to automate reporting workflows.
  • Organized and taught weekly Python courses helping team members implement Python in daily work.
  • Automated Google Doc template creation from Google Sheets, saving over 4,000 hours monthly.
  • Created data visualizations and dashboards in Tableau to communicate SEO performance to clients.
Solutions Team Analyst
Jan 2020 – Sep 2020
iFit Health and Fitness Inc. (Home Delivery Team) — Logan, UT
  • Automated 50+ hours of recurring work processes using Python, MSSQL, Google Sheets, and Tableau.
  • Created interactive dashboards to visualize supply chain data and KPIs; managed Tableau Online Site.
  • Saved $100,000/year through contract analysis with a new carrier.
  • Predicted total delivery costs monthly and coordinated with accounting to validate results.
Junior Data Analyst
Sep 2020 – Dec 2020
Mechanical and Aerospace Engineering Department, Utah State University — Logan, UT
  • Visualized 5 years of departmental data for ABET accreditation using Tableau and Excel.
  • Provided weekly summaries to ABET supervisor in preparation for department meetings.
Network Operations Center Engineer Intern
May 2019 – Aug 2019
The Church of Jesus Christ of Latter-Day Saints — Information and Communication Services — Salt Lake City, UT
  • Monitored global WAN comprising over 10,000 network devices.
  • Oversaw all internal and external applications including 15+ public-facing systems.
  • Performed routine maintenance on 2,000+ Windows and Linux servers.
Licensed Property & Casualty Insurance Agent & IT Specialist
Aug 2016 – Dec 2019
The Insurance Center LLC — Ogden, UT
  • Managed 6 company websites, 40+ company email addresses, and 15 VoIP phones.
  • Trained Ogden, Logan, and Midway agencies on a new internet-based phone system.
  • Designed data-driven presentations tailored to top clients and prospects.
Skills
Advanced
PythonAutomationData PipelinesdbtAWS (S3 / Lambda / API Gateway / ECS)SnowflakePrefectDockerGoogle Cloud PlatformGoogle App ScriptGoogle API SuiteExcelPowerBITableauGit / GitHub / GitHub Actions / Pre-CommitSlack Development
Basic
LinuxC++
Projects
2025 – Present
Cost Tracking Dashboard
Q1 2025 – Q2 2025 | Terakeet
  • Built 12 dbt models from 5 sources of Snowflake query history data into a format ready for visualization.
  • Planned and implemented a query tagging strategy across 4 tools to attribute Snowflake compute costs and AI consumption down to the client and query level.
  • Designed and built a Sigma dashboard to surface those insights for business stakeholders.
AI Insights Project
Terakeet
  • Primary engineer on a dbt project comprising 26 models across 14 unique sources.
  • Incorporated 3 Snowflake AI functions, AWS Comprehend integration, and recursive CTEs for parsing nested JSON with changing schema.
  • Coordinated dependencies outside of Snowflake, including a Postgres database synced via PeerDB and external AWS Lambda proxies.
URL Classifier via dbt & Snowflake AI
Terakeet
  • Developed a dbt model using custom Snowflake AI functions to classify unique URLs sourced from upstream model outputs.
AWS Comprehend Pipeline
Terakeet
  • Developed a pipeline using Prefect, Snowpark, and dbt to extract targeted sentiment analysis from AWS Comprehend.
TAM Project
Q1 2024 – Present | Terakeet
  • Developed a distributed pipeline using FastAPI and Prefect with Dask, AWS Elasticache, and Snowflake — targeting 150,000 requests processed per hour.
  • Primary maintainer of 3 private GitHub repos, each with its own CI/CD strategy.
  • Built a robust test suite with mocked Snowflake, Prefect, AWS, and request objects.
  • Incorporated retry mechanisms on key API calls; collaborated regularly with Data Science team.
Premier League Discord Bot
Aug 2024 – Present | Personal
  • Built a bot using Fotmob, IMGBB, Discord, and AWS APIs to facilitate weekly game predictions.
  • Used reaction events to track weekly predictions and season-long statistics via JSON data structures.
GHIN Alternate Handicap Calculator
Personal
GitHub Repo
  • Built a pipeline to calculate alternative golf handicap values using internal GHIN APIs.
  • Increased insight into playing ability through alternative calculations and visualizations.
Tee Time Selector
Personal
  • Consolidated available tee times by querying APIs from multiple tee-time booking websites.
2023
GitHub Action Deployment Automation
Q3 2023 | Terakeet
  • Created deployment pipelines for Prefect and Snowflake stored procedures inside GitHub Actions.
  • Built and tested conditional deploys based on branch and commit status; significantly reduced manual deployment time.
Keyword Research Pipeline Tool
Q3 2023 | Terakeet
  • Built a system that takes user input, makes API calls to 6 different endpoints, conditionally transforms data, and displays final output.
  • Wrote documentation covering API costs, input types, and usage tips; implemented logging and error handling.
CTR Analysis to Revamp Internal Tooling
Q1 2023 | Terakeet
  • Analyzed 30+ GSC properties and separated data into 3 CTR buckets for use in internal tooling.
  • Used Snowflake to clean data and separate branded vs non-branded terms using regex.
  • Delivered interactive Tableau visualizations to upper management.
Seasonality Metrics Comparative Analysis
Q1 2023 | Terakeet
  • Compiled GSC, MOZ, SEMRush, and Google Trends data in Snowflake using their respective APIs.
  • Built a comprehensive Tableau dashboard outlining multiple methods of computing seasonality.
  • Presented recommendations and deployment plan to internal stakeholders.
Asset Graph Project
Q1 2023 – Present | Terakeet
  • Built a data lake comprising 5 external API sources called via AWS Lambda.
  • Automated ingestion into Snowflake using UDFs and stored procedures (ELT); scheduled via Prefect.
2022
app.getstat.com API Wrapper
Q2 2022 | Terakeet
  • Developed a custom API wrapper for a keyword tracking platform to facilitate monthly reports.
  • Built an ETL pipeline to clean and store data long-term in Google BigQuery.
AppsScript Email Automation
Q1 2022 | Terakeet
  • Automated email notifications from Google Sheets based on cell criteria using AppsScript.
  • Notified project managers when tasks were ready via HTML emails with direct cell links.
Content Audit Automation
Jan 2022 – Present | Terakeet
  • Scrapes published pages from a Sheet, compares the live site to recommended changes, and produces an implementation scorecard.
  • Currently saves each content specialist approximately 10 hours per audit.
2021
Python Course Instructor
Oct 2021 – Present | Terakeet
  • Organized and taught weekly Python courses for team members, from fundamentals through advanced topics.
  • Prepared Colab notebooks with examples and assignments covering database connections, web scraping, and APIs.
Advent of Code Automation
Dec 2021 | Personal
  • Created a tool to automate web scraping, file creation, and project structure setup for Advent of Code.
  • Provided detailed documentation for replication; uses engaging challenges to drive continued Python learning.
Project Management System Integration
Dec 2021 | Terakeet
  • Integrated Asana with Google Sheets via AppsScript for real-time task creation and retrieval using the Asana API.
  • Reduced confusion and provided a centralized source of truth for project managers.
FHS Golf Analysis & Visualization
Sep 2021 | Personal
GitHub Repo
  • Provided detailed comparative statistics for a local high school golf team.
  • Displayed data in a Google Data Studio visualization for easy interpretation by coaches and players.
Reporting Automation
Sep 2021 | Terakeet
  • Developed automated weekly and monthly reporting from GA and GSC data.
  • Files saved to Google Drive; email confirmations with performance comparisons sent to key stakeholders.
Projections Tool
Q3 2021 – Q4 2021 | Terakeet
  • Created a quick way to do seasonal time series projections using GSC or GA data.
  • Leveraged Facebook's open-source Prophet library to generate projection visualizations.
People Also Ask Tool
Q3 2021 | Terakeet
  • Developed a tool to analyze the first 4-5 PAA questions from a SERP result.
ELO & Google Sheets
Q2 2021 – Present | Personal
GitHub Repo
  • Built an ELO rating system integrated with Google Sheets including custom App Scripts to maintain formatting.
Google Doc Template Creation with Apps Script
Jun 2021 | Terakeet
  • Created an interactive menu for document creation from Google Sheets data fields.
  • Saved over 4,000 hours monthly; reduced hiring need from 8 employees down to 2.
Chess.com API Project
Jun 2021 | Personal
Deseret Sports Web Scraping Project
May 2021 | Personal
Screaming Frog Crawl Comparison
Q2 2021 | Terakeet
  • Built a comparison tool providing a detailed diff between two Screaming Frog crawls.
  • Outputs added/removed URLs and each changed element per URL, plus a summary page.
pandas-compare (PyPI)
Q2 2021 | Personal
Google Trends Custom Extraction
Q2 2021 | Terakeet
  • Built a Colab notebook that extracts queries from a Sheet and outputs Google Trends data.
  • Displayed results in an interactive Google Data Studio dashboard grouped by query category.
GSC Projections
Q1 2021 | Terakeet
  • Forecasted a two-year expected plan for organic site traffic using GSC data.
  • Built a reusable Colab process for anyone with time series CSV data to generate predictions.
GSC to GBQ Data Pipeline
Q1 2021 | Terakeet
  • Connected Google Search Console API to Google BigQuery and automated the full ETL process.
  • Built tests, logs, and automated morning email reports; added a fail-safe to auto-recover from errant API pulls.
slackbot
Q1 2021 – Present | Terakeet
2020
googlewrapper (PyPI)
Q4 2020 – Present | Personal
  • Developed and maintain a custom Python API wrapper for Google products.
  • Products: Google Analytics, Search Console, Sheets, Docs, BigQuery, Pagespeed, and Calendar.
Personal Portfolio Site
Jan 2020 – Present | Personal
  • Designed and built a personal portfolio site with plain HTML, CSS, and vanilla JS.
  • Hosted on GitHub Pages with a custom domain via CNAME.
2019
FBAC Online Order Processing System
Jan 2019 – May 2019 | MIS5900 (Program Capstone)
  • Created an online ordering system to replace a voicemail-based ordering workflow.
  • Built using Laravel (PHP) and MySQL; utilized UML techniques for documentation and system architecture.
Custom Riot Games API & Flask App
May 2019 | College Project
Management System Change
Aug 2018 – Aug 2019 | The Insurance Center
  • Led agency (4 locations, 15 agents) through a management system migration for the first time in 19 years.
  • Attended weekly WebEx trainings and passed instruction to employees and management.
  • Analyzed data conversion to verify accuracy; applied change management principles to drive adoption.
2018
BI Group Alumni Research
Sep 2018 – Dec 2018 | BI Group
  • Created a specialized Qualtrics survey for BI Group alumni to analyze career relationships and paths.
  • Collaborated on analysis with master-level MHR and MMIS students.
  • Organized a presentation for the MIS department head to promote interdisciplinary student groups.
Claim Analysis
Jun 2018 | The Insurance Center
  • Created models to predict customer claim trends and visualize cost breakdowns of various coverage options.
  • Retained a top client by presenting data-driven coverage analysis to company executives.
Overland Peak Resort Analysis
Feb 2018 – May 2018 | BI Group
  • Performed advanced SQL queries on a relational database with 203,140 data points.
  • Applied linear regression, cluster, and decision tree analysis in RapidMiner to solve business problems.
Education
B.A. Management Information Systems
December 2019
Jon M. Huntsman School of Business, Utah State University — Logan, UT
  • Member of the exclusive Huntsman Scholar Program, providing international business experience.
  • Member of BI Group and Association of Information Systems; Volunteer Ambassador of BlueCrew.
  • Dean's List: Spring 2017, Fall 2017, Spring 2018.
  • Recipient of the Dean's Scholarship (academic-based 2-year full-tuition scholarship).
Leadership
Huntsman Scholar Peer Mentor
Aug 2018 – Present
Jon M. Huntsman School of Business, Utah State University — Logan, UT
  • Mentored 5 fellow scholars through their college experience at Utah State.
  • Set and followed up on semester goals; assisted peers in finding academic and professional resources.
BI Group Team Lead
Aug 2018 – Dec 2019
BI Group, Utah State University — Logan, UT
  • Led a select group of MIS students performing analytics projects for local companies.
  • Advised, consulted, and presented analytical findings directly to business clients.
Secretary & Volunteer Ambassador
Sep 2016 – May 2018
BlueCrew (USU Student Association) — Logan, UT
  • Took detailed minutes of weekly meetings and prepared agendas for committee president.
  • Encouraged student involvement on and off campus through personal interaction and social media.
Portuguese Speaking Service Volunteer (Full-Time)
Aug 2014 – Aug 2016
LDS Church - Non-profit — São Paulo, Brazil
Mom did a good job following along. Here is the blog.
  • Led groups of 10-20 people through weekly trainings, goal setting, and daily follow-ups.
  • Became fluent in Portuguese through daily conversation and interaction with locals.
  • Adapted to new cultures, strengthening ability to work effectively with diverse teams.