Automotive Catalog Data Analyst — SQL & Excel Pro

LKQ Corp.; Nashville, Northern (TN, KY); Hybrid; USD 70,000 - 95,000; Full time

Benefits offered by this job

Health/Dental/Vision Insurance

Paid Time Off

401k with Generous Company Match

Company Paid Life Insurance and Long‑%

Short-Term Disability

Employee Assistance Program

Tuition Reimbursement

Employee Discounts

Job summary

LKQ Corp. is seeking an Automotive Applications Analyst to support cataloging and data accuracy across LKQ systems. You will process partner data, research vehicle attributes, and create new part records from VIN decoding and ACES sources.

Ideal candidates have 3+ years in automotive aftermarket, strong Excel and SQL skills, and experience with data analytics to drive process improvements. This full-time role offers growth in a global LKQ environment.

Qualifications

• Bachelor’s degree or equivalent experience is required.
• 3+ years of related experience in automotive aftermarket or salvage industries.
• Intermediate Excel skills with pivot tables, VLOOKUP, XLOOKUP and advanced formulas.
• SQL knowledge: creating tables, joins, and data analysis.

Responsibilities

• Process and validate data from outside data partners.
• Research part application information by year, make, model and attributes.
• Create new part application records from VIN decoding, ACES, salvage, or aftermarket sources.
• Manage vendor relationships to maintain favorable status.
• Create data correction requests and track resolutions.
• Document Interchange Contrib, OE Numbers, and ACES data conflicts and resolutions.
• Train Automotive Application Analysts on LKQ systems and tools.
• Develop testing methodologies for existing records and apply corrections.
• Identify models for in-depth research based on demand and external data.
• Manage Inventory Resolution projects.
• Use Excel for data manipulation, pivots, VLOOKUP/XLOOKUP, and advanced formulas.
• Write SQL queries to extract, analyze, and manage data.
• Explore automation opportunities leveraging AI where applicable.
• Assume other duties as assigned.

Skills

Excel

SQL

Data analytics

PowerPoint

Education

Bachelor's degree or equivalent experience

Tools

Hollander interchange

Mitchell RepairMate

ACES information standards

Job description

LKQ Corp. is seeking an Automotive Applications Analyst to support cataloging and data accuracy across LKQ systems. You will process partner data, research vehicle attributes, and create new part records from VIN decoding and ACES sources.

Ideal candidates have 3+ years in automotive aftermarket, strong Excel and SQL skills, and experience with data analytics to drive process improvements. This full-time role offers growth in a global LKQ environment.