Assortment Planning Intern - Summer 2027

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

Your Role

Here’s what you will be doing:

• Develop a data-driven methodology to evaluate SKU and product line performance using metrics such as sales velocity, inventory investment, GMROI, inventory turns, fill rate contribution, and product profitability.
• Create a scoring framework to identify SKU rationalization candidates and highlight products consuming disproportionate inventory relative to their business value.
• Quantify optimization opportunities by analyzing product categories and suppliers to reduce inventory investment, improve inventory turns, increase GMROI, and enhance assortment productivity.
• Estimate the impact of potential rationalization actions at category, supplier, and product-line levels.
• Support sensitivity analysis to evaluate benefits and risks of various assortment strategies.
• Design and build interactive dashboards in Power BI or similar tools.
• Create executive-ready opportunity rankings highlighting largest assortment optimization opportunities across categories, product lines, suppliers, stores, and distribution hubs.
• Summarize findings and recommendations for business leaders through presentations and visual storytelling.
• Collaborate with stakeholders from assortment planning, category management, inventory planning, and analytics teams to validate business assumptions and ensure actionable recommendations.

About You

The company is looking for:

• Currently a rising junior or senior pursuing an undergraduate degree in Data Analytics, Data Science, Computer Science, Statistics, or related field.
• Experience with data analysis tools such as SQL, Python, R, Power BI, Tableau, AI, and Excel.
• Ability to work with large datasets and derive actionable business insights.
• Preferred GPA of 3.25 or above.
• Leadership qualities embodying values of service, performance, influence, respect, innovation, and teamwork.
• Effective communication skills to motivate and inspire others through clear and proactive communication.
• Focus on delivering results and customer success by making customer-centric decisions.
• Strategic thinking and balanced decision-making as a forward thinker.

Compensation & Benefits

• 10-week summer internship program in person in Atlanta from May 24 – July 30, 2027.
• 40-hour work week, Monday to Friday, 8:00 AM – 5:00 PM with a 1-hour lunch break.
• Meaningful work contributing to key business priorities with a final presentation to senior leaders.
• Professional development experiences to build skills, confidence, and workplace understanding.
• Leadership exposure through connections with leaders and senior executives.
• Networking and community-building opportunities with fellow interns and employees.

Expected Deliverables

• SKU Productivity & Rationalization Framework evaluating inventory productivity and identifying optimization opportunities.
• Opportunity Sizing Model estimating potential inventory reduction, turn improvement, and profitability benefits.
• Interactive Dashboard for exploring opportunities by category, supplier, store, and distribution hub.
• Executive Opportunity Ranking highlighting highest-impact assortment optimization opportunities.
• Final Leadership Presentation summarizing key findings, recommendations, and next steps.