Sr. Analyst, Data Logistics

Position: Sr. Analyst, Data Logistics

Location: Fountain Valley, CA.

Tier 1 is 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?

Tomorrow's most advanced automotive technology is being envisioned today at Tier 1. A subsidiary of Tier 1, we are a top leading automotive parts supplier. Tier 1 provides after-sales service parts support for OEM's. In addition to the distribution of genuine service parts, the Tier 1 Accessories division develops accessories for OEM's - which are installed on new vehicles in the United States and Canada.

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

Schedule:

• Monday

• Friday

Education Requirements:

• Bachelor's Degree or equivalent experience.

Experience Requirements:

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

Would you be a good fit for this exciting career advancement opportunity? Click 'Apply Now' and a dedicated recruiter will be contacting you soon!

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.