Senior Automotive Catalog Data Analyst — Excel & SQL Expert

Keystone Automotive Industries, Inc.; Nashville (TN); On-site; USD 70,000 - 100,000; Full time

Benefits offered by this job

Health insurance

PTO

401k match

Life insurance

Long-term disability

Short-term disability

Employee Assistance Program

Tuition reimbursement

Employee discounts

Job summary

LKQ Corporation is seeking a data-focused professional to process and validate external partner information, build reliable data records, and develop actionable reports. You will write SQL queries, utilize Excel, and mentor junior analysts while driving process improvements across automotive data cataloging.

This is a hands-on role in a dynamic data analytics team. The ideal candidate has 3+ years of automotive data experience, strong SQL and Excel capabilities, and a passion for data-driven

Qualifications

• Bachelor’s degree or equivalent experience.
• 3+ years of related data analytics experience.
• Experience in automotive aftermarket/salvage industries preferred.
• Intermediate Excel skills: Pivot tables, VLOOKUP, XLOOKUP and advanced formulas.
• SQL knowledge: creating tables, joins, efficient queries.

Responsibilities

• Process and validate data from outside partners.
• Create and submit data correction requests to vendors.
• Write SQL queries to extract, analyze, and manage data.
• Develop reports and actionable recommendations from data insights.
• Train and mentor analysts in LKQ systems and tools.
• Explore automation opportunities to improve cataloging accuracy.

Skills

SQL queries

Excel (Pivot tables)

Data analytics

Data manipulation

Education

Bachelor’s degree or equivalent

Tools

SQL

ACeS database

Hollander interchange

Mitchell Repairmate

Job description

LKQ Corporation is seeking a data-focused professional to process and validate external partner information, build reliable data records, and develop actionable reports. You will write SQL queries, utilize Excel, and mentor junior analysts while driving process improvements across automotive data cataloging.

This is a hands-on role in a dynamic data analytics team. The ideal candidate has 3+ years of automotive data experience, strong SQL and Excel capabilities, and a passion for data-driven