Courier Analyst

Scope/ Overview of Position:
Launched in 1979 as a wholesale and distribution company, SDR has transformed itself into a leader in the North American 3PL market, specializing in the fashion, footwear, accessories, and related soft goods fulfillment market niche. Well known within the industry for its attention to detail and the constant strive for perfection, SDR’s success has been supported by a top-notch Warehouse Management system (Manhattan Scale) with RF inventory control and a fully compliant EDI communication solution.

SDR hosts a clientele base in excess of 100 customers with over 1000 vendors. Our footprint is in excess of 2 million square feet throughout North America

As part of the Transportation team, the Courier Analyst is responsible for maintaining rate charts for Courier costs, providing courier quotes to customers, analyzing and preparing data files by customer for all courier services used. This individual will also develop and propose improvements on set-up procedures.

Key Responsibilities & Duties:

- Work closely with IT, Operations and Finance departments
- Prepare rate customer courier charts.
- Monitor annual increases of courier rates and update the customer courier rates schedules accordingly
- Prepare proposals for customer rates
- Upload data courier files to the accounting system or in house developed portals
- Reconcile courier invoices to identify which customers have used the services
- Prepare detailed excel files per customer, per courier, per accounting period based on specific customer agreements and forward within the finance team for billing
- Identify any operational issues in connection with shipping and receiving of courier services and address them with the operational team
- Reconcile margin sheets per courier per accounting period
- Respond to customers enquiries regarding detailed information provided and address any questions directly to the courier or internally.
- Investigate ad hoc courier bills
- Verify company cost to the rates provided by couriers
- Dispute incorrect courier invoices
- Any other ad-hoc analysis and duties as required
- Propose improvements on set-up procedures

Qualifications, Education and Experience Required:

- College Education
- 1-2 years of previous work experience with large excel files and analysis
- Advanced excel knowledge
- Ability to build excel templates with formulas and macros
- Strong analytical thinking
- Advanced Organizational skills
- Extremely detail-oriented
- Strong MS Office
- Aptitude to learn
- Ability to work independently, solve issues and be a strong system-oriented person