Hannah Ruiz
Data Analyst
hannah.ruiz@example.com(555) 902-4471Chicago, ILLinkedIn: www.linkedin.com/in/hannahruiz
Summary
Data analyst with 4 years in e-commerce and subscription analytics. SQL-first with dbt and Looker; analyses drove a shipping-threshold change worth $2.1M in annual contribution margin and a retention fix that cut 90-day churn 12%.
Experience
Data Analyst
Apr 2023 – Present- Analyzed basket composition across 8M orders and recommended raising the free-shipping threshold; change added $2.1M annual contribution margin with no measurable order-frequency loss
- Built dbt models powering the retention dashboard used weekly by 3 VPs, replacing a 6-hour manual spreadsheet process
- Identified an onboarding step where 40% of churned subscribers stalled; the resulting fix cut 90-day churn 12%
- Run A/B test readouts for the growth team (10-14 tests/quarter), standardizing significance thresholds that ended ship/no-ship disputes
Junior Data Analyst
Jun 2021 – Mar 2023- Maintained 20+ Looker dashboards for restaurant operations, covering delivery times, cancellations, and driver supply
- Automated weekly performance reporting with Python and Airflow, saving the team 10 hours/week
- Flagged a data-pipeline gap that had understated late deliveries in two markets, correcting SLA payouts
Skills
Analysis: SQL (window functions, CTEs), Python (pandas), A/B testing and statistics, Cohort and funnel analysis, Experiment design
Tooling: dbt, Looker, Tableau, BigQuery, Snowflake, Airflow, Excel
Education
B.S. Economics
Aug 2017 – May 2021Certifications
Google Advanced Data Analytics Certificate — Google / Coursera (Nov 2022)