Jon Herrick

Jon Herrick

Data Strategy Manager · Merkle, Inc


In My Own Words

A data analyst with 18+ years of experience and a robust data strategy and analysis background. Skilled in
data modeling, visualization, and statistical analysis, with a track record of delivering actionable insights to
drive business decisions. Highly proficient in SQL, Python, and data visualization tools such as Tableau.
Proven ability to work independently or as part of a team to identify key business metrics, perform data
analysis, and communicate findings to stakeholders. Passionate about leveraging data to drive business
value and improve decision-making processes.

Work Experience

Data Strategy Manager

Merkle, Inc

2021 – 2023

Planned analysis by writing measurement plans and learning agendas for promotions and customer loyalty programs. Leveraged data and technical skills to create reporting databases to evaluate performance and identify areas for improvement in acquisition, engagement and retention.

? Provided quantitative and qualitative analysis and insights for 20 clients over two years ? Lead analysis for seasonal games and promotions with +5M unique participants and +79M engagement actions per promotion ? Segmented zero and first-party member audiences to understand behaviors and preferences between loyalty members and the general population ? Wrangle, aggerate and analyze complex datasets of +100M rows with high dimensionality from varying sources using custom SQL tables and data frames in R and Python

Market Intelligence Manager

Kenworth Truck Company

2019 – 2020

Owned economic and market reporting. Collected, analyzed, and presented industry and customer data to determine model mix, technology take rates, market size, and market share to enable data-driven decisionmaking.

? Developed eight reporting solutions to target new customers, explain market trends, and buying cycles ? Tableau Administrator with more than 150 users, 18 dashboards, and complex data extracts ? Tableau Champion: mentored and guided colleagues in data preparation, custom calculations, and dashboard design ? Subject matter expert and Kenworth Division representative for five U.S. and Global PACCAR projects ? Wrote SQL queries using Access, Microsoft Management Studio, Tableau, Snowflake, and MySQL tools to combine data from cloud data sources and on-premises servers ? Used R to obtain and combine economic data from multiple sources with API calls

Data and Reporting Analyst

Hyundai Motor America

2013 – 2015

Primary analyst in the Retail Process & Sales Satisfaction department. Using survey data collected by J.D. Power, we helped to improve the car buying experience for our customers and over 300 dealers.

? Supported corporate field and dealer staff through research and resolution of survey issues and related dealership bonus payments ? Researched and communicated findings of survey fraud with supporting evidence to dealership and field staff ? Saved over ten hours, producing ten weekly and monthly executive reports using PowerPoint, pivot tables, macros, and customized reporting layouts ? Executed requests for ad hoc reports and analyses of Customer Satisfaction data across all HMA departments

Education

BA

California Baptist University

2016

BA

Master of Science

Western Governors University

2022

Master of Science

Industries

LifestyleHealth & FitnessSnowTechSurfOutdoor

Connections

Companies I Follow

See all