Consolidation Analyst

About the role

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

Responsibilities

• Build models based on provided data sets, including 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.
• 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.
• Perform all other duties as assigned.

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.

Skills

• Bachelors or Masters in information systems, computer science or logistics (desired).
• Advanced experience with iSeries SQL (desired).
• Advanced experience with MySQL (desired).
• Advanced experience in Microsoft Excel & Access (desired).
• Advanced experience in VB or VBA (desired).
• Exceptional problem-solving skills.

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

Pay

Details TBD

Schedule

Details TBD

Company Info

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.