Adam Guerin
Denver,CO
Overview
9
9
years of professional experience
Work History
Senior Data Analyst
Neptune Retail Solutions
2022.07 - 2023.08
- 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.
2019.11 - 2022.07
- 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
2018.05 - 2019.10
- 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)
2017.11 - 2018.05
- 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
2015.05 - 2017.03
- 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
2014.09 - 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
2022.07 - 2023.08
Senior Data Analyst
The North Face Inc.
2019.11 - 2022.07
Marketing Data Analyst
Mercury Media
2018.05 - 2019.10
Operations Data Analyst
Cognex Corporation (Contracted Through The Select Group)
2017.11 - 2018.05
Project Manager I / Data Analyst
Farm Credit Financial Partners Inc
2015.05 - 2017.03
Founder / DJ/ Music Producer
Latitude Entertainment / Sifts Music
2014.09 - Current
BBA - Operations And Information Management,
University of Massachusetts Amherst