Space Planning Data Analyst

Manage POG development, assortment accuracy, floorplan integrity and sales/space productivity. Support the Merchandising, Inventory, Marketing and Wilco Store Teams.

Print PDF Overview

Reports To

Vice President of Merchandising and Inventory

Supervises

No supervisory duties required

Employment Type

Full-time

Remote Eligible

Experience Preferred

2 to 5 years

Pay Grade

Second Level

$58968 to $65520 Salary

Category

Merchandising

Business Type

Central Office

Skills

AdaptabilityApproachabilityBuilding RelationshipsBusiness InsightCareer AmbitionComfort Around Senior ManagersCommunicationComposureCreativityCustomer FocusFlexibilityLearning AgilityListeningMotivating OthersPatiencePeer RelationshipsPerseverancePerspectiveProblem SolvingTeamwork

Career Path

Grow from this role

Talk to a Manager for details

Job Details

  • Executes and oversees the development and introduction of all new & notably modified planograms (POG).
  • Utilizes the POG product lifecycle management processes to determine and control which version of each POG is pending, live or historic.
  • Utilizes the product lifecycle management workflow to ensure the most current version of each POG is assigned to the floorplan and the most current floorplan is published as live in the database for each store.
  • Maintains the integrity of store floorplans for all departments, ensuring each stores’ floorplan is current with the most updated planogram files.
  • Develops versioned merchandise planograms, based on store clustering, layout, and size in partnership with Wilco’s Product Merchants.
  • Participates in the seasonal planning process, developing example planograms and store layouts and store layouts for both bulk stacks and end base bases.
  • Builds and communicates Front of Store, Bulk Stack and End Cap Merchandising display directives, store specific planograms in collaboration with the retail Product Merchants.
  • Coordinates data flow into and out of the planogram system on a daily and weekly basis to ensure POG status, floorplan assignment, facings and capacity are accurately captured in the Epicor system to drive replenishment.
  • Support the development of an annual budget for the sales and margin of our various product categories.
  • Prepare gap analysis on merchandise sales and gross margins to inform Product Merchants, Merchandise Analysts and Inventory Planners on business trends.
  • Create scalable and repeatable processes that analyze our business, such as merchandise assortment reviews that rank products and categories based upon contribution of multiple metrics such as sales, gross margin, and return-on-investment.
  • Assists Product Merchants in Merchandise Line Reviews. Applies analytical data analysis and recommendations on placement and space allocation of merchandise to assure that the planograms support the goals of the business from a display and space planning perspective.
  • Collaborates with their business partners in support of company goals, store brand vision, and category strategies as well as provide information and reporting to Product Merchants and management as needed.
  • Assists in developing assisting in merchandise layout and design of new and remodel stores to support company growth goals.
    • Participate in various weekly Merchandising, Inventory, Marketing and Store Operations Team meetings.
    • Participate in store walks and vendor meetings as needed.
    • Updates & publishes reporting as required to support the business per direction from management.
  • Excellent understanding of retail math, strong analytical skills and high math aptitude.
  • Expert understanding of space planning, merchandising & inventory planning concepts required.
  • Epicor expertise preferred.
  • Proficient in MS Office (Excel, Word, PowerPoint, and Outlook). Strong Excel Skills.
  • Proficient in space planning software, such as Blue Yonder JDA, Nielsen Spaceman, Relex Galleria, Symphony, Autocad, preferred.
  • Working knowledge of business intelligence applications such as Power BI, Tableau, Compass , Adaptive, Salesforce, Crystal, Alteryx, Microsoft Access, Minitab, SPSS, Stata, etc.
  • Must have a proven ability to problem solve, perform under pressure, and prioritize effectively to carry out duties and achieve goals with limited supervision.
  • Must have excellent communication skills, be assertive and collaborative, and perform well working with others.
  • 3 + years in Space Planning, Visual Merchandising, or a Merchandising position (required).
  • 5 + years total Retail experience.
  • 1 year Database Management (preferred).
  • 1 year Project Management (preferred).
  • Bachelor’s Degree or equivalent experience in Space Planning or Merchandising.
  • Able to sit and work at a keyboard for extended periods of time.
  • This position is eligible for remote work.
  • Monday through Friday, 8AM to 5PM.
  • Occasional travel to the locations.