Senior Data Logistics Analyst

Advantage Technical
$29.00-$44.00
paid time off, paid holidays
United States, California, Fountain Valley
Nov 12, 2024
We are searching for an experienced Sr. Analyst, Data Logistics at our Headquarters facility. We think creatively and keep challenging ourselves to help create a new future and eventually make humankind's dreams a reality. Ready for the challenge? Description: Administer data processing for the Logistics department related to freight costs for Inbound & Outbound shipments through overseeing all Access database functions in the department. Provide all RFP and AMOS data through gathering and analyzing shipment history and freight costs of approx. $80 million+ annually. Audit and report the expense of international and domestic transportation versus budgeted amounts through weekly and monthly reporting. Maintain transportation expense via data obtained from web reporting and query data to explain cost trends. Administer, communicate and prepare Tier 1 freight payment expense reporting for OEM. Monitor service transit times reported from carrier web sites. Manage carrier RFP and vendor RFP specification and processes. Develop and maintain department KPI dashboards. SME on Access database processes and involvement in special projects relating to cost studies as needed by management. Key Accountabilities: Download and analyze Access and Amos data warehouse data for projects and Tier 1 management reporting. - 25% Administer the monthly Tier 1 cost analysis for Tier 1 management review. Provide ad hoc reports and cost studies as needed by management. - 20% Administer Carrier RFP bid processes and routing management summary as requested. Recommend carriers/vendors based on service/cost comparisons. - 20% Create and maintain new and existing Access databases for OEM and OEM data. - 20% Complete Tier 1 Academy training requirements. - 10% Key Performance Indicators: Maintain and create transportation databases as needed and provide analysis of all inbound and outbound freight expense. Audit 3rd party freight payment data for correct modes and GL assignments; Update funding documents from freight payment service web site to Tier 1 internal Access databases for OEM and OEM data. Update weekly/monthly summary of freight cost versus sales for Tier 1 review. Advise freight auditor of weekly files to analyze for possible cost savings. Administer weekly/monthly freight payment reporting, including accruals. Run and distribute monthly OEM and OEM Active Dealer reports. Carlisle subject matter expert - pull and analyze data as required Run Amos data warehouse queries as needed for reporting and special projects Run cost estimate simulations based on sales and purchase projections, including freight cost changes (such as annual increases or new rates) to help determine KPIs and assist in Business Planning. Administer the carrier or vendor RFP process to provide management with cost analysis, transit times and other related RFP data. Recommend carriers/vendors based on service/cost comparisons. Work with Systems Department to improve internal data processes. Act as department subject matter expert for MCloud and new systems designs/implementation, as needed. Provide ad hoc reports and cost studies as needed by management. Required Qualifications: Bachelor's Degree or equivalent experience. 5+ years experience required Minimum of 5 years of experience in related logistics activities such as freight rates, freight bill auditing and other sea/air/land carrier related activities. Minimum of 5 years of analysis experience preferably within the automotive industry in the area of traffic/logistics/parts warehouse and claims. Strong working knowledge of SQL and QMF (query management facility). Advanced skills in MS Office: Excel, Word, and PowerPoint. Advanced skills in MS Access: Ability to create tables, forms, charts, queries, macros and create and maintain new and existing databases as needed. Strong analytical skills. Previous experience with importing data files from mainframes and test formats to MS Excel/Access. Strong oral and written communication skills. 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 various factors including, but not limited to, geographic location, actual experience, and job performance. This job posting is not a promise of any specific pay for any specific employee. The range listed is just one component of the total compensation package for our employees. Based on the details of your position, we provide a variety of benefits to our employees, including medical, dental, and vision plans, pre-tax savings plans, pre-tax parking and commuter plans, supplemental health and welfare plans, a retirement savings plan, an employee assistance program, pet insurance, and paid holidays. Other rewards may include short-term incentives and paid time off. After you have applied, download our Staffmark Group WorkNOW App to receive real-time job offers and apply for additional opportunities. You can download it from the App Store or get it on Google Play. About Advantage Technical With company roots going back over 30 years, Advantage Technical is an engineering and information technology services company and a national leader in the provision of technical resources today. These services include Staff Augmentation, Direct Placement, Project Resourcing and Outsourcing - delivered from 40 key market locations, by over 3500 specialized contractors, to over 500 clients across North America. Advantage Technical is a Best of Staffing Diamond Award winner for both Clients and Talent. For more information about the industries and services offered by Advantage Technical, please visit AdvantageTechnical.com. Advantage Technical is committed to providing equal employment opportunity for all persons regardless of race, color, religion (including religious dress and grooming practices), sex, sexual orientation, gender, gender identity, gender expression, age, marital status, national origin, ancestry, citizenship status, pregnancy, medical condition, genetic information, mental and physical disability, political affiliation, union membership, status as a parent, military or veteran status or other non-merit based factors. We will provide reasonable accommodations throughout the application, interviewing and employment process. If you require a reasonable accommodation, contact your local branch. Advantage Technical is an E-Verify employer. This policy is applicable to all phases of the employment relationship, including hiring, transfers, promotions, training, terminations, working conditions, compensation, benefits, and other terms and conditions of employment. All employees are directed to familiarize themselves with this policy and to act in accordance with it. All decisions with respect to employment matters and other phases of employer-temporary employee relationships will be in keeping with this policy and in accordance with all applicable laws and regulations.