Jr. Stock & Logistics Executive

Job Title: Stock & Logistics Executive

Department: Stock & Logistics

Location: Shahpur Jat, New Delhi

Working Hours: 10:00 AM to 8 PM

Working Days: Monday to Saturday

• Job ResponsibilitiesMaintain physical stock as well as computer-based stock records.
• Enter and update all stock-related data in Excel and company software.
• Maintain complete records of material received, issued, dispatched, returned and available in stock.
• Prepare and maintain stock sheets and daily stock records.
• Regularly check physical stock with system/Excel records and report any mismatch.
• Maintain records of demo material and manage demo material movement.
• Prepare demo material sheets and record:
• Material issued for demo
• Client/site details
• Material returned
• Pending material
• Material condition
• Material available in stock
• Coordinate with the team for demo material packing, dispatch and return.
• Maintain proper records for courier, transport and material dispatches.
• Assist in packing material and ensure material is properly packed before dispatch.
• Coordinate for loading and unloading of material when required.
• Maintain records of RMA / faulty / returned material and coordinate with the concerned team/vendor.
• Maintain AMC material records and support the AMC team with stock and material information.
• Handle vendor-related stock and material coordination, including material receipt, pending material, replacement and return.
• Handle day-to-day emails related to stock, logistics, demo material, RMA, AMC and vendors.
• Prepare Excel sheets, trackers and reports required by management.
• Maintain proper documentation of all stock and logistics activities.
• Keep stock area organised and ensure proper identification and storage of material.
• Support regular physical stock verification and stock counting.
• Coordinate with Sales, Service, Accounts, Purchase and Management for material requirements.
• Perform other stock, logistics and computer-related work assigned by management.

Computer & Excel Skills – MandatoryThe candidate should be comfortable doing complete computer-based work related to the Stock & Logistics Department.

Advanced Excel knowledge is mandatory, including:

• VLOOKUP / XLOOKUP
• IF and other basic formulas
• Sorting & Filtering
• Pivot Tables
• Data validation
• Conditional formatting
• Excel reports and trackers
• Stock reconciliation
• Data cleaning and updating
• Preparing professional Excel sheets