Data Analyst (SQL required)

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

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.