Macy's 2027 Summer Internship - Merchandising - Assortment Planning

Macy's is a retail company offering an 8-week summer internship program in its New York corporate offices. The Assortment Planning Intern will support retail strategy, merchandising, sales and margin analysis, inventory productivity, assortment optimization, and data-driven decision-making across stores and e-commerce channels.

What you'll do:

• Receive professional development through a combination of hands-on learning and collaborative projects
• Build relationships with other interns, business leaders, and team colleagues
• Attend and participate in weekly business meetings to review and recap sales performance
• Analyze product performance data and business trends to identify opportunities and make recommendations
• Support the development of assortment plans aligned with overall business and promotional strategies
• Partner with Merchants and cross-functional teams to support strategic assortment initiatives
• Assess assortment effectiveness by channel and respond to business opportunities
• Conduct competitive and business trend analysis to identify opportunities for growth
• Analyze reports related to channel demand, category performance, vendor performance, and product trends
• Support allocation and inventory management processes to ensure products are positioned to meet customer demand
• Assist with business recaps and presentations by providing insights and recommendations
• Demonstrate agility in reacting to in-season sales trends and changing business needs

What they're looking for:

• High School Diploma or equivalent required
• Junior standing (rising senior at the time of the internship) pursuing a bachelor's degree with a strong academic record
• All majors will be considered for this opportunity
• Strong retail math, analytical, and problem-solving skills with the ability to analyze sales, margin, inventory turn, sell-through, and other key retail performance metrics; identify trends and opportunities; and translate data into actionable business recommendations
• Advanced Excel skills, including Pivot Tables, VLOOKUP/XLOOKUP, formulas, and data analysis techniques; proficiency in Microsoft Office (Excel, Word, and PowerPoint) and the ability to work with large datasets
• Basic understanding of merchandising and assortment planning principles, with strong business acumen and curiosity about the retail industry
• Excellent written and verbal communication skills, including presentation, storytelling, and relationship-building abilities
• Ability to independently organize, prioritize, and manage multiple projects in a fast-paced environment while collaborating cross-functionally with various business partners
• Demonstrated leadership, teamwork, and relationship management skills
• High attention to detail, a commitment to accuracy, and a proactive mindset for identifying opportunities and driving continuous improvement
• Ability to work a flexible schedule based on department and company needs
• May require working with multiple computer screens and programs simultaneously for extended periods of time

Benefits:

• Professional development through a combination of hands-on learning and collaborative projects.
• Opportunities to build relationships with other interns, business leaders, and team colleagues.
• Exposure to senior leaders and networking opportunities.
• The internship program may lead to an opportunity to work full-time with Macy's in its early careers program after graduation.