Sr. Logistics Analyst

Title: Sr. Logistics Analyst

Shift: Hybrid - M,T,W in office TH,F remote

Main initiative:

• To utilize the Transportation management system to create and design internal reporting tool that allows insight into the freight payable data to drive actions.
• Example: variance in system rates and invoice rates from end client, billing accuracy, shipping deliverance
• Would like to see experience creating a reporting structure from the ground up or automating a previous reporting tool that was not useful

Major Tasks, Responsibilities, and Key Accountabilities

• Serves as a resource to assigned client in area of expertise and supports field personnel, Distribution Centers, Sales, Supply Chain, and other departments in transportation/logistics areas.
• Gathers and compiles raw data; conducts research for industry trends and benchmarks; and normalizes data to be incorporated into a centralized data format.
• Prepares spreadsheets for data analysis; prepare reports with charts and graphs, mailing lists, maps, and ad hoc requests.
• Defines data definitions and documents data limitations.
• Develops business tools and solutions to improve logistics processes.
• Develops cost estimates and forecasts. Creates and maintains costing models.
• Informs executive management on all pertinent issues concerning the supply chain process.
• Ensures the structure of all logistics and delivery programs meet Department of Transportation (DOT) regulations.

Must haves:

• Someone who has learned multiple former TMS’s (Transportation management systems)
• Extremely competent excel skills
• Need to be able to work effectively with pivot tables / Vlookups , index match, xlookup
• 3-5 years of experience

Plusses:

• Mercury gate and E2 open (Transportation management systems)
• Snowflake
• Tableau or Power BI
• SQL – highly preferred
• python

$35hr to $45/hr.

Exact compensation may vary based on several factors, including skills, experience, and education.

Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching.