Searchable public resume
View resume details

Leo Vargas

Junior Data Analyst
Chicago, IL, United States

Professional Summary

Junior data analyst with 2+ years turning messy operational data into clear dashboards and weekly insights for retail and logistics teams. Comfortable with SQL, Python, and Looker; known for clean documentation and stakeholder-friendly storytelling.

Employment History

Junior Data Analyst
North Loop Analytics · Chicago, IL
Jan, 2025 · Present
Built Looker dashboards used by 40+ ops managers; cut weekly reporting time from 6 hours to under 90 minutes. Wrote SQL pipelines that reconciled inventory and POS data across 12 stores with 99.5% match rate. Partnered with merchandising to A/B test promo pricing; findings lifted weekend attach rate by 8%.
Data Analyst Intern → Junior Analyst
Midwest Freight Collective · Chicago, IL
Jun, 2023 · Dec, 2024
Automated delayed-shipment alerts in Python; reduced manual triage tickets by ~30%. Designed a cohort retention view that helped ops prioritize high-churn lanes. Documented metric definitions in Notion so finance and ops shared one source of truth.
Research Assistant
Campus Insights Lab (DePaul University) · Chicago, IL
Sep, 2022 · May, 2023
Cleaned survey datasets for 1,200+ student responses; produced charts for two faculty papers. Taught peer workshops on Excel + introductory SQL for 25 undergraduates.

Education

B.S. Business Analytics
DePaul University · Chicago, IL
2023
Relevant coursework: Applied Statistics, Data Visualization, Database Systems

Skills

SQL
Python
Looker
Tableau
Excel