Senior Auto Catalog Analyst - Data, SQL & Automation

LKQ Corporation; Nashville (TN); On-site; USD 65,000 - 90,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 Corporation is seeking motivated individuals to join our team in Nashville to manage and improve part cataloging, ensuring accurate data for daily operations. Essential duties include collaborating with data partners, researching vehicle attributes, creating new part records from VIN decoding and ACES data, and maintaining vendor relationships.

The role requires strong Excel and SQL skills, data analytics ability, and readiness to mentor analysts while pursuing automation to save time and

Qualifications

• Bachelor’s degree or equivalent experience.
• 3+ years in automotive aftermarket and/or salvage industries.
• Advanced Excel skills (pivot tables, VLOOKUP/XLOOKUP, formulas).
• SQL knowledge including joins and table creation.
• Data analytics skills for reporting and decisions.

Responsibilities

• Process and validate information from outside data partners.
• Research part attributes (year, make, model, submodel).
• Create new part application records from multiple sources.
• Maintain vendor relationships to ensure data quality.
• Submit data correction requests to partners and track resolutions.
• Document Interchange Contribution, OE numbers, and ACES conflicts.
• Train Automotive Application Analysts on LKQ systems.
• Develop testing methodologies for records and implement corrections.
• Suggest new models for in-depth research based on demand.
• Manage Inventory Resolution projects and reporting.
• Use Excel for pivot tables and advanced functions to streamline tasks.
• Write SQL queries to extract, analyze, and manage data.
• Explore automation opportunities to improve cataloging accuracy.

Skills

Data analytics

Attention to detail

Communication

Education

Bachelor’s degree or equivalent experience

Tools

Excel

SQL

ACES data standards

Hollander interchange

Mitchell RepairMate

Job description

LKQ Corporation is seeking motivated individuals to join our team in Nashville to manage and improve part cataloging, ensuring accurate data for daily operations. Essential duties include collaborating with data partners, researching vehicle attributes, creating new part records from VIN decoding and ACES data, and maintaining vendor relationships.

The role requires strong Excel and SQL skills, data analytics ability, and readiness to mentor analysts while pursuing automation to save time and