Data Analyst; SQL

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.

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