What are the responsibilities and job description for the Transportation Analyst position at O'Reilly Auto Parts?
The Transportation Analyst plays a critical role in designing, optimizing, and supporting O’Reilly’s multi‑fleet transportation network. This role blends strategic network optimization, transportation systems ownership, and advanced data analytics to support DOT, City Counter, Hub, and Retail delivery operations across the enterprise.
This analyst supports leadership and senior analysts by providing accurate analysis, operational insights, and reporting that enable informed transportation decisions and continuous improvement.
Essential Job Functions
Transportation Strategy & Network Optimization
Support annual and quarterly route rebids across all distribution centers, including mileage, equipment, driver requirements, and service trade‑offs.
Perform what‑if scenario analysis for store openings, network shifts, DC capacity changes, and fleet growth.
Partner with Network Optimization resources to validate routing outputs and identify optimization opportunities.
Evaluate routing and optimization software solutions (strategic, tactical, and execution‑level tools).
Fleet Management, Telematics & Technology
Support fleet management platforms related to vehicle assets, inspections, maintenance visibility, and compliance.
Serve as an analytical support resource for telematics and ELD platforms, including data validation, reporting, and operational insights.
Assist with configuration support, testing, and validation of fleet‑related system enhancements, integrations, and updates.
Participate in vendor discovery, demos, pilots, and evaluations for fleet management, telematics, and related transportation technology.
Assist with documenting system behaviors, operational issues, and business requirements related to fleet and driver operations.
Data Analytics & Reporting
Develop And Maintain Advanced Analytical Models Supporting
Mileage, cost, MPG, and productivity metrics
Driver and equipment utilization
On‑time performance and service metrics
Build automated dashboards and reporting using SQL‑based data sources and visualization tools.
Partner with Data & Analytics teams to source, validate, and automate transportation data pipelines.
Translate complex data into clear, actionable insights for leadership.
Financial & Business Analysis
Conduct cost‑benefit and ROI analysis for transportation initiatives and technology investments.
Support budgeting and forecasting efforts related to miles, drivers, equipment, and software.
Perform variance analysis against budget, bid, and operational expectations.
Cross‑Functional & Project Support
Collaborate with Distribution Operations, Store Operations, IT, Finance, and external vendors.
Support compliance‑driven initiatives (FMCSA and applicable federal, state, and local regulations).
Assist with special projects, incident reviews, and executive‑level briefings.
Contribute to SOP development, process documentation, and training materials.
Skills/Education/Experience
Required Qualifications
Bachelor’s degree in Logistics, Supply Chain, Information Systems, Engineering, or equivalent experience.
3–5 years of experience in transportation analytics, systems, or network optimization.
Strong proficiency in SQL and advanced data analysis.
Advanced Microsoft Excel skills (complex formulas, data modeling; VBA a plus).
Experience working with fleet management systems, telematics/ELD platforms, and routing tools.
Ability to manage multiple initiatives and priorities independently.
Strong written and verbal communication skills with the ability to support executive‑level discussions.
Preferred Qualifications
Experience with fleet management or maintenance systems (CMMS or similar platforms).
Exposure to routing and optimization solutions (strategic and operational).
Experience with DOMO, Snowflake, or comparable analytics platforms.
Familiarity with iSeries / IBM i SQL environments.
Experience supporting pilots, system rollouts, or RFP processes.
Education or experience in project management, user testing, or change management.
Key Competencies & Attributes
Highly analytical and detail‑oriented with strong business judgment.
Comfortable operating with ambiguity and evolving requirements.
Proactive problem‑solver who focuses on root cause, not symptoms.
Strong sense of ownership and accountability.
Able to balance strategic thinking with operational realities.
Trusted partner to peers, leadership, and external vendors.
Work Environment & Travel
Primarily office‑based with periodic travel to Distribution Centers and stores.
Occasional overnight travel may be required.
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
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.
This analyst supports leadership and senior analysts by providing accurate analysis, operational insights, and reporting that enable informed transportation decisions and continuous improvement.
Essential Job Functions
Transportation Strategy & Network Optimization
Support annual and quarterly route rebids across all distribution centers, including mileage, equipment, driver requirements, and service trade‑offs.
Perform what‑if scenario analysis for store openings, network shifts, DC capacity changes, and fleet growth.
Partner with Network Optimization resources to validate routing outputs and identify optimization opportunities.
Evaluate routing and optimization software solutions (strategic, tactical, and execution‑level tools).
Fleet Management, Telematics & Technology
Support fleet management platforms related to vehicle assets, inspections, maintenance visibility, and compliance.
Serve as an analytical support resource for telematics and ELD platforms, including data validation, reporting, and operational insights.
Assist with configuration support, testing, and validation of fleet‑related system enhancements, integrations, and updates.
Participate in vendor discovery, demos, pilots, and evaluations for fleet management, telematics, and related transportation technology.
Assist with documenting system behaviors, operational issues, and business requirements related to fleet and driver operations.
Data Analytics & Reporting
Develop And Maintain Advanced Analytical Models Supporting
Mileage, cost, MPG, and productivity metrics
Driver and equipment utilization
On‑time performance and service metrics
Build automated dashboards and reporting using SQL‑based data sources and visualization tools.
Partner with Data & Analytics teams to source, validate, and automate transportation data pipelines.
Translate complex data into clear, actionable insights for leadership.
Financial & Business Analysis
Conduct cost‑benefit and ROI analysis for transportation initiatives and technology investments.
Support budgeting and forecasting efforts related to miles, drivers, equipment, and software.
Perform variance analysis against budget, bid, and operational expectations.
Cross‑Functional & Project Support
Collaborate with Distribution Operations, Store Operations, IT, Finance, and external vendors.
Support compliance‑driven initiatives (FMCSA and applicable federal, state, and local regulations).
Assist with special projects, incident reviews, and executive‑level briefings.
Contribute to SOP development, process documentation, and training materials.
Skills/Education/Experience
Required Qualifications
Bachelor’s degree in Logistics, Supply Chain, Information Systems, Engineering, or equivalent experience.
3–5 years of experience in transportation analytics, systems, or network optimization.
Strong proficiency in SQL and advanced data analysis.
Advanced Microsoft Excel skills (complex formulas, data modeling; VBA a plus).
Experience working with fleet management systems, telematics/ELD platforms, and routing tools.
Ability to manage multiple initiatives and priorities independently.
Strong written and verbal communication skills with the ability to support executive‑level discussions.
Preferred Qualifications
Experience with fleet management or maintenance systems (CMMS or similar platforms).
Exposure to routing and optimization solutions (strategic and operational).
Experience with DOMO, Snowflake, or comparable analytics platforms.
Familiarity with iSeries / IBM i SQL environments.
Experience supporting pilots, system rollouts, or RFP processes.
Education or experience in project management, user testing, or change management.
Key Competencies & Attributes
Highly analytical and detail‑oriented with strong business judgment.
Comfortable operating with ambiguity and evolving requirements.
Proactive problem‑solver who focuses on root cause, not symptoms.
Strong sense of ownership and accountability.
Able to balance strategic thinking with operational realities.
Trusted partner to peers, leadership, and external vendors.
Work Environment & Travel
Primarily office‑based with periodic travel to Distribution Centers and stores.
Occasional overnight travel may be required.
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
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.