Consolidation Analyst

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.

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

• 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.
• Advanced experience with iSeries SQL, MySQL, Microsoft Excel & Access, VB or VBA.
• Exceptional problem-solving skills.

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

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.

O’Reilly Auto Parts is an equal opportunity employer. The Company does not discriminate on the basis of race, religion, color, national origin or ancestry (including immigration status or citizenship), sex, sexual orientation, gender identity, pregnancy (including childbirth, lactation, and related medical conditions,), age (40 and over), veteran status, uniformed service member status, physical or mental disability, genetic information (including testing or characteristics) or another protected status as defined by local, state, or federal law, as applicable.

Qualified individuals with a disability may be entitled to reasonable accommodation under the Americans with Disabilities Act. If you require a reasonable accommodation during the application or employment process, please send an email to:  or call  option , and provide your requested accommodation, and position details.

From a comprehensive benefits and compensation package to a rewarding and positive work environment, your leaders will support you and foster your development so you can grow with the company. Our promote‑from‑within philosophy means our top leaders worked their way up – and you can, too. Learn more about our culture, benefits, and history at