Benjamin Pack Email & Phone Number

Dixon, Ca, Us

Vacaville, Ca, Us

Dallas, Texas, Us

Recruited as an Analytics Engineering and Looker SME to join a fast-moving analytics transformation project.Transitioned to management of a cross-functional team with capabilities including Java, React, Looker, Data Modeling, ETL, and QA.- Gathered business requirements, developed user stories, created data models, and prototyped software solutions to integrate Looker functionality with the client’s existing web app.- Responsible for delivering enhancements and new capabilities across all stages of a full development lifecycle.

Norwich, England, Gb

Asked to apply for an open engineering role after being the Analytics representative on a few cross-functional projects with the Data Platform team. Acted as SME for existing systems, use-cases, and business operations on the new Data Infrastructure team to deliver on the promise of migrating the data warehouse to a new, modern platform.- wrote ingest processes with python for orchestration through Amazon Managed Workflows for Apache Airflow (MWAA) to pull data from Amazon RDS into Redshift via S3.- incorporated ERP and various 3rd party data sources (Amplitude, Facebook, Google, Salesforce) into the data lake and DWH, eliminating dependency on manual data pulls by users.- collaborated with Business Intelligence team to model custom datasets for self-service analytics through Looker.- automated reverse-ETL for CRM data to email marketing platform, reducing data latency and decreasing marketing overhead from manual SQL, segmentation, and upload.

Norwich, England, Gb

A formal title change came alongside the institution of an official Global Analytics team, on which I served as the expert for Growth and Marketing, with a hand in getting our Operations and Finance Analysts up to speed.During this time, I worked directly under the Global Head of Analytics and Data Science, and worked to transition our reporting tool of record from Tableau to Looker.- authored key datasets and dashboards in Tableau and Looker for use by stakeholders in marketing, finance, and operations.- standardized KPIs and aligned new, data-centric business processes across international markets in consultation with global leadership.- wrote full suite of LookML for budget, growth, and subscriber retention/ltv.- managed Salesforce org for B2B sales teams, including user and object management, flow building, and developing a pipeline to ingest key data via EC2 into Amazon Aurora DWH.- automated and optimized SQL from business users for use in new analytics products.

Norwich, England, Gb

After several years of growing my analytical skillset at Naked, I received a change of title to officialize a shift in the focus of my role that had occurred in the year prior. As a Marketing Manager on the Customer Acquisition team, my primary job was to improve future customer acquisition campaigns by examining results from both the present and past, presenting my findings and recommendations up the line; particularly with an eye to the planning, execution, and evaluation of site, promotion, and creative testing.Secondary priorities included ownership of forecasting both new customer campaigns and their associated financial costs, vendor management in Package Insert printing and Direct Mail, acquisition promo management, and letting the other marketers know when lunch arrives at the office.

Norwich, England, Gb

Performed an array of duties related to both Marketing and Business operations:Cost/benefit analysis of insert media partnerships, forecasting of promotional orders, development of business cases for new marketing media campaigns and customer touch-points. Ownership of physical media contracts; production pipeline including partner PIPs, internal promotional pieces, and direct mail. End-to-end project management of direct mail initiatives ranging from customer acquisition to loyalty/retention. Emphasis on working with cross-functional teams, collaboration amongst multiple business units including Accounting, Sales, IT, Design, and Customer Service.Data preparation and campaign review for board presentations.

Rutherford, California, Us

Worked at Rutherford Hill Winery, volunteered to take on additional duties as Retail Inventory Coordinator, implemented new organizational protocols for back-of-house merchandise storage, reduced monthly inventory variance. Led tasting room in implementation of new POS and back-end software, including training of sales and management staff; developed naming convention and SKU system for over 100 products.Regular duties included construction and presentation of monthly reports on sales and inventory, managing guest experiences to leverage brand loyalty, exercising responsible beverage service practices, handling of department interactions with vendors and managing all aspects of the physical inventory.

Bs, Managerial Economics

Education record