Dispatch Coordinator

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