Consolidation Analyst

O'Reilly Automotive Inc

MO

JOB DETAILS
SKILLS
Accounts Payable, Accounts Receivable, Analysis Skills, Business Analysis, Business Operations, Business Support, Communication Skills, Computer Science, Cost Control, Data Sets, Database Administration, Distribution Channel, Financial Operations, Information Technology & Information Systems, Less Than Truckload (LTL), Logistics, Microsoft Access Database, Microsoft Excel, Microsoft Visual Basic, Microsoft Visual Basic for Applications (VBA), Operational Support, Parts Sales, Philosophy, Presentation/Verbal Skills, Pricing, Problem Solving Skills, SQL Databases, Stock Purchase Plans, Vehicle Fleets, Writing Skills
LOCATION
MO
POSTED
4 days ago

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

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: rar@oreillyauto.com or call (800) 471-7431 option , and provide your requested accommodation, and position details.

About the Company

O

O'Reilly Automotive Inc

It started with a father and son - Charles Francis "C.F." and Charles H. "Chub" O’Reilly. Together they had the courage and confidence to venture out on their own. Along with 11 others who shared the same desire to offer great customer service and auto parts availability, the doors of O’Reilly Automotive, Inc. opened on December 2, 1957.

Now, more than 61 years later, the 77,000-plus team members at O’Reilly Auto Parts are proud of the company’s achievements over the years.

During our early years, we focused on sales and slow and steady growth. At the end of our first year, sales totaled $700,000, and by 1961 volume reached $1.3 million. For the first seven years of operation, there was one store in Springfield, MO, until the second opened in July 1964. In March 1975, annual sales volume rose to $7 million and a 52,000 square-foot facility was built in Springfield for the O’Reilly/Ozark warehouse operation. By that time, the company had nine stores, all located in southwest Missouri.

The long range plans and stability of the company were solidified by a public offering of company stock in April 1993. Since that time, the Company has grown through new store and distribution center openings, as well as numerous mergers and acquisitions. O’Reilly currently operates stores in 47 states, including Alaska and Hawaii, and distribution centers in 27 locations.

Dramatic changes in technology, inventory control, facilities, and sheer size mark the O’Reilly growth and success story. But, it is our spirit of teamwork - how important it was then and how important it remains - that drives our performance. The company’s values and culture that started with the original 13 employee/owners remain evident and strong as we expand and develop Team O’Reilly.

We serve two distinct customer bases - the professional (installer) customers who provide auto repair services to their customers (DIFM - do it for me), and retail "walk-in" customers (DIY - do it yourself). Our dual-market strategy continues to differentiate us from the competition and is a major factor in our ongoing success. Depending on a store’s professional versus retail customer mix, more than 95 percent of our locations have team members dedicated to our professional customers, offering them separate counters, phone lines, and a delivery fleet that totals 18,455 vehicles. We also have a professional sales team, consisting of territory sales managers and in-store sales specialists, responsible for calling on our professional customers and building sound business partnerships to ensure O’Reilly is the First Call for their auto parts needs.

COMPANY SIZE
10,000 employees or more
INDUSTRY
Automotive Sales and Repair Services
FOUNDED
1957
WEBSITE
https://corporate.oreillyauto.com/onlineapplication/careerpage