Trevor Wong
Trevor Wong

Data & Analytics Professional

Seasoned Data Analyst with 12 years of expertise in various SQL dialects and spatial analysis. Proficient in BI Tools such as Tableau, Looker Studio, and Power BI. Known for discovering actionable insights and delivering compelling presentations to stakeholders. Conducts training sessions on GIS and other data-related skills. Loves spatial analysis, data visualization, and ramen.

Download Resume
Key Skills
SQL

PostgreSQL, Vertica, Redshift, Presto, Spark

Spatial Analysis

PostGIS, ArcGIS, QGIS

Business Intelligence

Tableau, Looker, Google Data Studio, Power BI

Retail Analytics

Discounting, Marketing Measurement, Customer Segmentation, Site Selection

Training

SQL, QGIS, Excel

Presentations

Powerpoint, Slides, Keynote

Project Management

Jira, Asana, Confluence

Product Development

UI Design, UI Testing

Experience

  1. Senior Analytics Consultant

    Amperity
    • Served eight client companies in retail, travel, and transportation industries ranging from $10 million to $10 billion in revenue
    • Produced and presented email campaign reporting to demonstrate effectiveness of multi-flight campaigns
    • Used Regex parsing on 32,000 unformatted data fields to analyze customer spending and lead-to-sale timing
    • Developed method for appending demographic information to 135 million limited PII records
    • Created statistical model assigning gender probabilities from 157 nationalities and ethnic groups to limited PII customer records, improving prediction rates by 25% over existing model
    • Drove adoption of in-platform client-accessible reporting

  2. Project Manager, Campaigns & Ripple

    BlueLabs
    • Analyzed demographic data, historic election results, and past violations of voting rights to geographically target areas in need of Voter Protection support during the 2020 election
    • Validated person-level religiosity models and generated insights and use- cases for client
    • Created analysis and reports of client-facing influencers database to demonstrate value to customers and reference for relationship expansion
    • Produced network graph expansions using Python and Gremlin Querying Language
    • Generated and delivered survey samples from occupation and donation data

  3. Tools Support Engineer

    Catalist
    • Transitioned user creation workflow to incorporate third party SSO vendor
    • Created Tableau reporting of user behavior for product optimization
    • Designed user permissioning structures for next generation identity resolution platform

  4. Battleground States Analytics Lead / GIS Administrator

    Hillary for America
    • Led Strategic planning and goals creation for national field program with over 2,600 organizers and 1.8 million volunteers
    • Deployed PostgreSQL/PostGIS geodatabase and other GIS tools to 70 state analytics staff
    • Developed geographic reporting
    • Established metrics, analytics frameworks, and data reporting tools to assess voter contact performance in Ohio, Pennsylvania, and Virginia
    • Optimized Iowa early vote locations using spatial analysis to maximize turnout

Education

  1. Certificate in Geographic Information Systems (GIS)

    University of Washington
    • Professional and Continuing Education program teaching GIS skills using ArcGIS.
    • Course content covered site selection, IDW/Spline/Krieg interpretation methods, and cartography.
    • Won 2nd place in the Richard ‘Dick’ Thomas Student Presentation Competition at the 2011 Washington GIS Conference with a presentation on modeling forestry land sale prices.

  2. Bachelor of Arts - Political Science, Minor in Chemistry

    University of Washington
Projects & Volunteering
Limited PII Gender Model
Amperity ∙ December 2023
Created statistical model assigning gender probabilities from 157 nationalities and ethnic groups to customer records with limited PII (Personally identifiable information), improving prediction rates by 25% over existing model.
Recount 2020 - Arizona Data Director
Recount 2020 ∙ November 2020
Recount 2020 was a project to provide data and analytics support to legal efforts around the 2020 election. I led Recount 2020’s data operations for Arizona. Duties included projecting likelihood of a recount, preparing for ballot curing, and creating data pipelines of election result data.
Chefs for the Polls - Site Selection
World Central Kitchen ∙ October 2020

World Central Kitchen (WCK) planned to place food trucks outside polling locations for the 2020 General and 2020 Georgia Runoff elections.

  • Created a model to forecast voting irregularities in FL, GA, and NC
  • Scraped polling location precinct assignments using the Google Civic API
  • Used Spatial Analysis to determine food truck locations that could serve multiple priority voting sites
Understanding Policy Influencers’ Priorities in a Post-COVID World
Glover Park Group ∙ May 2020
Survey of Policy Influencers (Elected Officials, Staffers, Business Leaders, Major Donors) attitudes toward COVID response. Findings include heavy political polarization with a small group of persuadable Republicans.
Data BootCamp Coach
Wellstone Action ∙ February 2016
Coached students through an intensive six day bootcamp designed to prepare the next generation of political data professionals. Students went on to work in multiple states and organizations in the 2016 campaign.