Freight Audit Team Support / Team Lead Support FP&A team through various department objectives
Provide insight as the subject matter expert on TMS capabilities and functionality
Monitor and help resolve ongoing issues/escalations in the day-to-day management of freight payment
Transportation Systems & Special Projects Support Support transportation department-wide special objectives and projects
Utilize knowledge of TMS, intra-department workflows, and of the overall business to support various special projects and analysis requests
TMS Admin Responsibilities
User Management ensure a smooth and satisfactory experience. Different types of users, each with their own set of unique Roles (MercuryGate):
Admin (super user)
Execution Team
FP&A (AFS) Team
Customer Care
Carrier
Vendor
USABB DC
Reporting
User Onboarding create user credentials in one of categories above. Help them get started by providing clear instructions and documentation. Also in early phases, guide them through the process to ensure they understand how to use the product effectively.
User Support address user concerns promptly. Provide proactive solutions where users can solve independently in future instances.
Protection of Data familiarize yourself with all users and their roles. Ensure the security and privacy of carrier contracted rates and agreements. Keep track of employees moving to other roles or separating with the company.
Rating, Routing, & Optimization allow execution team to easily plan, execute, and optimize the movement of freight.
Carrier Selection & Rate Management keep LTL and TL contracts up to date with Sourcing Teams agreement.
Routing Guide- point OD Pairs toward the contracted/compliant carriers per the Sourcing Teams Routing Guide.
Optimization ensure vendors and DCs are consolidating orders on the front end. Own Edges Mojo (MercuryGate) and e2s optimization process.
Reporting understand series of events from shipment creation to invoice to provide knowledge to different stakeholders within the company. Know all reportable aspects of TMS (e.g. within the UI or in Edge) to give them the tools they need to build out different KPIs.
Support solve any misalignment where carrier and/or rate assignment are not meeting business expectations.
Supplier Management own the vendor relationship from TMS onboarding to long term support.
Service Level Agreements - Understand the vendors SLA. Confirm they are collected in SAP.
Vendor Onboarding - Create vendor locations, users, and customized configuration in both TMSs. See it all the way through until vendor is comfortable using the product.
Supplier Onboarding team collaborate with this team before and after onboarding
Issue Resolution solve any issues where product is not meeting vendors expectations. For example vendor marked orders RTS before 11am local yet they are yet to receive shipment confirmation because of unknown disconnect.
Vendor Compliance & Audit understand how to run a vendor compliance report using UI and Edge.
File Management manage the inbound and outbound files going in and out of MercuryGate via WinSCP using MGs Host credentials.
File Archival and Retention Understand the different predesignated folders and their content.
File Format and Protocol Management monitor all EDI210s failing to be imported via customized report in UI.
Data Validation and Error Handing Validate inbound files for accuracy, completeness, and conformity to the predefined standards of the business. For example if a EDI214 is not matching to BOL to trigger it to in-transit or a EDI210 invoice is not matching to a executed STO or LH. Identify where error is in and professionally communicate to carrier the solution. Understand how to find file, RCA of file, share solution with carrier.
Exception Handling and Resolution: Identify and resolve exceptions or discrepancies related to inbound or outbound files via Testing. Collaborate with relevant parties to participate in test to best replicate live scenario.
FP&A + Invoice Extract to SAP S/4 own the bridge between MercuryGate and SAP S/4.
Product Capability - Understand the limitations and flexibility of MercuryGates GL Coding capabilities to closest meet business expectations.
Data Mapping and Integration for every shipment, there needs to be a clear path mapped from:
MercuryGate Location Code
to
MercuryGate Code Table
to
SAP ECC
to
SAP Cost Center
Extracting Invoice Data manage the daily automated invoice extract setup which is designed and known to prevent duplicate payment errors in SAP.
Error Handling and Exception Resolution In SAP, setup a cadence to regularly check invoices failing to extract.
Build positive relationship with TMS provider
Communicate and collaborate establish an open and regular communication with your TMS provider. Make sure they understand what differentiates business requirements v. other clients. Help them understand what you are trying to accomplish, current results v. expected results through screenshots and replicating scenario.
Issue and Escalation Management utilize the support ticket platforms if youre unable to solve issues independently.
Systems updates and Enhancements identify opportunities for improvements in business processes. Be the bridge between business expectations and product solutions.
DAT Freight & Analytics - manage the transfer of transportation history to 3rd party DAT.
Create a monthly cadence of dropping files into a hosted SFTP.
2 files are dropped into shared folder:
Shipment history and costs are pulled from UI.
Freight Classes are pulled from Edge
Analyst Responsibilities
Position Purpose
Responsible for managing, defining, and executing logistics/transportation strategy in a manner that supports company and customer goals. Continuously analyze data and processes to measure and improve performance and productivity.
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.
Job Type: Contract
Pay: $22.85 - $40.00 per hour
Schedule:
Experience:
- Freight: 4 years (Preferred)
Ability to Commute:
- Atlanta, GA 30339 (Required)
Ability to Relocate:
- Atlanta, GA 30339: Relocate before starting work (Required)
Work Location: In person