Gavin Cameron
Data Science, Analytics, Dashboards and Pipelines
Philadelphia, PA | GitHub | Linkedin
Skills
SQL: Redshift, Athena, Snowflake, Big Query, Databricks, Postgres, Hive
R and Python: Pandas, Polars, XGBoost, Pyspark, Psycopg2, Tidyverse, Dplyr, NLS, Ggplot
ML: Regression and Time Series Forecasting, Churn Risk Scoring, Subscriber Clustering
Data Engineering: Pipelines, DBT, Docker, Github Actions, Lambda AWS, GCP
Analytics: Tableau, Looker, Google Analytics and Tag Manager, Segment, Amplitude
Cookie Consent: CookieYes, CookieBot, OneTrust, Custom Solutions
Experience
Freelance | Data Science & Marketing Technology | Remote | Sep 2014 - Present
Expert implementation of 100+ Google Analytics properties.
Services:
• Analytics event tracking in GA4, Amplitude, Segment, Heap or Pendo
• Marketing pixels done right
• Cookie Consent done right
• Event design & taxonomy modeling
• Data centralization, warehousing and pipelines (AWS, Google Cloud, Azure)
• ML development including lifetime value, subscriber segmentation and churn risk scoring
• Product & marketing dashboards that combine campaign and back end product data
Outcomes:
Measurable impact in over a decade of freelance work derived almost entirely by referrals e.g.,
• Reduced subscriber churn by 3% via risk scoring and targeted retention campaigns
• Increased campaign ROAS 5% by sharing modeled LTV with ad platforms
• Informed decisions by harmonizing multiple data sources into digestible dashboards
Integrations:
Optimizely, Hotjar, Salesforce, Facebook, TikTok, Google & Bing Ads
Electronic Arts | Data Scientist | San Francisco | June 2019 - November 2022
• Increased installs by 1% with a clustering data pipeline to Google Ads Audiences
• Optimized budget allocation decisions by developing a scenario modeling tool
• Freed up time and increased confidence in data by automating audit reporting
GoDaddy | Data Analyst | San Francisco | July 2018 - May 2019
• Improved forecast accuracy using ARIMA time series forecasting for quarterly reporting
• Enabled targeted outreach to pro users with insights via subscriber segmentation
• Informed spend decisions by attributing offline campaign spend using time series modeling
Texture | Data Analyst | Remote | January 2014 - February 2017
• Continuous optimization of sign up, trial to paid and cancel flows
• Developed and maintained a SQL UI to unsampled Google Analytics data
• Helped decision making on cancel flow messaging using text clustering analysis
Education
Heriot-Watt University, Edinburgh, UK — MA in Economics (2006)
Certifications
Personal Interests
Spanish | Freediving | Calisthenics