Ben Brill

Data Science/Statistics

Experience

Coordinate migration of historical compensation and personnel data for 59,000 teammates over six years and construct ETL pipelin for incoming data to virtual warehouse to improve analytic workflows and increase data transparency for stakeholders.
Employ advanced statistical methodologies in Excel to assess and interpret compensation data, resulting in data-driven recommendation that inform company’s salary structure, total rewards, and bonus initiatives.
Construct reports and dashboards to analyze compensation initiatives like enforcing minimums on salary ranges, transitioning to a target-based bonus, and ensuring proper funding across 2,000 facilities to present to C-Suite stakeholders
Benchmark new and existing roles against market data to ensure roles are equitable, aligned, and competitive across market

Computed add-to-cart and checkout conversion rates for over 16 million different checkouts for Shopify Shipping merchants using SQL queries to analyze effect of delivery promise badge
Designed, engineered and repaired shipping data pipelines using PySpark and Kafka to transform raw data into processed data and send to engineering for production purposes
Created four interactive reports, presentations, and videos to communicate findings on Shop Promise platform to internal buyer trust data team and stake holders
Tested, debugged, and assisted launch of Shop Promise platform to over 150 pilot merchants

Developed scraper in Python to extract over 250,000 unique records of mathematics doctoral students and cleanly store within a SQL database
Researched six different name gender classification algorithms and reported on various biases
Presented over 10 different visualizations and three different machine learning algorithms to faculty at three different institutions to describe trends in gender diversity in math academia

Assisted and supported students working on collaborative python assignments during 4 weekly discussion sections
Collaborated with professors and teaching assistants to create over 15 different discussion assignments during content meetings

Managed hiring, training, and personnel of Graphics department of the Daily Bruin, an award winning newspaper with an audienc of over 45,000 students and staff.
Spearheaded creation of a new training curriculum and hiring criteria focusing on data journalism and interactive graphic content
Designed over 20 different graphics for both print and online editions