Senior Logistics Analyst

Job Description

User Management -- ensure a smooth and satisfactory experience. Different types of users, each with their own set of unique Roles (MercuryGate):

1. Admin (super user)

2. Execution Team

3. FP&A (AFS) Team

4. Customer Care

5. Carrier

6. Vendor

7. USABB DC

8. 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 Team's agreement.

* Routing Guide- point OD Pairs toward the contracted/compliant carriers per the Sourcing Team's Routing Guide.

* Optimization -- ensure vendors and DCs are consolidating orders on the front end. Own Edge's Mojo (MercuryGate) and e2's 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 vendor's SLA. Confirm they are collect 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 vendor's 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 MG's 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 MercuryGate's GL Coding capabilities to closest meet business expectations.

* Data Mapping and Integration -- for every shipment, there needs to be a clear path mapped from:

o MercuryGate Location Code

to

o MercuryGate Code Table

to

o SAP ECC

to

o 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 HD Supply's 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 you're 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 HD Supply hosted SFTP.

* 2 files are dropped into shared folder:

o Shipment history and costs are pulled from UI.

o 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.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to ~~~ .

To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: ~~~/ .

Skills and Requirements

E2 Open & MercuryGate

2 years of experience null

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion,sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military oruniformed service member status, or any other status or characteristic protected by applicable laws, regulations, andordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to ~~~.