YRC Freight Business Intelligence Analyst II-Overland Park, KS in Overland Park, Kansas


This role will work within a customer-focused team to provide solutions and services for YRCW’s third-party logistics (3PL) customer base. This role is part of a cross-functional team consisting of customer account management, customer service, operations/logistics, pricing and technology team members. Together the team will:

  • Analyze customer data files for freight optimization events.

  • Locate and assist in defining new process improvement opportunities.

  • Support creation of Customer quarterly business review (QBR) decks and monthly reports utilizing Microsoft Power BI.

  • Work closely with Pricing Analyst(s) to complete customers RFPs (Requests For Proposals) and Customer-Specific Negotiated Increases (CSNIs) in pricing.

  • Grow overall services for existing and new customers.


  1. Intermediate level understanding of the operating capabilities and capacities of the YRCW Operating Companies (YRC Freight, Holland, Reddaway, New Penn).

  2. Intermediate level understanding of the YRCW Operating Companies’ IT systems as sources of operations data.

  3. Analyze and understand the business shipment characteristics and patterns of customers.

  4. Analyze logistics processes and systems, compile data and provide statistical analysis on shipment volumes, lanes, on-time service, and cost.

  5. Interpret data, analyze results using statistical techniques and provide ongoing reports.

  6. Acquire data from primary or secondary data sources and maintain databases/data systems.

  7. Identify, analyze, and interpret trends or patterns in data sets.

  8. Filter and “clean” data, and review report integrity.

  9. Report data file issues to be fixed by database administrator.

  10. Work with the team to design new and improved services for YRCW 3PL customers.


  1. Adaptability - Maintaining effectiveness when experiencing major changes in work responsibilities or environment (e.g., people, processes, structure, or culture); adjusting effectively to change by exploring the benefits, trying new approaches, and collaborating with others to make the change successful.

  2. Building Trusting Relationships - Using appropriate interpersonal styles to establish effective relationships with customers and internal partners; interacting with others in a way that promotes openness and trust and gives them confidence in one’s intentions.

  3. Collaborating - Working cooperatively with others to help a team or work group achieve its goals.

  4. Communication - Conveying information and ideas clearly and concisely to individuals or groups in an engaging manner that help them understand and retain the message; listening actively to others.

  5. Continuous Learning - Actively identifying new areas for learning; regularly creating and taking advantage of learning opportunities; using newly gained knowledge and skill on the job and learning through their application.

  6. Initiating Action - Taking prompt action to accomplish work goals; taking action to achieve results beyond what is required; being proactive.

  7. Work Standards - Setting high standards of performance for self and others; assuming responsibility and accountability for successfully completing assignments or tasks; self-imposing standards of excellence rather than having standards imposed.


  1. Bachelor's degree in a related field; two (2) to four (4) years’ experience in a similar, business and data analytics role.

  2. Prior experience with data analytics, transformation and reporting tools.

  3. Industry experience: transportation or 3PL industry knowledge is preferred; other relevant industry experience would include manufacturing, retail, or industrial distribution.

  4. Excellent verbal and written communication skills.

  5. Strong interpersonal skills, ability to work with all levels of management.


  1. Prefer experience with Microsoft tools (PowerBI, Excel, SSIS, SSRS).

  2. Preferred degrees include Logistics, Supply Chain, and Business Data Analytics.


This job operates in a professional office environment indoors. Routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets, and fax machines.


The position requires the ability to spend long hours sitting or standing while using office equipment and computers. Ability to perform repetitive tasks such as typing and keying. Occasional lifting, pushing/pulling, carrying 10 lbs of supplies and materials is required.

YRC Worldwide is an Equal Opportunity/Affirmative Action Employer

/Minorities/Females/Persons with Disabilities/Protected Veterans/

Title: Business Intelligence Analyst II-Overland Park, KS

Location: KS-Overland Park

Requisition ID: 18040G