Analyst, Transportation

Company DescriptionPilot Company is an industry-leading network of travel centers with more than 30,000 team members and over 750 retail and fueling locations in 44 states and six Canadian provinces. Our energy and logistics division serves as a top supplier of fuel, employing one of the largest tanker fleets and providing critical services to oil operations in our nation's busiest basins. Pilot Company supports a growing portfolio of brands with expertise in supply chain and retail operations, logistics and transportation, technology and digital innovation, construction, maintenance, human resources, finance, sales and marketing.

Founded in 1958 by Jim A. Haslam II and currently led by CEO Adam Wright, our founding values, people-first culture and commitment to giving back remains true to us today. Whether we are serving guests, a fellow team member, or a trucking company, we are dedicated to fueling people and keeping North America moving.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, protected veteran status or any other characteristic protected under applicable federal, state, or local law.

Military encouraged to apply.

Job DescriptionThe purpose of this job is to measure and report on key metrics related to Transportation and Midstream operations. This team member will also partner with transportation operations and the payroll team to ensure accuracy of weekly driver payroll submissions.

Generate and interpret reports on Key Performance Indicators (KPIs) on a monthly/quarterly basisDevelop useful Data Visualization tools for Transportation and Midstream managementPerform deep dives into departmental data for discovery and for applied problem-solvingMaintain data integrity by collaborating with internal teams, including business intelligence and energy accountingFulfill requests for detailed information and reporting from Transportation and Midstream Operations teams.

Build and maintain driver payroll and productivity reports, dashboards, and trackers to surface trends and insights for leadershipModel behaviors that support the company's common purpose; ensure guests and team members are supported at the highest levelEnsure all activities are in compliance with rules, regulations, policies, and proceduresComplete other duties as assignedQualificationsBachelor's degree in a business analytics, or computer science field, or 3 years relevant work experienceMinimum of two years advanced software skills, Tableau or other visual tool; three to five years preferredTwo+ years of experience in Supply Chain preferredAdvanced Microsoft Office and Excel skillsExperience using integrated development environmentsProficient in using server-based report generating software systemsKnowledge of SQL and how to use itExcellent written and verbal communication skillsAbility to convey complex technical information to both technical and non-technical audiencesMust be able to set priorities and remain engaged with problems to resolutionExcellent analytical skills and attention to detailAbility to identify data trends and outliersStrong data visualization abilitiesHigh level of customer service skillsAbility to work independently and as a member of a team to achieve stated goalsAdditional InformationTravel required less than 5%General office work requiring sitting or standing for long periods of timeAbility to work extended hours and weekends as required