Logistics Data Analyst: Freight Cost Strategy & Insights

Target; Seattle (WA); On-site; USD 90,000 - 130,000; Full time

Job summary

Target seeks a data analyst to administer logistics data processing for freight costs on inbound and outbound shipments. You will oversee Access database functions, gather and analyze shipment history, and report on costs around $80 million annually.

You will audit transportation expenses versus budgets, using SQL, QMF, and MS Office tools to explain cost trends. Strong communication and data-import skills are essential for weekly and monthly reporting.

Qualifications

• Minimum of 5 years of experience in analysis.
• Experience in related logistics (freight rates, freight bill auditing) or automotive industry is a plus.
• WinSQL experience is highly desirable.
• Strong working knowledge of SQL and QMF (query management facility).
• Advanced skills in MS Office: Excel, Word, and PowerPoint.
• Experience importing data files from mainframes and test formats to MS Excel/Access is ideal but not required.
• Strong oral and written communication skills.

Responsibilities

• Administer data processing for the Logistics department related to freight costs for Inbound & Outbound shipments.
• Provide all RFP and data through gathering and analyzing shipment history and freight costs of approximately $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.

Skills

Strong analytical skills

Oral and written communication

Data analysis

Logistics domain knowledge

Tools

SQL

QMF

WinSQL

MS Office Suite

Job description

Target seeks a data analyst to administer logistics data processing for freight costs on inbound and outbound shipments. You will oversee Access database functions, gather and analyze shipment history, and report on costs around $80 million annually.

You will audit transportation expenses versus budgets, using SQL, QMF, and MS Office tools to explain cost trends. Strong communication and data-import skills are essential for weekly and monthly reporting.