These job descriptions are examples. Looking for work?

Find JobsFind Jobs

ALLOCATION ANALYST – EXCEL EXPERT

0 people like this description

ALLOCATION ANALYST – EXCEL EXPERT
START DATE: ASAP
CONTRACT: ON GOING
LOCATION: CORTE MADERA, CA
PAY: $20.00/HR

** A FORTUNE 500 RETAIL COMPANY IS LOOKING FOR AN EXCEPTIONAL ALLOCATION ANALYST – EXCEL EXPERT! **

JOB DESCRIPTION:
• Allocate first and second quality furniture from DCs to 17 Outlet Stores in a timely and accurate manner
• Perform daily and weekly batch processes for “shelf-stock” (non-furniture) allocations
• Manage minimum and maximum stock levels by store
• Work closely with distribution partners to enhance visibility and transparency of inventory
• Work closely with transportation partners to maximize efficiency and facilitate timely delivery to stores
• Support Outlet inventory planning and analysis
• Provide weekly and monthly merchandise category reporting and analysis
• Recap sales & margin history analysis and present weekly business updates
• Participate in promotional planning process
• Work with Outlet marketing team on development of signage, collateral and graphics
• Assist in creating directives for in-store promotions and events
• Conduct a weekly review to identify merchandise for markups or markdowns and maintain the “Outlet Pricing Guide”
• Assist with monthly offer list management from Main Inventory, Planning & Analysis teams
• Provide weekly and monthly reporting and analysis for assigned merchandise categories
• Recap sales & margin history analysis and present weekly business updates
• Attend and participate in Outlet product development meetings as needed


MUST HAVE:
• Proficient in Excel (Pivot Tables and V-Lookups)
• Knowledge of furniture design and construction
• Knowledge of Outlet business model
• Excellent communication skills – includes influencing and negotiation skills
• Strong analytical skills with the ability to interpret meaningful trends from quantitative and qualitative data
• Solid grasp of retail math and inventory planning concepts
• Highly proficient with MS Office applications (Word, Excel, & PowerPoint)
• Ability to quickly learn proprietary and non-proprietary systems
• Bachelor’s degree in related discipline
• 2-3 years work experience

These job descriptions are examples. Looking for work?

Find JobsFind Jobs