Replenishment Planner

Insight Global; Bethesda (MD); On-site; USD 70,000 - 100,000; Full time

Job summary

Insight Global in Bethesda, MD is seeking a Store Replenishment Planner to lead and optimize store-level inventory strategies across our national retail footprint. You will develop and execute replenishment plans to ensure product availability, support sales growth, and improve inventory productivity, reporting to the Sr.

Manager, Store Replenishment Planning. This role partners with Buyers, Merchandising, and Store Operations, mentoring junior planners and leveraging Excel, SQL, and VBA to

Qualifications

• 2-3 years experience min
• Advanced Microsoft Excel skills (Pivot tables, Vloppkups, complex formulas, large data sets)
• Ability to parse through large data sets to find and correct issues
• Ability to thrive in a fast paced environment Some exposure to SQL (basic querying), VBA/macros (automation)

Responsibilities

• Lead and optimize store-level inventory strategies across our national retail footprint.
• Develop short- to mid-term replenishment forecasts for assigned territories and present recommendations.
• Collaborate with Buyers and internal partners to resolve inventory limitations and ensure timely product availability.
• Assist with Master Data functions including information and data entry via system uploads.

Skills

Excel

SQL

VBA

Data analysis

Education

Bachelor's Degree in Supply Chain, Business, Economics or related analytical field

Tools

Pivot tables

VLookup

Job description

Job Description

Hours: 8-4 coreYou will lead and optimize store-level inventory strategies across our national retail footprint. In this role, you will drive the development and execution of replenishment plans that ensure product availability, support sales growth, and improve inventory productivity. You will serve as a key liaison between Supply Chain, Merchandising, and Store Operations, and play a critical role in mentoring junior planners and influencing cross-functional initiatives. This is a high-impact role ideal for a strategic thinker with deep analytical skills and a passion for retail supply chain excellence. You will report to the Sr. Manager, Store Replenishment Planning.

Essential Functions: 60/40 split leaning chris way (bob is more operational focused)

• Assess planning system parameters and implement manual adjustments to generate weekly store replenishment orders that support demand within short-term inventory constraints. (15%)
• How much inventory will stores need over the next few weeks or months?"
• Sales trends
• Seasonal demand
• Promotions
• Inventory levels
• Develop short- to mid-term replenishment forecasts for assigned territories and present recommendations to the manager for inventory optimization. (15%)
• Collaborate with Buyers and internal partners to resolve inventory limitations and ensure timely product availability across the network. (10%)
• Partner with buyers and merchants when:
• Products are running low
• Demand spikes unexpectedly
• Distribution issues occur
• Assist with Master Data functions including the determination of appropriate information and data entry mostly via system uploads (30%)
• They maintain product data such as:
• SKU information
• Store assignments
• Vendor details
• Ordering parameters
• Inventory settings
• Lots of:
• Excel uploads
• Data validation
• Data cleanup
• Assist with the creation of integration files with trading partners to ensure smooth and timely operational execution. (30%)
• Creating and validating files exchanged between:
• Total Wine systems
• Vendors
• Suppliers
• Distribution partners

This is why SQL, VBA, and Excel automation experience is helpful.

hours.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to [e-mail] learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.

Skills and Requirements

2-3 years experience min

Advanced Microsoft Excel skills (Pivot tables, Vloppkups, complex formulas, large data sets)

Ability to parse through large data sets to find and correct issues

Ability to thrive in a fast paced environment Some exposure to SQL (basic querying), VBA/macros (automation)

Bachelor's Degree in Supply Chain, Business, Economics or a related analytical field