Location: REMOTE -- working PST hours generally 

SUMMARY

Generate demand accurate baseline forecast for company accounts and Stock Keeping Units (SKU) for multiple brand lines within multiple channels. Examines inventory levels for product to ascertain company’s optimal financial performance and potential future sales. Analyzes and manipulates aggregated forecast, shipments data and time-series into comprehensive documents to be published with senior leadership and suppliers for planning purposes.

ESSENTIAL DUTIES AND RESPONSIBILITIES

• Generate demand accurate baseline forecast for company accounts and Stock Keeping Units (SKU) for multiple brand lines within multiple channels to reflect insightful analyses of seasonal patterns, POS trends, planned promotions and impact of competitive activity. Must maintain high level of accuracy and utilize advanced analytical & statistical skills.
• Facilitated collaborative monthly forecast meetings with Sales, Marketing and Operations team to review the baseline demand plan along with market trends and program assumptions to drive to a consensus forecast.
• Analyzes and manipulates aggregated forecast, shipments data and time-series into comprehensive documents to be published with senior leadership and suppliers for planning purposes.
• Participates in yearly financial budgeting.
• Define SKU level Safety stock through mathematical model to achieve in stock and inventory goals.
• Communicate with brand managers to identify discrepancies with life cycle codes and correct them in Renfro’s in-house system & database.
• Creates an interpretation of data through the use of tools, Mathematics, Statistics, industry experience and logic to frame situations and allow meaningful dialogue and decision making.
• Analyzes data by comparing the planned output with actual output and correct imbalances.
• Meaningfully interprets the data and present it through dynamic visualization.
• Creates retail sales and shipment trend reporting for collaboration for maximize sales and supply chain efficiency.
• Collaborates on day-to-day business requirements with sales, production planning and operations to achieve inventory turn goals and sales budget to anticipate unidentified factors affecting the supply chain through intimate knowledge of product development initiatives
• Creates reports, data bases and participates in line planning, merchandising, and post-seasonal reviews by providing product performance and customer behavior analysis.
• Create mathematic and statistic models that best fit each category/brand and test created models to ensure high accuracy.
• Provides ad hoc business analyses as needed.
• Creates effective channels of communication with external and internal account contacts. Consults with these contacts as needed to verify accuracy of data, future strategies and current state.
• Conducts store visits to better understand competitive products, pricing and changes.
• Analyzes ALR data, where available, to provide additional data points in increasing accuracy.
• Utilizes problem solving methods to accurately define problems, generates alternatives and implements counter measures that permanently resolve planning problems by addressing their root cause.
• Conform with and abide by all regulations, policies, work procedures and instructions including but not limited to confidentiality requirements.

EDUCATION and/or EXPERIENCE

• Secondary education and degree, either Associates or Bachelor’s, in economics, mathematics, finance, statistics, engineering, supply chain, analytics or related field.
• Prefer at least three years of relevant and related work experience, such as in retail, wholesale sales, buying, planning or supply chain.
• Computer skills: SQL, Access, Microsoft Office products, with expert level with Excel.
• Desired experience working with web-based portals, QlikView Business Intelligence, Microsoft Power BI, Tableau and Microsoft Dynamics.
• Experience using statistical computer languages (R, Python, etc.) to manipulate and analyze data a plus.