Assortment Analytics Intern: Inventory Optimization

UP CAP; Atlanta (GA); On-site; USD 21,000 - 28,000; Full time

Benefits offered by this job

Professional development

Leadership exposure

Networking opportunities

Job summary

UP CAP seeks a driven data analytics intern in Atlanta to help build a data-driven framework for evaluating SKU and product-line performance. You will analyze sales velocity, inventory investment, GMROI, and turns to identify rationalization opportunities and optimize assortment.

You will collaborate with analytics, inventory planning, and category teams, building Power BI dashboards and executive-ready rankings to support leadership decisions and strategic opportunities.

Qualifications

• Pursuing an undergraduate degree in a data-related field with a strong academic record.
• Experience or coursework using SQL, Python, and data visualization tools.
• Ability to work with large datasets and derive actionable insights.
• Preferred GPA of 3.25 or above and leadership orientation.

Responsibilities

• Develop a data-driven methodology to evaluate SKU and product line performance.
• Create a scoring framework to identify SKU rationalization candidates.
• Quantify optimization opportunities by analyzing categories and suppliers.
• Estimate impact of rationalization actions at multiple levels.
• Support sensitivity analysis for assortment strategies.
• Design and build interactive dashboards in Power BI or similar tools.
• Create executive-ready opportunity rankings across categories, suppliers, stores, hubs.
• Summarize findings and recommendations for business leaders through presentations.

Skills

Data analysis

SQL

Python

R

Power BI

Tableau

Excel

AI basics

Education

Undergraduate in Data Analytics/Data Science/CS/Statistics

Tools

SQL

Python

R

Power BI

Tableau

Excel

AI

Job description

UP CAP seeks a driven data analytics intern in Atlanta to help build a data-driven framework for evaluating SKU and product-line performance. You will analyze sales velocity, inventory investment, GMROI, and turns to identify rationalization opportunities and optimize assortment.

You will collaborate with analytics, inventory planning, and category teams, building Power BI dashboards and executive-ready rankings to support leadership decisions and strategic opportunities.