Advantage Technical
Position
Analyst II, Transportation - Freight Payments Location: Fountain Valley, CA Overview
The Analyst II, Transportation is responsible for the administration of weekly freight payment processing for the Logistics department related to freight costs for inbound and outbound shipments through a freight payment vendor and Access database functions in the department. Responsibilities The Analyst II, Transportation administers weekly freight payment processing for the Logistics department related to freight costs for inbound & outbound shipments through the freight payment vendor and Access database functions. Research and investigate all payment variances in WebRes data provided by the Tier 1 Freight Payment Vendor VTM. Pending lines of WebRes should not exceed 300. Audit and report the expense of international and domestic accessorial costs through weekly and monthly reporting as required. Process monthly Inbound Landed Cost (LDC) reports and monthly LDC rate. Serve as SME on department freight payment issues and provide AD Hoc freight payment reporting. Backup Department Freight Transportation analyst on FTL truck requests for Tier 1 PDCs.
Qualifications
Bachelor's Degree or equivalent experience. Minimum of five years' experience in related logistics activities such as freight rates, freight bill auditing and other sea/air/land carrier related activities. Minimum of five years analysis experience preferably within the automotive industry in the area of traffic/logistics/parts warehouse/accounting. 4-5 years Operations - Logistics. Use of intermediate software packages (word processing, spreadsheets). Able to solve practical problems/deal with a variety of concrete variables with limited standardization. Use of intermediate computer operations (programming in relational databases).
Key Accountabilities
Run weekly Freight Payment files in customized process for Tier 1 Transportation department. Create weekly check requests for Inbound and Outbound freight bills for Finance. Advise freight payment vendor of any discrepancies in the weekly files for fixes. Run monthly freight payment reports for Tier 1 distribution. Update monthly LDC rate in Amos for Tier 1 Finance. Pull and analyze freight payment data as required through Access database or SQL queries. Assign GL accounts to specific transactions in freight payment process. Backup Transportation Analyst with FTL truckload scheduling when needed. Work to improve internal data processes as needed. Provide ad hoc reports and cost studies as required by management. Other duties as assigned.
Key Performance Indicators
Download and analyze weekly VTM freight payment data to create weekly check requests for all Inbound and Outbound department freight bills. 30% Investigate freight issues with all Inbound and Outbound carriers; research past due situations for Tier 1 carriers; research and process variances on WebRes; run SQL and Access queries. 30% Administer the monthly landed cost reports and daily MAL Inbound freight carrier reporting; provide ad hoc reporting and financial issue support. 20% Provide reports for international and domestic accessorial fees weekly, monthly or as needed; run SQL queries. 10% Complete Tier 1 Academy training requirements (12 hours yearly). 10%
Compensation and Benefits
The base pay range above represents the low and high end of the base compensation range we reasonably expect to pay for this position. Actual base compensation will vary and may be above or below the range based on factors including location, experience and performance. This job posting is not a promise of any specific pay for any specific employee. The range listed is a component of the total compensation package. Benefits include medical, dental and vision plans, pre-tax savings plans, parking and commuter plans, retirement savings, employee assistance program, pet insurance, paid holidays, and possibly short-term incentives and paid time off. EEO and Privacy
Advantage Technical is committed to equal employment opportunity for all persons regardless of race, color, religion, sex, sexual orientation, gender identity, age, marital status, national origin, pregnancy, disability, veteran status or other non-merit factors. Reasonable accommodations are available during the application and employment process. Advantage Technical is an E-Verify employer. Privacy notices and policies apply to candidates and employees/contractors. After you have applied, you may be invited to use the Staffmark Group WorkNOW app for real-time job offers and additional opportunities. Details available in the app stores. #J-18808-Ljbffr
Analyst II, Transportation - Freight Payments Location: Fountain Valley, CA Overview
The Analyst II, Transportation is responsible for the administration of weekly freight payment processing for the Logistics department related to freight costs for inbound and outbound shipments through a freight payment vendor and Access database functions in the department. Responsibilities The Analyst II, Transportation administers weekly freight payment processing for the Logistics department related to freight costs for inbound & outbound shipments through the freight payment vendor and Access database functions. Research and investigate all payment variances in WebRes data provided by the Tier 1 Freight Payment Vendor VTM. Pending lines of WebRes should not exceed 300. Audit and report the expense of international and domestic accessorial costs through weekly and monthly reporting as required. Process monthly Inbound Landed Cost (LDC) reports and monthly LDC rate. Serve as SME on department freight payment issues and provide AD Hoc freight payment reporting. Backup Department Freight Transportation analyst on FTL truck requests for Tier 1 PDCs.
Qualifications
Bachelor's Degree or equivalent experience. Minimum of five years' experience in related logistics activities such as freight rates, freight bill auditing and other sea/air/land carrier related activities. Minimum of five years analysis experience preferably within the automotive industry in the area of traffic/logistics/parts warehouse/accounting. 4-5 years Operations - Logistics. Use of intermediate software packages (word processing, spreadsheets). Able to solve practical problems/deal with a variety of concrete variables with limited standardization. Use of intermediate computer operations (programming in relational databases).
Key Accountabilities
Run weekly Freight Payment files in customized process for Tier 1 Transportation department. Create weekly check requests for Inbound and Outbound freight bills for Finance. Advise freight payment vendor of any discrepancies in the weekly files for fixes. Run monthly freight payment reports for Tier 1 distribution. Update monthly LDC rate in Amos for Tier 1 Finance. Pull and analyze freight payment data as required through Access database or SQL queries. Assign GL accounts to specific transactions in freight payment process. Backup Transportation Analyst with FTL truckload scheduling when needed. Work to improve internal data processes as needed. Provide ad hoc reports and cost studies as required by management. Other duties as assigned.
Key Performance Indicators
Download and analyze weekly VTM freight payment data to create weekly check requests for all Inbound and Outbound department freight bills. 30% Investigate freight issues with all Inbound and Outbound carriers; research past due situations for Tier 1 carriers; research and process variances on WebRes; run SQL and Access queries. 30% Administer the monthly landed cost reports and daily MAL Inbound freight carrier reporting; provide ad hoc reporting and financial issue support. 20% Provide reports for international and domestic accessorial fees weekly, monthly or as needed; run SQL queries. 10% Complete Tier 1 Academy training requirements (12 hours yearly). 10%
Compensation and Benefits
The base pay range above represents the low and high end of the base compensation range we reasonably expect to pay for this position. Actual base compensation will vary and may be above or below the range based on factors including location, experience and performance. This job posting is not a promise of any specific pay for any specific employee. The range listed is a component of the total compensation package. Benefits include medical, dental and vision plans, pre-tax savings plans, parking and commuter plans, retirement savings, employee assistance program, pet insurance, paid holidays, and possibly short-term incentives and paid time off. EEO and Privacy
Advantage Technical is committed to equal employment opportunity for all persons regardless of race, color, religion, sex, sexual orientation, gender identity, age, marital status, national origin, pregnancy, disability, veteran status or other non-merit factors. Reasonable accommodations are available during the application and employment process. Advantage Technical is an E-Verify employer. Privacy notices and policies apply to candidates and employees/contractors. After you have applied, you may be invited to use the Staffmark Group WorkNOW app for real-time job offers and additional opportunities. Details available in the app stores. #J-18808-Ljbffr