Retail Planning Analyst - Intimate Apparel

Dana-co, a leading design company of luxury lingerie, is looking for a Retail Planning Analyst to join our Strategic Planning team that provides reports and information to management, sales, merchandising, design, finance, production, and forecasting for day to day running of the business and the execution of sales strategies and initiatives. The process includes maintaining and validating data collection and analyzing retail performance to develop strong conclusions about business trends and opportunities. Necessary qualities of a Retail Planning Analyst include a full understanding of retail metrics, how to spot data trends, accuracy, knowledge of the competitive landscape, and innovative analysis to validate business opportunities. Primary Responsibilities Retail Sales data • Track retail sales and stock • Maintain POS style selling database • Publish weekly selling reports • Seasonal market share analysis • Create management reports • Facilitate best seller meetings • Monthly reports of new product launches Profit Tracking • Maintain detailed log of allowances • Maintain projected markdown liabilities by account • Provides detailed accrual at month end • Track and report on Allowances, Givebacks and Gratis Revenue Budgets • Maintain budget, 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 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 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 department store industry Bachelor’s degree Advanced understanding of Excel, pivot tables, V-lookup, Macros & Microsoft Office Highly analytical, data-driven individual Highly organized and detail-oriented Excellent Math skills Accuracy Hands-on experience with inventory management and planning Excellent at teaming and collaboration Ability to meet deadlines and handle multiple tasks/projects Background in lingerie/intimates is a plus Benefits for full-time employees include: Health, vision, and dental insurance Flexible spending accounts Paid Vacation, Sick, Personal time Paid Holidays 401(k) with a company match Parental leave (non-birthing parents included) Short-term disability Employee Assistance Program (EAP) Bereavement Support Education Reimbursement Voluntary benefits include term life insurance, short-term disability, AD&D, critical illness, hospital indemnity, accident insurance, and group legal services Employee discounts Equal Opportunity Statement: Dana-co is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce. We provide a work environment that is free from discrimination and harassment based upon any legally protected characteristic, including, but not limited to, an individual’s sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy. Full Time: Monday to Friday, 40 hours per week Work Location: In-office 4 days and remote 1 day