Summary
Overview
Work History
Education
Skills
Timeline
Generic

Justin Gaertner

Commerce Township,MI

Summary

Data analytics professional with 15+ years of experience turning complex data into actionable insights that guide strategy, marketing, and sales performance. Expertise in building BI dashboards and reports that track KPIs, forecast results, and highlight opportunities across direct mail, and multi-channel campaigns. Proven ability to design predictive models and yearly sales plans that drive measurable business outcomes. Skilled in SQL, Python, R and leading BI tools (Power BI, Tableau, SAS Visual Analytics), with a reputation for quickly mastering new technologies and delivering clear, decision-ready insights to leadership.

Overview

16
16
years of professional experience

Work History

Direct Marketing Analyst II

AAA Life
12.2023 - 08.2025
  • Designed and delivered BI reports and interactive dashboards to provide leadership with real-time visibility into company performance and forward-looking forecasts.
  • Applied predictive analytics and machine learning techniques to forecast monthly sales and key performance indicators, enabling proactive decision-making.
  • Developed predictive response models to generate high-quality sales lead lists, improving targeting and conversion rates.
  • Led monthly cross-departmental meetings to present results, highlight trends, and share future projections, ensuring alignment on business strategy.
  • Conducted ad hoc analyses to answer critical business questions and support strategic initiatives.
  • Managed and validated data sources to ensure accuracy, consistency, and integrity across reporting and modeling processes.
  • Executed direct mail campaign selections and performance tracking, supporting large-scale marketing efforts and optimization of customer outreach.

Analytics Reporting Analyst

Credit Acceptance
01.2020 - 12.2023
  • Analyzed data to inform strategic business decisions.
  • Developed complex programming for data extraction and manipulation.
  • Created reports on key performance indicators (KPIs) to track success.
  • Investigated reporting trends to identify areas for improvement.
  • Executed ad hoc data analytics to support specific user needs.
  • Automated recurring reports to enhance efficiency and accuracy.
  • Monitored and maintained complex statistical models to optimize decision-making processes.
  • Produced reports measuring performance of processes, models, and strategies.

Research Technician Lead

University of Michigan Inter-University Consortium for Political and Social Research
02.2014 - 06.2015
  • Managed and processed large-scale data collections, ensuring accuracy, integrity, and timely availability for research use.
  • Served as the lead on user support initiatives, resolving inquiries, and providing guidance to researchers and stakeholders.
  • Mentored, trained, and supervised interns, fostering skill development and ensuring high-quality project contributions.
  • Conducted reviews of datasets to identify and address confidentiality concerns, performing data transformations to mitigate disclosure risks.
  • Designed and implemented online data analysis tools to increase accessibility and usability of individual study datasets.
  • Performed regular quality assurance reviews of SAMHDA websites, identifying errors and coordinating necessary updates.
  • Contributed to team planning sessions and program evaluations, providing input on contract performance and process improvements.

Research Technician Senior

University of Michigan Inter-University Consortium for Political and Social Research
08.2012 - 02.2014
  • Processed and managed large-scale data collections, ensuring accuracy, integrity, and timely availability for analysis.
  • Served as lead on user support initiatives, resolving inquiries and providing guidance to researchers and stakeholders.
  • Examined datasets for confidentiality concerns and performed data transformations to mitigate disclosure risks.
  • Created online data analysis tools to improve accessibility and usability of individual study datasets.
  • Participated in team planning sessions and program evaluations, contributing to process improvements and contract performance.

Research Assistant (Processor)

University of Michigan Inter-University Consortium for Political and Social Research
07.2009 - 08.2012
  • Processed and prepared research studies for public release on the ICPSR website, ensuring accuracy, consistency, and compliance with data standards.
  • Developed and maintained detailed Excel spreadsheets to document survey layouts, metadata, and supporting materials for researchers.
  • Performed statistical programming, validation, and quality assurance to verify data integrity and improve usability of study datasets.

Education

Bachelor of Arts - Psychology

University of Michigan
Ann Arbor, MI
12.2008

Skills

Analytics & Modeling

  • Data Analytics Predictive Analytics Forecasting Budgeting
  • Predictive Modeling Statistical Modeling Machine Learning
  • Direct Mail Marketing

Programming & Statistical Tools

  • SQL Python R SAS SPSS Stata
  • SAS Modeler SPSS Modeler

Databases & Data Warehousing

  • Amazon Redshift, SQL Server, SQL Server Reporting Services

Business Intelligence & Visualization

  • Power BI Tableau SAS Visual Analytics
  • BI Reporting Data Visualization Business Intelligence

Productivity Tools

  • Excel Access Word PowerPoint

Timeline

Direct Marketing Analyst II

AAA Life
12.2023 - 08.2025

Analytics Reporting Analyst

Credit Acceptance
01.2020 - 12.2023

Research Technician Lead

University of Michigan Inter-University Consortium for Political and Social Research
02.2014 - 06.2015

Research Technician Senior

University of Michigan Inter-University Consortium for Political and Social Research
08.2012 - 02.2014

Research Assistant (Processor)

University of Michigan Inter-University Consortium for Political and Social Research
07.2009 - 08.2012

Bachelor of Arts - Psychology

University of Michigan

Similar Profiles

CREATE PROFILE