Searchable public resume
View resume details

Camila Ruiz

Junior Data Analyst
Chicago, IL, United States

Professional Summary

Junior Data Analyst with 2+ years of experience turning retail and operations data into clear, actionable insights. Skilled in SQL, Python, Tableau, Excel, and A/B testing, with a track record of automating recurring reports and improving forecast accuracy. Curious, detail-oriented partner who translates complex findings into practical recommendations for cross-functional teams.

Employment History

Junior Data Analyst
Lakeside Analytics Coop · Chicago, IL
Jun, 2024 · Present
• Built SQL data models and Tableau dashboards used by 6 business teams, reducing weekly reporting time 40%. • Automated Python and Excel quality checks across 250K+ monthly records, cutting data defects 28%. • Partnered with merchandising and operations leaders to analyze A/B tests and recommend changes that lifted campaign conversion 9%.
Data Intern
Midwest Retail Insights · Chicago, IL
Jun, 2023 · May, 2024
• Queried 1.2M transaction rows in SQL to identify assortment trends and deliver weekly category insights to retail partners. • Created Tableau dashboards tracking 18 KPIs, helping account teams spot underperforming regions 2 weeks earlier. • Standardized Excel data-prep templates and documented workflows, saving analysts 8 hours per month.
Research Assistant, Analytics
University of Illinois Chicago · Chicago, IL
Sep, 2022 · May, 2023
• Cleaned and analyzed survey data from 3,500+ respondents using Python and pandas for a faculty analytics project. • Applied statistical testing and A/B experiment design to evaluate student-support interventions; summarized findings for 4 faculty stakeholders. • Presented concise visual reports in Tableau and Excel, turning model outputs into recommendations adopted for the next research cycle.

Education

B.S. Statistics
University of Illinois Chicago · Chicago, IL
Aug, 2020 · May, 2024
Dean’s List; coursework in statistical modeling, database systems, experimental design, and business analytics.

Skills

SQL
Python
Tableau
Excel
A/B testing