Business Analyst – Retail Planning & Replenishment

Business Analyst – Retail Planning & Replenishment Location: Rogers, AR Pay Rate: $36.00 per hour Job Overview We are seeking a Business Analyst to support retail replenishment, sales forecasting, and inventory planning for a major consumer products company.

This position works closely with Sales, Customer Service, and retail partners to improve inventory availability, manage order fulfillment, and support accurate demand forecasting. The ideal candidate has experience in retail replenishment, merchandise planning, or sales analysis, along with advanced Excel skills and the ability to analyze data and recommend business improvements.

Key Responsibilities

• Manage retail replenishment activities to maintain optimal inventory levels and improve product availability.
• Monitor daily orders, purchase order accuracy, and fulfillment rates to support store in-stock performance.
• Analyze sales trends and point-of-sale (POS) data to develop and improve weekly item-level demand forecasts.
• Develop weekly shipping plans by product and sales channel to support inventory requirements and projected demand.
• Coordinate direct import operations from Asia, working closely with international Customer Service teams.
• Collaborate with Sales, Inventory Planning, and retail partners to align demand forecasts and replenishment strategies.
• Participate in Sales and Operations Planning (S&OP) meetings to review forecasts, present findings, and support monthly planning decisions.
• Work directly with retail buyers and replenishment managers to review inventory performance and seasonal demand.
• Identify opportunities to improve forecasting accuracy, inventory management, and operational efficiency.
• Present business analysis, recommendations, and action plans to internal stakeholders and retail partners.

Required Qualifications

• Minimum 2 years of experience in sales analysis, merchandise planning, buying, or a related field.
• Direct experience with retail replenishment planning in a highly seasonal environment with long product lead times.
• Advanced Microsoft Excel skills, including the ability to analyze and manage large datasets.
• Proficiency with Microsoft Office applications.
• Strong analytical and problem-solving skills.
• Experience analyzing sales trends, inventory levels, and demand forecasts.
• Ability to identify process improvements and recommend corrective actions.
• Strong written and verbal communication skills.
• Ability to collaborate with cross-functional teams and present findings to business stakeholders.
• Strong organizational skills and sound business judgment.

Preferred Qualifications

• Experience in Consumer Packaged Goods (CPG) or retail.
• Experience with Power BI, Alteryx, BigQuery, or similar data analysis and database tools.
• Knowledge of statistical forecasting techniques and demand planning systems.
• Experience developing forecasting models and analyzing retail POS data.
• Familiarity with Sales and Operations Planning (S&OP) processes.
• Ideal Candidate The ideal candidate has hands-on experience supporting replenishment and inventory planning for a major retailer or consumer products company.
• They are comfortable working with large datasets, developing demand forecasts, and collaborating with sales and planning teams to ensure products are available when needed.
• Candidates with experience in seasonal merchandise planning, retail POS analysis, and long-lead-time inventory management are particularly well suited for this position.