Assistant Manager, Retail Planning

Charlotte Tilbury Beauty

. Analyze retailer, category, SKU and door-level sales and inventory across the North American Department Store business .

Posted 11/6/2026full-timeNew York City • New York • United StatesMid-LevelSenior💰 $80,000 - $90,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in commercial planning and retail analytics, with a strong focus on sales forecasting, inventory management, and data analysis. Proven ability to translate complex data into actionable insights and recommendations while collaborating effectively across teams.

Highest-signal resume keywords

Commercial Planning ExperienceSales ForecastingInventory ManagementAdvanced Microsoft Excel SkillsData Analytics Platforms Experience

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Sales ForecastingInventory ManagementRetail MathOpen-To-Buy PlanningData AnalysisReport BuildingComplex FormulasPivot TablesSKU-Level ForecastingPerformance Reporting

Soft Skills

Strong Communication SkillsAttention to DetailOrganizational SkillsCollaborative ApproachProactive Mindset

Tools & Technologies

Microsoft ExcelData Analytics PlatformsSAP

Industry Keywords

Retail PlanningMerchandisingDepartment StoresBeauty IndustrySales Insights

About the role

Key responsibilities & impact

Analyze retailer, category, SKU and door-level sales and inventory across the North American Department Store business
Drive sales, optimize weeks of supply and reduce returns
Own weekly performance reporting and translate results versus forecast and prior year into commercial insights, risks, opportunities and recommended actions
Develop and maintain gross sales forecasts aligned with retail sales, trends, promotions, launch plans and inventory requirements
Manage replenishment recommendations by account and open-to-buy planning
Partner with Commercial and retailer teams on reorders, stock balancing and returns
Oversee inventory planning for new product launches, discontinued products and limited-life SKUs
Partner with Marketing, Commercial and Finance on bottom-up SKU-level forecasts
Align sell-in forecasts with Demand Planning and Supply Chain, including stock needs, product availability, shipment timing and fill assumptions
Own new door opening forecasts and initial inventory profiles
Coordinate launch timing, allocations and replenishment requirements
Support retailer-facing meetings and cross-functional business reviews with analysis and recommendations
Improve planning tools and reporting processes
Deliver ad hoc analysis to support business decisions
Report to the AVP, Retail Planning

Requirements

What you’ll need

Minimum of 3 years’ experience in commercial planning, retail planning, merchandising or a related analytical role, ideally within beauty or department stores
Ability to translate complex sales and inventory data into clear insights and actionable recommendations
Strong communication and presentation skills
Solid understanding of retail math, sales forecasting and inventory management, including weeks of supply, sell through and open to buy planning
Advanced Microsoft Excel skills, including lookup functions, complex formulas, pivot tables and report building
Experience with Data Analytics Platforms and SAP is preferred
Strong analytical skills, with experience building, validating and maintaining large datasets
Ability to combine quantitative analysis with commercial context
Collaborative approach and ability to build effective relationships across teams
Strong attention to detail and organizational skills
Ability to manage competing priorities and meet deadlines in a fast-paced environment
Proactive, solutions-focused mindset
Flexibility to adapt to changing business needs and improve existing processes

Benefits

Comp & perks

Generous staff discount to use on all products
Medical, dental, and vision benefits
Commuter Benefits (Pre-tax)
Flex Spending Account (FSA)
Employee Assistance Program (EAP)
401(k) with Company match
Paid Time Off
Birthday PTO