Data Analyst (SQL required)

Target

Seattle (WA)

On-site

USD 90,000 - 130,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

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

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

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

All qualified applicants will receive consideration for employment without regard to race, color, national origin, age, ancestry, religion, sex, sexual orientation, gender identity, gender expression, marital status, disability, medical condition, genetic information, pregnancy, or military or veteran status. We consider all qualified applicants, including those with criminal histories, in a manner consistent with state and local laws, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Logistics Data Analyst: Freight Cost Strategy & Insights
Logistics Data Analyst: Freight Cost Strategy & Insights

Target • Seattle (WA)

On-site
USD 90,000 - 130,000
Transportation Analyst
Transportation Analyst

Granules Pharmaceuticals, Inc. • Suffolk (VA)

On-site
USD 60,000 - 70,000
Import And Export Analyst
Import And Export Analyst

Celestica • Fort Worth (TX)

On-site
USD 70,000 - 90,000
Transportation Analyst
Transportation Analyst

UFP Industries, Inc. • Grand Rapids (MI)

On-site
USD 60,000 - 90,000
Logistics Billing Analyst
Logistics Billing Analyst

cyberThink • San Diego (CA)

On-site
USD 55,000 - 75,000
AR/Billing Analyst
AR/Billing Analyst

Ultimate Staffing • Plano (TX)

On-site
USD 28,000 - 40,000
Processing Analyst
Processing Analyst

Transportation Insight • Hickory (NC)

On-site
USD 48,000 - 72,000
Transportation Analyst
Transportation Analyst

UFP Industries, Inc • Grand Rapids Charter Township (MI)

On-site
USD 60,000 - 90,000
Logistics finance
Logistics finance

Ultimate Staffing • Hazleton

On-site
USD 50,000 - 70,000
Sr. Logistics Analyst
Sr. Logistics Analyst

Dairy Farmers of America • Kansas City (KS)

On-site
USD 85,000 - 90,000