Sr Catalog Analyst

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

Join the LKQ Family! We're looking for motivated individuals to join our team at LKQ Corporation. With opportunities for growth, competitive benefits, and a supportive work environment, LKQ is the place to be.

Perform all cataloging duties, help manage, track, and report on the daily processes and decisions associated with accurate and concise part cataloging.

Essential Job Duties

Work with outside data partners to process and validate their information.

Research part application information based on year, make, model, submodel and other vehicle attributes as needed.

Create new part application records from various sources (VIN decoding, ACES database, salvage part interchange, Aftermarket parts).

Manage a positive business relationship with vendor partners in order to maintain favorable status.

Create and submit data correction requests to vendor partners as needed.

Track and report on data correction request resolutions.

Create and maintain documentation for the various types of Interchange Contribution, OE Number and ACES data conflicts, and the resources used and steps taken to resolve them.

Help train and mentor Automotive Application Analysts in the proper choice and use of LKQ systems and tools.

Develop methodology for and conduct testing on existing application records, then make corrections as necessary.

Suggest new models to be considered for in-depth research projects based on field demand and available research from other sources.

Manage the creation and tracking of Inventory Resolution projects.

Utilize Excel for data manipulation and reporting, including creating pivot tables, VLOOKUP/XLOOKUP, and advanced formulas to streamline tasks and enhance efficiency.

Analyze and utilize data insights to identify trends and support process improvements, including the creation of detailed reports and actionable recommendations.

Write SQL queries to extract, analyze, and manage data effectively, including creating tables, managing data types, and performing joins.

Explore opportunities for automating cataloging processes to save time and improve accuracy, leveraging knowledge of AI where applicable.

Assumes other duties as assigned.

Supervisory Responsibilities

Lead the work of others who perform essentially the same work. May set priorities, schedule and review work, but have no responsibility to hire, terminate, review performance and/or make pay decisions.

Minimum Requirements

• Bachelor’s degree or equivalent experience.
• 3+ years of related experience required; Fully competent professional; In-depth knowledge and experience; Degree or equivalent work experience.
• Minimum of three years of experience working in the automotive aftermarket and/or salvage industries.
• Intermediate Excel skills, including creating pivot tables, using VLOOKUP XLOOKUP, excel functions and other advanced formulas.
• SQL knowledge, including creating tables, working with data types, performing joins, and writing efficient queries to manage and analyze data.
• Data analytics skills, including the ability to analyze data, create reports, and utilize insights for decision-making and process improvement.

Preferred Requirements

• Experience with Hollander interchange, Mitchell Repairmate, or ACES information standards.
• In-depth knowledge of automotive makes, models, and parts.
• Knowledge of AI and automation is a plus.
• Familiarity with creating algorithms, automating processes, and improving accuracy and efficiency is desirable but not mandatory.
• Knowledge/Skills/Abilities Ability to add, subtract, multiply, and divide in all units of measure, using whole numbers, common fractions, and decimals.
• Ability to compute rates, ratios, and percentages and to draw and interpret graphs.
• Frequent use of Outlook, Word, Excel, graphics, etc.
• Ability to create, maintain and incorporate functions into Word documents, Excel spreadsheets, databases, and PowerPoint presentations to support business objectives.
• Regularly uses moderately complex oral and written skills. May train others in functional areas, interact with others and make presentations to department or middle management.
• Problems encountered are routine, somewhat repetitive and generally solved by following clear directions and procedures.
• Decisions generally affect own job or assigned functional area. Results are defined; sets personal own goals and determines how to achieve results with few or no guidelines to follow; supervisor/manager provides broad guidance and overall direction.
• Handle multiple tasks or projects simultaneously with moderate complexity.

Essential Physical Demands/Work Environment

Work is primarily sedentary: must be able to sit for extended periods and use a computer, keyboard, and mouse, frequently. Travel may be required periodically, including overnight stays (contingent on position requirements). Must be able to lift up to 25 pounds.

Benefits

• Health/Dental/Vision Insurance
• Paid Time Off
• 401k with Generous Company Match
• Company Paid Life Insurance and Long-Term Disability
• Short-Term Disability
• Employee Assistance Program
• Tuition Reimbursement
• Employee Discounts

Join us for an exciting career journey with positive, driven individuals.

Leading With Innovation

As a Fortune 500 leader (#318), LKQ operates across 25 countries with over 1,600 locations. Join us to shape the future of vehicle repair and customization, where your impact resonates globally.

Accelerate Your Career at LKQ

Join LKQ, a global force of over 51,000 strong across 1,700 locations. Here, you are a part of a community that drives our success and your career forward. Embrace the opportunity to grow, innovate, and lead the industry with us.

Shape the Future with LKQ

Embark on a journey where your work makes a tangible impact on the industry and beyond. LKQ offers a challenging yet rewarding career path filled with opportunities to grow, innovate, and contribute to a sustainable future. At LKQ, you're not just joining a team; you're stepping into a role where you can truly thrive. Start your career with us and discover where your journey can take you.

Equal Opportunity Employer Minorities/Women/Protected Veterans/Disabled

We endeavor to make this site accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact us.