Summary
Overview
Work History
Education
Skills
Timeline
Generic

Benjamin Pack

Dixon,CA

Summary

Dependable Engineer and Analyst experienced in developing and applying custom, stakeholder-centric data solutions. Strong communication skills, expertise in discussing technical concepts with business users. Efficiency-obsessed analytical thinker and collaborative team member.

Overview

10
10
years of professional experience

Work History

Data Engineer

Naked Wines
07.2022 - Current
  • Migrated DWH from Aurora to Redshift, improving performance and scalability while minimizing business disruption.
  • Optimized data processing by implementing efficient ETL pipelines and streamlining database design.
  • Collaborated with cross-functional teams for seamless integration of 2nd and 3rd-party data sources into the company's data ecosystem.
  • Automated CRM rETL pipeline to ESP, improving timeliness and quality of marketing data assets and reducing marketing overhead.
  • Enhanced data quality by automating data sanitation and transformation to suit business needs.
  • Designed and implemented data models for complex analysis needs.
  • Implemented monitoring protocols through Slack to alert on failures and system actions across Airflow and Redshift to accelerate recovery.

Sr. Analyst, Growth & Business Operations

Naked Wines
04.2020 - 07.2022
  • Migrated company analytics platform from Tableau to Looker, democratizing data assets and improving their availability.
  • Developed standardized KPIs and data-centric business processes for international use, improving speed and efficiency of global decision-making.
  • Provided timely insights and forecasts to senior management, enabled reliable business operations and informing strategic decisions.
  • Collaborated with cross-functional teams to identify and remediate areas underserved by analytics, unlocking data-driven improvements to existing business processes.
  • Championed data-first decision making by transforming raw data into actionable intelligence for stakeholders.
  • Mentored junior analysts, fostering professional development and enhancing overall team performance.

Marketing Manager / Analyst

Naked Wines
04.2017 - 04.2020
  • Organized and delivered weekly presentations to stakeholders, reviewing ongoing campaign performance and proposing followup actions.
  • Executed marketing partnerships and initiatives to grow and retain the subscriber base, utilizing home-grown analytics to track campaign success and refine tactics as needed.
  • Generated market segmentations insights, enabling targeted customer acquisition campaigns.
  • Managed financial forecasting and budgets, economizing allocation of funds to best serve business goals.
  • Owned key vendor relationships for marketing materials and collateral, including inventory depletion and ERP usage.

New Business Account Manager

Naked Wines
11.2013 - 04.2017
  • Supported New Business team through data entry, cost-benefit analysis, and forecasting of campaigns.
  • Qualified B2B partnership leads through prospecting and brand research.
  • Produced reports and slides for board presentations on growth of the customer base and key brand partnerships.
  • Managed Direct Mail projects end-to-end, from list qualification through performance evaluation.
  • Developed weekly-cadence Direct Mail program for onboarding new subscribers, reducing initial attrition.
  • Collaborated with Finance, Operations, and Customer Service departments to ensure preparedness for upcoming campaigns.

Education

Bachelor of Science - Managerial Economics

University of California - Davis
Davis, CA
06.2012

Skills

    Languages PostgreSQL, Python, LookML

    Technologies Airflow, Docker, Redshift, EC2, S3, Tableau, Looker

    Soft Skills Communication, Technical Empathy, Stakeholder Management

Timeline

Data Engineer

Naked Wines
07.2022 - Current

Sr. Analyst, Growth & Business Operations

Naked Wines
04.2020 - 07.2022

Marketing Manager / Analyst

Naked Wines
04.2017 - 04.2020

New Business Account Manager

Naked Wines
11.2013 - 04.2017

Bachelor of Science - Managerial Economics

University of California - Davis

Similar Profiles

CREATE PROFILE
Benjamin Pack