Demand Planner I

Renfro Brands; Mount Airy (NC); On-site; USD 65,000 - 90,000; Full time

Job summary

Renfro Brands seeks a forecasting analyst to generate accurate demand baselines for multiple brands and channels. You will analyze seasonal trends, promotions, and competitive activity, coordinating with Sales and Operations to finalize forecasts.

The role requires strong statistical skills, SQL/Excel, and experience with BI tools to deliver clear visuals and actionable insights to leadership and suppliers.

Qualifications

• Experience with forecasting concepts and time-series analysis.
• Strong analytical and statistical skills with attention to detail.
• Proficiency in SQL/Access/Excel and BI tools for data visualization.

Responsibilities

• Generate demand forecasts for company accounts and SKUs across channels.
• Analyze seasonal patterns, POS trends, promotions and competitive activity.
• Collaborate with Sales, Marketing and Operations to reach consensus forecasts.
• Define SKU safety stock and monitor inventory turns against budgets.
• Create data visualizations and deliver reports to leadership and suppliers.

Skills

SQL

Access

Excel

Tableau

Qlik

Python

R

Forecasting

Time-series

Education

Bachelor’s degree in economics, mathematics, finance, statistics, engineering, supply chain

Associates degree acceptable

Tools

Microsoft Dynamics

Job description

SUMMARYGenerate 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 RESPONSIBILITIESGenerate 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 initiativesCreates 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.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.PROFESSIONAL QUALIFICATIONSExcellent attention to detail, time management skills and meeting deadlinesPositive attitude and ability to handle highly confidential informationAbility to reflect positive attitude and disciplined work ethicAbility to work in a teamAbility to work independentlyHigh energy levelStrong interpersonal skillsDemonstrated experience in being a self-starterAbility to deal with internal/external customers with enthusiasm and professionalismStrong verbal, written and interpersonal communication skills are essentialMust possess confidence, good judgment, energy and the right personality to work in a challenging environmentEDUCATION and/or EXPERIENCEHigh School education and degree, either Associates or Bachelor’s, in economics, mathematics, finance, statistics, engineering, supply chain, analytics or related field, or equivalent work experience.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, business intelligence tools such as Qlik, Tableau, and Microsoft Dynamics.Experience using statistical computer languages (R, Python, etc.) to manipulate and analyze data a plus.KNOWLEDGE, SKILL AND ABILITYMust be a team builder and ability to navigate and work effectively in a large corporate matrixed organization. Ability to collaborate with a team and act in an objective manner to solve problems. Self-starter with proven experience in delivering results to an organization.Demonstrated excellent interpersonal and communication skills. Position requires interaction with senior level management, executives and customers.Must be able to work unsupervised and thrive in a stressful environment; ability to work effectively under tight deadlines and in high-pressure situations.Strong understanding of merchandise planning, allocation strategies, inventory management and operational accuracy.Must have exceptional attention to detail with proven analytical and critical thinking skills.Strong organizational skills with a proven ability to move multiple projects forward in a constructive and positive manner.Familiarity with standard forecasting concepts, practices and procedures.Self-starter with proven experience in delivering results to an organization.PHYSICAL DEMANDS/WORK ENVIRONMENT:PHYSICAL DEMANDSThe physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.Minimal physical demands, such as occasional bending, stooping and walking. Requires frequent computer work. Consistent daily attendance required; occasional off-shift support required. Occasionally required to travel domestically to other office locations.WORK ENVIRONMENTThe work environmental characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.Generally, will work in conditioned office environment.Occasional: activity exists less than 1/3 of the time.Frequent: activity exists 1/3 and 2/3 of the time.*The statements herein are intended to describe the general nature and level of work being performed by associates and are not to be construed as an exhaustive list of responsibilities, duties, and skills required. Furthermore, they do not establish a contract for employment and are subject to change at the discretion of the employer at any time with or without notice.AA/EOE/Minorities/Females/Veterans/Disabled. All qualified applicants will receive consideration for employment without race, color, gender (including pregnancy), gender identity, sexual orientation, national origin, religion, age, disability, veteran status, genetic information or other protected characteristics.*