Merchandise Planner – Data Analyst
The Merchandise Planner is responsible for creating, maintaining, and presenting period and yearly sales forecasts for their assigned categories at a micro (item based) and macro (department, vendor) level. As an integral member of the Supply Chain, you will be responsible for driving strategic alignment across multiple stakeholders for key product launches, promotional activity, seasonal inventory builds, and large customer on-boarding. Additionally, the Merchandise Planner is responsible for developing plans through analysis to ensure Merchandising and Inventory Management are synchronized to achieve or exceed sales, inventory turns, margin and service level objectives. In addition to collaborating with internal partners, you will work closely with external vendors like HP, 3M, and Georgia Pacific. This role provides high level exposure and opportunity to influence business-critical decisions for your assigned categories.
Utilize planning tools to accurately forecast department and/or vendor level inventory $ on hand levels and turn, and achieve budgeted goals
Utilize key item planning tools to forecast demand and supply needs for specific core items
Provide future purchase guidance to vendor partners based on forecasted demand
Develop and maintain positive and effective relationships with vendors.
Operate as the primary contact for the total inventory team
Manage inactive inventory and partner with merchants on dispositions to ensure product is either returned or properly marked down Forecast ads and seasonal promotions.
Make recommendations on product offers to maximize sales and margin while minimizing residuals
Provide ad hoc analysis based on business trends and additional factors.
Forecast various scenarios based on different assortment, price, cost and demand projections to provide merchants recommendations on most optimal ways to drive profitability
Partner with supply chain colleagues to optimize supply chain efficiency through inventory policy Work with inventory analyst to minimize out of stocks and target smart opportunities to increase service levels
Assist in minimizing key supplier lead times to warehouses and fulfillment centers with improved reliability Develop new and creative ideas aimed at optimizing inventory to increase turn and maintain high service levels
Qualifications – External
Proficient in data analysis tools (i.e. Excel and Access) to perform statistical analysis
Detail oriented, with strong planning and organizational skills
Demonstrated analytical and problem-solving skills Strong oral and written communication skills
Strong inventory management experience, with an emphasis on financial and item analysis and planning
Experience using SQL, MicroStrategy or related data mining tools
Experience working with Supply Chain Planning and Inventory Management systems (i.e. E3, JDA, Evant) Proven ability to create partnerships and influence others
To apply for this job email your details to email@example.com