Junior Data Analyst
Lakeshore Analytics Group · Chicago, IL
Jan, 2025 · Present
Owned 8+ weekly operations and growth dashboards in Tableau, improving stakeholder self-service and cutting recurring reporting time by 30%.
Built and maintained SQL pipelines for 12 source tables, adding validation checks that reduced refresh errors by 25%.
Partnered with product and marketing leads to size A/B tests, define success metrics, and deliver concise experiment readouts.
Automated recurring stakeholder reporting with reusable SQL extracts and documented metric definitions for 20+ users.
Data Analyst Intern
Midwest Retail Insights · Chicago, IL
Jun, 2024 · Dec, 2024
Analyzed sales cohorts across 40+ retail locations to identify repeat-purchase patterns and opportunities for targeted promotions.
Built weekly Tableau packs for merchandising and growth leaders, shortening performance review preparation by 20%.
Cleaned and reconciled 75,000+ transaction rows in Excel and SQL, documenting assumptions and resolving duplicate customer records.
Presented concise findings that informed a pilot loyalty campaign and improved segment-level reporting consistency.
Research Assistant
Campus Decision Lab (Northwestern affiliate) · Evanston, IL
Sep, 2023 · May, 2024
Cleaned and standardized 18,000+ survey responses for student research projects, creating a repeatable quality-check workflow in Python.
Built Python notebooks with pandas to summarize response rates, missingness, and demographic cuts for faculty and student researchers.
Supported literature reviews and prepared annotated evidence tables that helped frame research questions and survey instruments.
Translated exploratory findings into clear charts and short memos for weekly lab discussions.