Jonathan Hollinger

1113 Taborlake Drive, Lexington, KY 40502 · (859) 552-5292 · jmholl5@gmail.com

Experienced data architect and analytics leader with a track record of building scalable data platforms to power data-driven decision-making. Significant accomplishments include standing up a modern data stack from scratch at a high-growth SaaS startups and a multi-billion dollar public purchasing cooperative, the implementation and data integration of a property data analytics platform in more than 40 cities, land banks, and nonprofit organizations, and complex financial analysis leading to landmark public pension reform initiatives.

Experience

Head of Data

Mangomint

February 2024 - Present

  • Hired and managed a team of data engineers and analysts.
  • Built and managed data platform in Snowflake, dbt, Prefect, Hightouch, Sigma, and other tools.
  • Managed go-to-market systems including CRM, automations and integrations, and custom apps.
  • Implemented AI agents for data extraction and enrichment.

Senior Data Engineer

Fleetio

December 2021 - February 2024

  • Hired a team of data analysts and engineers to serve data domains across the business.
  • Implemented a new modern data stack using Stitch, Fivetran, Prefect, dbt, Snowflake, Metabase, and Streamlit.
  • Designed data platform architecture, modeling patterns, and established SQL and Python style guides.
  • Created and maintained AWS, Confluent, and Snowflake data infrastructure using Terraform.
  • Implemented and owned orchestration (Prefect) and built custom Python pipelines.
  • Built complex data models in dbt for exposure to BI tools.
  • Created Metabase dashboards and visualizations for stakeholders and provided training and guidance for self-service.
  • Designed and built a custom business intelligence app for core company metrics using Streamlit.
  • Performed code reviews and mentored junior engineers and analysts.

Director of Business and Data Analytics / Data Engineer

NASPO ValuePoint

February 2019 - February 2022

  • Managed the data engineering and analytics team.
  • Implemented a new modern data stack using AWS Lambda, PostgreSQL, Redshift, dbt, and PowerBI to centralize and integrate various datasets.
  • Created data collection tools to organize and process 400+ supplier reports per quarter.
  • Created sales, contract information, event registration, and other business function dashboards in Power BI and Python frameworks.
  • Deployed multiple serverless functions to integrate data between SaaS systems (Formstack, Salesforce, etc.).
  • Performed forecasting analysis using R, Python, and Excel.
  • Developed and deployed internal and customer-facing applications in the Salesforce platform.

Lead Solutions Architect

Tolemi

August 2017 - February 2019

  • Developed data pipelines in Java and Powershell to extract data from difficult to integrate client data sources.
  • Wrote data transformations in SQL to clean and standardize data for analysis.
  • Built data models that scored parcels based on data-driven criteria; examples include fire risk, vacancy prediction, neighborhood health scoring, gentrification risk, and others.
  • Gathered information from clients about their goals, policies and programs to build technology solutions to achieve their objectives.
  • Managed over 40 new implementations of property analytics platform for cities, land banks, and redevelopment authorities.
  • Connected disparate data sources from internal systems to produce analysis for land bank pricing, targeted acquisition programs, proactive code enforcement, and other policy initiatives.

Director of Project Management

City of Lexington, KY

December 2016 - August 2017

  • Secured $14.1M federal TIGER grant for the project, the first ever for Lexington.
  • Supported and advocated for the Town Branch Fund. Their efforts have raised over $25M in private donations for the project.
  • Secured SCAPE Landscape Architecture to complete their design vision for the project and managed the masterplan design process.
  • Developed a custom project management dashboard to communicate project status to stakeholders.

Senior Administrative Officer

City of Lexington, KY

December 2013 - December 2016

  • Created data pipelines and full-stack applications to extract, transform, and visualize department information.
  • Created digital public engagement tools to collect and use public input to design projects.
  • Managed Lexington's Vacant Property Review Commission.
  • Assisted with the creation of Lexington's Affordable Housing Fund.
  • Assisted with major technology implementations, including new permitting and code enforcement systems.
  • Deployed and managed mobile devices (Apple iPad, Apple iPhone) to collect data in the field and improve efficiency.
  • Assisted with managing the department, including over 100 employees and a multi-million-dollar budget.

Legislative Aide

City of Lexington, KY

June 2010 - December 2013

  • Created a custom database to track complaints, issues, and other contacts with the Council Office.
  • Performed and presented extensive research on the Police and Fire Pension Fund, ultimately leading to landmark pension reform legislation in 2013.
  • Served as the primary staff person for the Council budget review process in 2011, 2012, and 2013.
  • Managed all constituent relations for a district Council Office and presented information to the general public on LFUCG programs and projects.

Education

University of Kentucky, Martin School of Public Policy and Administration

Master of Public Administration

August 2009 - May 2011

University of Kentucky, College of Fine Arts

Bachelor of Arts, Arts Administration

August 2005 - May 2009

Skills

SQL (Snowflake, Postgres, Redshift, MS SQL, MySQL, Oracle, dbt)
Python (FastAPI, Streamlit, Pandas)
Node.js (Express, Cube.js)
Data Modeling (dbt, SQL, Python)
Data Warehouse Architecture (Snowflake, Redshift, Postgres)
Orchestration (Airflow, Prefect)
Business Intelligence (Sigma, Looker, Tableau, Metabase, PowerBI)
Cloud Services Configuration (AWS, GCP, Terraform, Pulumi)
API Integrations (REST, GraphQL, SOAP)
Geospatial (PostGIS, QGIS, ArcGIS)

Publications & Presentations

Beyond Metrics Modernization at Fleetio

dbt Coalesce, October 2023

Jonathan Hollinger, Jeff Chen

Data Analytics Demystified

NASPO Webinar, November 2020

Jonathan Hollinger, Shane Caudill, Garret Debate

Preparing to Use Data as a Strategic Tool

Tolemi Webinar, October 2018

Jonathan Hollinger

Kentucky Pension Reform Under Senate Bill 2

Kentucky Bench and Bar, March 2014

R. Douglas Martin, J.D. Chaney, Jonathan M. Hollinger

New Accounting Standards for Government Pensions

Kentucky Bench and Bar, March 2014

Lee Ann Watters, Jonathan M. Hollinger, R. Douglas Martin

Public Art Master Planning for Municipal Governments: Core Components and Common Practices

UKnowledge - University of Kentucky, 2011

Jonathan M. Hollinger