Summary
Overview
Work History
Education
Skills
DBT Fundamentals
Timeline
Generic

Amanda Holman

Data Professional
Chicago,IL

Summary

Senior data analyst/analytics engineer with strong analytical skills, adept at leveraging advanced statistical tools and data visualization techniques to drive business insights. Proven track record of collaborating with cross-functional teams to deliver actionable results, adapting seamlessly to evolving project requirements. Known for reliability, critical thinking, and ability to translate complex datasets into strategic recommendations.

Overview

18
18
years of professional experience

Work History

Sr. Data Analyst, Marketing

Weedmaps
05.2023 - Current
  • Wrote custom SQL from disparate data sources to create marketing attribution reporting daily to understand cost of acquisition and cost per conversion action for various paid media channels. Provided QA data support for new campaign launches and post-mortem recaps for department and executive leadership on performance and effectiveness.
  • Saved Lifecycle team 3 business days per month by automating reporting via custom SQL and an interactive Tableau dashboard usable by both executives and front-line staff deploying email campaigns, resulting in reduced errors and faster turnaround to share performance results within the business.
  • Created self-service dashboards for public relations and product marketing teams to talk about shopping trends within popular retail categories, regions and age demographics.
  • The insights contained in this dashboard secured positive press placements for Weedmaps by providing custom data about retail sales trends during major shopping periods (Green Wednesday, Black Friday and April 20) and were featured in industry press outlets.
  • Analyzed and reported findings for CSAT (customer satisfaction) efforts from disparate data sources (app store reviews, surveys, etc.)
  • Deployed new tables/views and changes to existing database models in production via dbt
  • Stack: Snowflake, Redshift; dbt; GitHub; Heap; Segment; Tableau; Branch; Braze; Excel; Google Search Console

Manager, Data Analytics

Brad's Deals
07.2017 - 05.2023
  • Provided reporting and insights to all departments within the company (Finance, Editorial, Sales/Partnerships, Product and Marketing) via custom SQL and interactive Tableau dashboards. Partnered daily with Data Engineering and Data Scientists to create new data sources and troubleshoot Python errors in data ingestion processes. Performed Tableau Admin duties and partnered with Tech Dev Ops team for server upgrades. Managed one full-time analyst.
  • Stack: Snowflake, Redshift; Airflow; GitHub; Heap; Segment; Tableau; Braze; Excel

Sr. Data Analyst

Brad's Deals
07.2017 - 12.2022
  • Successfully onboarded 60+ business users with disparate needs onto a new reporting platform. Migrated data from legacy platform (DOMO) to Tableau with zero errors and no business downtime.
  • Recognized for outstanding performance as Employee of the Month in March 2018

Sr. Manager, Industry Insights and Data Science

Cars.com
10.2007 - 05.2017
  • Managed team of 4 analysts who supported key clients such as CarMax, Autonation and other major dealership groups with custom reporting and insights on competitive landscape and user trends in the automotive industry.
  • Advocated for and hired first interns and full-time data science roles in the company.

Trade Marketing Manager

Cars.com
05.2007 - 08.2010
  • Executed customer-facing email, direct mail, digital and trade show campaigns showcasing Cars.com's value.

Affiliate Marketing Intern

Cars.com
10.2007 - 05.2007
  • Created Excel reports on local competitive intelligence for media affiliate partners (Gannett, McClatchy, etc.)

Education

Bachelor of Science - Education and Social Policy

Northwestern University
Evanston, IL

Masters of Science - Integrated Marketing and Communication

Loyola University Chicago
Chicago, IL

Skills

Self-starter

DBT Fundamentals

Build and deploy models and tests via DBT in Google Cloud and Snowflake environments

Timeline

Sr. Data Analyst, Marketing

Weedmaps
05.2023 - Current

Manager, Data Analytics

Brad's Deals
07.2017 - 05.2023

Sr. Data Analyst

Brad's Deals
07.2017 - 12.2022

Sr. Manager, Industry Insights and Data Science

Cars.com
10.2007 - 05.2017

Affiliate Marketing Intern

Cars.com
10.2007 - 05.2007

Trade Marketing Manager

Cars.com
05.2007 - 08.2010

Masters of Science - Integrated Marketing and Communication

Loyola University Chicago

Bachelor of Science - Education and Social Policy

Northwestern University

Similar Profiles

CREATE PROFILE
Amanda HolmanData Professional