Job Description

POSITION SUMMARY

Manage dispatch operations through advanced spreadsheet analysis and reporting, ensuring accurate order processing, carrier coordination, and delivery tracking for promotional merchandise fulfillment.

KEY RESPONSIBILITIESData Management

Maintain comprehensive dispatch tracking spreadsheets Process daily order data from multiple channels Generate shipping labels and documentation Update delivery status across all orders

Reporting and Analytics

Create daily, weekly, and monthly dispatch reports Track carrier performance metrics and costs Generate customer delivery confirmations Maintain accurate inventory dispatch records

Communication

Coordinate with courier partners for pickup scheduling Provide shipping updates to customers and sales team Resolve delivery exceptions and address discrepancies Communicate delays or issues to relevant stakeholders

Process Optimization

Identify inefficiencies in current dispatch workflows Suggest improvements for cost reduction and time optimization Maintain organized documentation systems Support implementation of process enhancements

REQUIRED QUALIFICATIONSEducation

Bachelor's degree in any field

Mandatory:

Microsoft Excel certification or Google Sheets certification Additional certifications in data analysis tools preferred

Technical Skills

Expert-level Excel/Google Sheets proficiency

(pivot tables, VLOOKUP, macros, conditional formatting) Advanced formula creation and data manipulation Experience with data visualization and dashboard creation Basic understanding of logistics and shipping processes

Communication Skills

Excellent written and verbal English communication Professional email correspondence abilities Clear reporting and presentation skills Customer service orientation

CORE COMPETENCIESAnalytical Skills

Data accuracy and attention to detail Pattern recognition in shipping data Problem-solving through data analysis Process documentation and standardization

Technical Proficiency

Advanced spreadsheet functions and formulas Data import/export capabilities Basic understanding of API integrations Learning agility for new software systems

Organizational Skills

Multi-task management and prioritization Systematic approach to data organization Meeting deadlines under pressure Maintaining accurate records

PERFORMANCE METRICSAccuracy Standards

Data entry accuracy: >99% Report generation timeliness: 100% Customer communication response: <4 hours Daily dispatch processing: 100% completion

Efficiency Targets

Order processing speed: 50+ orders per hour Report turnaround time: Same day delivery Exception resolution: <24 hours Data reconciliation accuracy: >98%

WORKING CONDITIONS

Standard office environment Computer-based work for 8 hours daily Flexible hours during peak seasons Minimal physical requirements
Job Types: Full-time, Fresher

Pay: ₹18,000.00 - ₹25,000.00 per month

Application Question(s):

Do you have experience in Advance Excel?
Work Location: In person