Junior Data Analyst
Horizon Retail Labs · Austin, TX
Jun, 2024 · Present
• Built Looker dashboards tracking conversion, AOV, and cohort retention for 4 product squads; cut weekly reporting time from 6 hours to under 90 minutes.
• Wrote parameterized SQL models that unified Shopify, GA4, and warehouse inventory feeds; reduced metric mismatches in exec reviews by ~40%.
• Partnered with growth to A/B-test checkout messaging; analysis informed a winning variant that lifted completed checkouts 3.2% over 6 weeks.
• Automated anomaly alerts in Python for daily revenue dips; flagged 12 incidents before they appeared in the CEO digest.
Data Analyst Intern
Capstone Analytics Co-op · Austin, TX
Jan, 2023 · May, 2024
• Cleaned and documented 18 client datasets in BigQuery; shipped reusable dbt staging models used by 3 senior analysts.
• Produced monthly cohort and funnel reports for a B2B SaaS client; supported two board decks with clear visuals and footnotes.
• Built a Python script to validate CSV uploads against schema rules; cut onboarding errors for new data sources by half.
Research Assistant
Campus Insights Lab (UT Austin) · Austin, TX
Aug, 2021 · Dec, 2022
• Analyzed survey responses (n=2,400) in R/Python for student retention study; co-authored internal brief shared with advising leadership.
• Created reproducible notebooks and a simple Streamlit prototype so advisors could explore major-switch patterns without SQL.