Merchandise Assistant

Jobtailor; Milwaukee (WI); On-site; USD 42,000 - 64,000; Full time

Job summary

Jobtailor is seeking a detail-oriented inventory coordination professional to support buyers with administrative tasks and data analysis. The role focuses on maintaining accurate spreadsheets, monitoring metrics, and coordinating with stores, warehouses, buyers, and vendors to optimize inventory turn and sell-through.

The candidate will thrive in a fast-paced team environment, bringing strong Excel skills, attention to detail, and effective communication to ensure seamless operations across the

Qualifications

• 2 years’ experience in the same or similar role.
• Bachelor’s degree in Business preferred.
• Strong analytical skills and attention to detail.
• Strong problem solving skills.
• Ability to manage multiple projects efficiently.
• Effective communicator with store personnel and vendors.

Responsibilities

• Aiding the Buyer by performing administrative and problem solving duties.
• Help buyers establish, monitor, maintain, and exceed predetermined metrics (product sell thru, inventory turn, carryover from season-to-season).
• Create and maintain spread sheets supporting these activities.
• Liaise for store, warehouse, buyers, and vendors.
• Respond to email and phone inquiries.
• Proactively communicate issues and appropriate solutions with internal and external partners.
• Create and execute solutions for receiving discrepancies (overage, shortage, incorrect merchandise).
• Creation of transfer orders for distribution by the warehouse.
• Review and adjust auto min max quantities to ensure in stock and inventory performance.
• Transfers between stores.
• Help to maximize inventory turn through knowledge of seasons and various product lines.
• Assist with establishing internal controls for stores (adherence to inventory policies, item counts as needed).
• Creation and maintenance of Styles/SKUs based on buyer spreadsheets.
• Purchase order creation, maintenance and tracking.
• Price adjustments including temporary and permanent price changes based on buyer direction, advertising and seasonal requirements.
• Assist with advertising processes including form creation, ad proofing and gathering of sample merchandise.

Skills

Excel proficiency

Analytical skills

Problem solving

Inventory management

Purchase order creation

Education

Bachelor's degree in Business

Tools

Microsoft Excel

Job description

• Aiding the Buyer by performing administrative and problem solving duties.
• Help buyers establish, monitor, maintain, and exceed predetermined metrics (product sell thru, inventory turn, carryover from season-to-season).
• Create and maintain spread sheets supporting these activities.
• Liaise for store, warehouse, buyers, and vendors.
• Respond to email and phone inquiries.
• Proactively communicate issues and appropriate solutions with internal and external partners.
• Create and execute solutions for receiving discrepancies (overage, shortage, incorrect merchandise).
• Creation of transfer orders for distribution by the warehouse.
• Review and adjust auto min max quantities to ensure in stock and inventory performance.
• Transfers between stores.
• Help to maximize inventory turn through knowledge of seasons and various product lines.
• Assist with establishing internal controls for stores (adherence to inventory policies, item counts as needed).
• Creation and maintenance of Styles/SKUs based on buyer spreadsheets.
• Purchase order creation, maintenance and tracking.
• Price adjustments including temporary and permanent price changes based on buyer direction, advertising and seasonal requirements.
• Assist with advertising processes including form creation, ad proofing and gathering of sample merchandise.

Requirements

• Requires an understanding of Microsoft Office; strong proficiency in Excel.
• Strong analytical skills and attention to detail.
• Strong problem solving skills.
• Ability to manage multiple projects efficiently.
• Ability to work in a team environment as well as individually under minimal supervision.
• Effective communicator with the ability to build strong relationships with store personnel and vendors.
• Bachelor’s degree in Business or equivalent preferred.
• 2 years’ experience in the same or similar role.

Core Competencies

Demonstrates strong analytical skills and problem-solving abilities to support buyers in inventory management and performance metrics. Proficient in Microsoft Excel for data analysis and reporting, with experience in purchase order management and vendor relations.

Highest-signal resume keywords

• Microsoft Excel Proficiency
• Analytical Skills
• Problem Solving
• Inventory Management
• Purchase Order Creation

ATS Optimization Keywords

Hard Skills

• Data Analysis
• Spreadsheet Management
• Inventory Turn Optimization
• Price Adjustment Management
• Transfer Order Creation

Soft Skills

• Effective Communication
• Team Collaboration
• Attention to Detail
• Project Management

Certifications & Qualifications

• Bachelor’s Degree in Business

Industry Keywords

• Inventory Policies
• Vendor Relations
• Product Sell Thru
• Seasonal Product Knowledge
• Internal Controls