Apply on Employer Site

Honolulu Cookie Company · 1 month ago

Product Planner & Analyst

Honolulu, HI, US

Full-time

Onsite

Mid Level

$65K/yr - $80K/yr

3+ years exp

Honolulu Cookie Company is focused on combining data analysis with product strategy. The Product Planner & Analyst will analyze market trends, customer needs, and product performance to make data-driven recommendations for product development and improvement.

ConfectioneryE-CommerceRetailSnack Food

Responsibilities

Adhere to and exemplify behaviors aligned with company core values

Foster a sense of teamwork and collaboration among team members by building an employee culture that is aligned with HCC values and operating principles. Ensure all employees are treated consistently, fairly, ethically, and respectfully

Closely monitor product performance and conduct extensive analysis as well as market research to identify areas for improvement. Provide data-driven insights and recommendations, communicating findings and recommendations clearly and concisely

Analyze product sales and bestseller attributes

Track performance of seasonal and core products, making recommendations for stock production and depletion to ensure sell-out by end of season and/or avoid excess inventory

Recommend products to discontinue or revise to make them successful

Monitor and determine if new item sales are incremental

Compare year to year, event to event, season to season performance

Analyze historical data and current trends to identify risks and opportunities

Conduct market research to identify trends, competitive landscapes, and customer behaviors

Develop sales forecasts to determine order qtys and initial stock distribution plans for product launches. Contribute to the planning and execution of product launches and updates

Monitor aging, discontinued inventory, then recommend and process write-offs on a quarterly basis or as needed

Analyze packaging raw material usage vs stock levels and determine reorder quantities, maximizing inventory levels

Request updated quotes for reorders when needed. Process, submit & track reorders for core packaging raw materials, ensuring on-time delivery and communicating delays

Monitor & evaluate vendor performance to determine opportunities

Collaborate effectively with Product Coordinator and cross-functional teams to gather market updates, trends, competitor information, feedback from sales teams and partners, and any other data to consider for product improvement and development. Ensure alignment and successful implementation of recommendations

Establish and monitor KPI's on a monthly, quarterly and annual basis. Distribute and share results with key stakeholders

Produce detailed, comprehensive product sales analysis recaps and presentations, including recommendations

Work with Finance to prepare and provide accurate price analyses for current, new, updated products, to be used in determining optimal finished goods pricing

Other duties as assigned

Qualification

Data analysisMarket researchSales forecastingFinancial analysisExcel proficiencyProject managementMicrosoft OfficeCommunication skillsProblem-solvingAttention to detailTeam collaboration

Required

Strong ability to analyze data, identify trends, and draw conclusions

Excellent verbal and written communication skills

Ability to think strategically with understanding of the 'big picture'

Must have a clear understanding of basic financial measures: Sales, Turn, Gross Margin, Weeks on Hand/weeks of supply, and how to maximize them

Strong attention to detail and high level of accuracy

Ability to manage projects, track progress and meet deadlines

Solution-oriented with strong problem-solving skills

Ability to work both independently and effectively with cross-functional teams

Proficiency in using data analysis tools and software, including advanced Excel skills (pivot tables, vlookups, logical formulas, macros and ability to accurately manipulate large data sets)

Proficiency in Microsoft Office

Bachelor's degree in Finance, Business, Merchandising or other related fields

Minimum 3-5 years' experience in planning/allocation and inventory or other analytical fields