Assortment Planning Intern - Summer 2027

Thinklance LLP; Atlanta (GA); On-site; USD 28,000 - 39,000; Full time

Benefits offered by this job

Summer internship in Atlanta

In-person program

Professional development opportunities

Leadership exposure

Networking with professionals

Job summary

Thinklance LLP seeks a data analytics intern in Atlanta to develop data-driven methods for SKU performance and inventory optimization. You will build scoring models, analyze categories and suppliers, and quantify benefits of rationalization efforts.

You will create interactive dashboards (Power BI/Tableau), generate executive rankings, and present findings to senior stakeholders. Strong communication and teamwork are essential.

Qualifications

• Pursuing an undergraduate degree in a data-related field (analytics, CS, statistics)
• Experience with data analysis tools (SQL, Python, R, Power BI, Tableau, Excel)
• Ability to work with large datasets and derive insights
• GPA around 3.25+ preferred
• Demonstrated leadership, service, and teamwork values
• Strong communication to motivate and inform stakeholders

Responsibilities

• Develop a data-driven methodology to evaluate SKU performance using velocity, GMROI, turns, and profitability
• Create a scoring framework to identify SKU rationalization candidates
• Quantify optimization opportunities by category and supplier analyses
• 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
• Produce executive-ready opportunity rankings across categories, suppliers, stores, and hubs
• Summarize findings for leadership through presentations and storytelling

Skills

SQL

Python

R

Power BI

Tableau

Excel

AI

Education

Undergraduate degree in Data Analytics or related field

Tools

SQL

Python

R

Power BI

Tableau

Excel

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.