Junior Data Analyst
Apex Retail Analytics · Raleigh, NC
Jan, 2024 · Present
• Automated weekly sales and inventory reporting in SQL and Python, cutting preparation time by 40%.
• Built Tableau dashboards tracking 12 KPIs across 18 retail locations, improving regional visibility for 6 managers.
• Reconciled 25,000+ transaction records and partnered with engineering to reduce recurring data-quality exceptions by 28%.
• Analyzed promotion performance and identified a 9% lift opportunity in underperforming categories.
• Documented metric definitions and QA checks, shortening stakeholder review cycles from three days to one.
Data Analyst Intern
Triangle Insight Lab · Durham, NC
Jun, 2023 · Dec, 2023
• Queried and joined 1.2M-row healthcare and survey datasets in SQL to support five client research engagements.
• Created reusable Excel and Python validation scripts that reduced manual cleaning time by 30%.
• Produced 15+ client-ready charts and briefing tables, translating statistical findings into concise recommendations.
• Standardized intake templates and data dictionaries, raising first-pass quality review scores to 96%.
Research Assistant / Student Analyst
NC State University · Raleigh, NC
Aug, 2022 · May, 2023
• Cleaned and analyzed student survey data from 2,400 respondents using R and Excel for faculty research projects.
• Built reproducible codebooks and summary tables that cut weekly reporting time by 25%.
• Presented findings on retention and course engagement to a faculty working group of 10, informing two pilot interventions.
• Mentored three student researchers on spreadsheet QA, version control, and clear chart design.