Adam Guerin
Denver,CO
Overview
9
9
years of professional experience
Work History
Senior Data Analyst
Neptune Retail Solutions
07.2022 - 08.2023
- Developed Python ETL script to automate data flow from Braze Marketing system into Domo dashboarding tools which saved 5 analyst hours weekly
- Created PostgreSQL queries against millions of rows of data to support business analyses and target specific segments of users for marketing use cases
- Utilized analysis to highlight exceptional campaign performance for use in sales materials which resulted in new sales contracts
- Conducted product use experiments in Mixpanel and built dashboards to distribute these insights to multiple departments
- Built self-service dashboards in Domo to empower business users and save 8 hours of analyst work weekly
- Prioritized and delivered ad hoc analyses that helped drive decision making in product, marketing, and sales departments
Senior Data Analyst
The North Face Inc.
11.2019 - 07.2022
- Built and maintained multiple dashboards in Tableau that helped marketing & loyalty teams exceed acquisition goals and measure sales funnel performance
- Utilized ETL skillset and Alteryx to combine email marketing, paid media, web analytics (GA), and loyalty data all into one holistic dashboard
- Identified data gap in Journey Builder within SFMC and proposed solution that increased audience size by 100%
- Partnered with data engineers and third parties on building, validating and maintaining full sales funnel data warehouse with CRM data
Marketing Data Analyst
Mercury Media
05.2018 - 10.2019
- Built and maintained dashboards in Tableau and Excel to meet requirements of both internal and external stakeholders
- Improved client campaigns quarter over quarter by
comparing web traffic in Google Analytics to media spend
and identifying most efficient allocations - Served as liaison between business users and data engineers
to ensure efficient campaign setup for multiple clients
Operations Data Analyst
Cognex Corporation (Contracted Through The Select Group)
11.2017 - 05.2018
- Developed dashboards in Power BI to leverage automated data import, manipulation, and calculation functionality by using DAX language
- Created R script to automate merging of CSV files for underlying dashboard dataset
Project Manager I / Data Analyst
Farm Credit Financial Partners Inc
05.2015 - 03.2017
- Built dashboards in Qlik Sense & Tableau as part of Data Visualization Tool procurement project
- Tracked and managed all activities associated with multiple projects from initiation through to completion
Founder / DJ/ Music Producer
Latitude Entertainment / Sifts Music
09.2014 - Current
- Founded DJ company after observing need for delivering quality services at competitive rates and performed at over 100 private events
- Developed and utilized heuristics on top of SoundCloud, Spotify, and Youtube in order to build cost-efficient music library that optimized audience experience
Education
BBA - Operations And Information Management,
University of Massachusetts Amherst
Amherst, MA12.2015
Skills
- Data Visualization
- SQL
- Excel
- Tableau
- Project Management
- Google Analytics
- Python
- R
- Googling
- ETL Maintenance and Repair
Timeline
Senior Data Analyst
Neptune Retail Solutions
07.2022 - 08.2023
Senior Data Analyst
The North Face Inc.
11.2019 - 07.2022
Marketing Data Analyst
Mercury Media
05.2018 - 10.2019
Operations Data Analyst
Cognex Corporation (Contracted Through The Select Group)
11.2017 - 05.2018
Project Manager I / Data Analyst
Farm Credit Financial Partners Inc
05.2015 - 03.2017
Founder / DJ/ Music Producer
Latitude Entertainment / Sifts Music
09.2014 - Current
BBA - Operations And Information Management,
University of Massachusetts Amherst