Previous Job
Logistics Analyst
Ref No.: 18-13135
Location: Marlboro, Massachusetts
Position Type:Contract
Experience Level: 2 Years
Job title: Logistics Analyst
Location: Marlboro, MA
Duration: 6+ months

- Candidates must have strong background in Excel (be able to do V-Lookups)
- Should have 2+ years of analysis experience
- Candidates with Logistics/Distribution experience is a plus

Logistics Rate Analyst will primarily support Contract Management team working with sensitive & confidential data as Global Sourcing event results are awarded to 70+ domestics transportation providers. Strong excel skills and attention to detail are necessary.

Training and reference documents will be supplied to ensure analysts can properly screen incoming data and prepare Rate Exhibits for eventual publication and signature by Client and each of its transportation providers.
Thousands of unique business lane awards with corresponding pricing for each provider will be presented in a specific format to be used to prepare rate exhibits, as part of master contracts, to supersede prior versions.
New pricing rules & accessorial fees will be presented to accompany the rate data and will need to be incorporated into the publication document.
Analysts will ensure duplicate lots for same lane are merged, and will identify/flag any missing data fields inserting information as needed paying particular attention to zip codes/zones & campus location definitions, etc.
Analysts will prepare extract files for screening by Client management team and provider pricing analyst teams prior to publication.
Should anomalies be discovered, Rate Analysts will utilize vlookup to isolate lanes requiring review and communicate with management team and Global Sourcing for resolution.
Any changes as a result of post-event negotiations will then be posted to the WIP document for another review by parties.
Final version of Rate Exhibit documents will be uploaded to DocuSign to collect signatures and completed documents will be uploaded to GPO SharePoint site for upload to Oracle Contract Repository.
Other duties may include but are not limited to providing support to Rate and Transportation Management System associates in day to day reporting and retention functions.