Retail Planning Analyst - Intimate Apparel

About the role

Dana-co, a leading design company of luxury lingerie, is seeking a Retail Planning Analyst to join our Strategic Planning team. This role provides critical reports and information to management, sales, merchandising, design, finance, production, and forecasting teams to support day-to-day business operations and the execution of sales strategies and initiatives. The position involves maintaining and validating data collection, analyzing retail performance, and developing actionable insights about business trends and opportunities.

Key qualities for this role include a deep understanding of retail metrics, the ability to identify data trends, accuracy, knowledge of the competitive landscape, and innovative analysis to validate business opportunities.

Responsibilities

• Retail Sales Data
  • Track retail sales and stock
  • Maintain POS style selling database
  • Publish weekly selling reports
  • Perform seasonal market share analysis
  • Create management reports
  • Facilitate best seller meetings
  • Prepare monthly reports of new product launches
• Profit Tracking
  • Maintain detailed log of allowances
  • Maintain projected markdown liabilities by account
  • Provide detailed accrual at month end
  • Track and report on Allowances, Givebacks, and Gratis
• Revenue Budgets
  • Maintain budget and shipping forecast process, including gross shipment and dilution budgets, channel, basic-to-fashion ratios by account/brand, and flow by month
  • Assist with researching and creating annual revenue and giveback budget spreadsheets
  • Publish annual budgets to the sales team and research exceptions
• Retail Account Profitability
  • Review and analyze financial reports from accounts by brand (OTB)
  • Recommend actions and/or suggest alternatives by creating ‘what if’ scenarios
  • Present findings to management
• Additional Responsibilities
  • Communicate between departments as needed
  • Provide support to management (ad-hoc reporting)
  • Provide support to Sales (ad-hoc reporting)
  • Partner with Forecasting to provide retail sales data as a check and balance against the forecast

Requirements

• 5 years of professional experience as a planner, analyst, or buyer in the department store industry
• Bachelor’s degree
• Advanced understanding of Excel, including pivot tables, V-lookup, and Macros
• Highly analytical and data-driven individual
• Highly organized and detail-oriented
• Excellent math skills and accuracy
• Hands-on experience with inventory management and planning
• Strong teaming and collaboration skills
• Ability to meet deadlines and handle multiple tasks/projects
• Background in lingerie/intimates is a plus

Benefits

• Health, vision, and dental insurance
• Flexible spending accounts
• Paid vacation, sick, and personal time
• Paid holidays
• 401(k) with a company match
• Parental leave (including non-birthing parents)
• Short-term disability
• Employee Assistance Program (EAP)
• Bereavement support
• Education reimbursement
• Voluntary benefits, including term life insurance, short-term disability, AD&D, critical illness, hospital indemnity, accident insurance, and group legal services
• Employee discounts

Schedule

Full-time: Monday to Friday, 40 hours per week (in-office 4 days and remote 1 day).