Sr Catalog Analyst

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

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.

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. Assume 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.

Ability and Skills

• 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 is at the industry’s forefront, operating 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.

Connect With Your Future Let’s discover what you bring to LKQ. 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.