Consolidation Analyst
The Consolidation Analyst role at O'Reilly Auto Parts involves supporting Less-than-Truckload (LTL) and consolidation pricing activities. Key responsibilities include analyzing new and current business, maintaining pricing agreements, and providing optimized pricing solutions. Candidates should have a Bachelor's Degree in Computer Information Systems or equivalent experience, along with 3-5 years in Database Administration and logistics. Excellent communication skills and the ability to work in team environments are essential. O'Reilly offers competitive wages and opportunities for career growth.
Job description
Responsible for supporting the company’s Less than Truckload (LTL) and consolidation pricing activities. Including new and current business analysis, maintenance of pricing agreements and contracts, uploading data into rating system, and tariff pricing expiration details. In addition, this role will utilize logistics knowledge to provide optimized pricing solutions. ESSENTIAL JOB FUNCTIONS
- Build models based on provided data sets, including but not limited to mode optimization, cross-vendor opportunities, consolidation, and pool distribution.
- Analyze and price managed transportation and cross-border multi-mode solutions.
- Work directly with merchandise and operations departments to construct pricing and cost save initiatives.
- Review consolidation network for optimization, efficiency gains, and recommendations for new consolidation points.
- Ability to problem solve rating issues that arise with finance and operations teams. Root cause rate discrepancies with AR/AP teams.
- Function as TMS optimization software super-user to support the business operational needs.
- All other duties as assigned.
SKILLS/EDUCATION/KNOWLEDGE/EXPERIENCE/ABILITIES REQUIRED
- Bachelor's Degree in Computer Information Systems or equivalent experience.
- 3-5+ years’ experience in Database Administration.
- 3+ years’ experience in Logistics related field.
- 1+ year experience using route / fuel optimization software.
- Excellent verbal, written, listening and communication skills with the ability to communicate effectively among all levels of the organization.
- Willingness to work flexible schedule including nights/weekends.
- Must work well in a team environment.
- Must be able to learn independently.
- 3 years’ experience with Microsoft Excel, Microsoft Access and VBA.
- Advanced SQL database management and maintenance skills.
- Ability to learn new software programs as required to maximize fleet usage.
DESIRED
- Bachelors or Masters in information systems, computer science or logistics.
- Advanced experience with iSeries SQL.
- Advanced experience with MySQL.
- Advanced experience in Microsoft Excel & Access.
- Advanced experience in VB or VBA.
- Exceptional problem-solving skills.
O’Reilly Auto Parts has a proven track record of growth and stability. O’Reilly is full of successful career stories and believes in a strong promote-from-within philosophy, encouraging you to grow your career along with the organization. Total Compensation Package:
- Competitive Wages & Paid Time Off
- Stock Purchase Plan & 401k with Employer Contributions Starting Day One
- Medical, Dental, & Vision Insurance with Optional Flexible Spending Account (FSA)
- Team Member Health/Wellbeing Programs
- Tuition Educational Assistance Programs
- Opportunities for Career Growth.
Job details
- Published
- June 22, 2026
- Last checked
- July 9, 2026
- Job source
- myworkdayjobs
- Workplace
- On-site · Headquarters, US
- First seen
- June 22, 2026
See how well you match this job
Log in or sign up and Eva will compare your profile with this role, explain your strengths and show what to improve.
Sign up to see your matchAlready have an account? Log inMore at Ozark Automotive Distributors, Inc.
Similar jobs from this company
None listed.
Across the market
Similar jobs from other companies
Third-party content disclaimer
Full job descriptions are sourced directly from third-party applicant tracking systems (ATS), job boards, recruitment platforms, and employer career pages.
LiftmyCV does not claim ownership of this content or guarantee its accuracy or current availability. All original content is the intellectual property of the respective employers or other rights holders.
LiftmyCV hiring intelligence, availability checks, and related-job recommendations are generated from LiftmyCV data and public sources.
If you prefer, you may apply directly via the original listing for transparency.