Consolidation Analyst

O'Reilly Auto Parts • Headquarters, KY

2d • Onsite

About The Position

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.

Requirements

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

Nice To Haves

• 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

Responsibilities

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

Benefits

• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: Associate degree