Fleet Administrator

PowerGrid Services, LLC; Hartselle, Northern (AL, KY); Hybrid; USD 60,000 - 90,000; Full time

Job summary

PowerGrid Services, LLC is seeking a Fleet Management Analyst to maintain and analyze costs, fuel usage, utilization and downtime across the fleet. You will develop lifecycle cost models to inform repair vs.

replacement decisions and create dashboards in Excel and Power BI to highlight trends and high-cost units. You will forecast equipment needs, coordinate moves between job sites, and manage preventive maintenance schedules while ensuring DOT/OSHA/MSHA compliance.

Qualifications

• Bachelor’s degree in business administration, logistics, finance or related field.
• 3-5 years in fleet management, heavy-equipment operations or logistics.
• Advanced experience using Fleetio and Samsara.
• Advanced proficiency with Excel (pivot tables) and Power BI.
• Experience with fleet management software, telematics and data analytics; SQL familiarity.

Responsibilities

• Maintain and analyze data on maintenance costs, fuel usage, utilization and downtime using fleet management software and telematics systems.
• Prepare lifecycle cost analyses and total cost of ownership models to inform repair vs. replacement decisions.
• Develop and automate dashboards and reports in Excel and Power BI, highlighting fleet performance trends and high-cost units.
• Forecast equipment needs with team and reallocate equipment to maximize utilization across job sites.
• Coordinate equipment moves between job sites and supervise drivers/vendors.
• Develop and manage preventive maintenance schedules; track repairs, warranty claims and parts inventory.
• Collaborate on capital budgets, cost estimates and ROI analyses for equipment acquisitions or disposals.
• Ensure compliance with DOT, OSHA, MSHA and utility-industry regulations; maintain records for inspections, licensing, insurance and fuel card programs.
• Manage relationships with equipment vendors, maintenance providers and transportation contractors; administer fuel card program and track fuel usage.

Skills

Advanced Excel

Power BI

SQL basics

Data analytics

Communication

Education

BA in business/logistics/finance

Tools

Fleetio

Samsara

SQL

Job description

• Maintain and analyze data on maintenance costs, fuel usage, utilization and downtime using fleet management software and telematics systems.
• Prepare lifecycle cost analyses and total cost of ownership models to inform repair vs. replacement decisions.
• Develop and automate dashboards and reports in Excel and Power BI, using pivot tables, to highlight fleet performance trends, high-cost units and under-utilized assets. Present findings and recommendations to operations and finance leadership.
• Forecast equipment needs with team and reallocate equipment to maximize utilization across job sites.
• Coordinate equipment moves between job sites; assist physically with moving and staging heavy equipment when needed and supervise drivers/vendors.
• Develop and manage preventive maintenance schedules; track repairs, warranty claims and parts inventory.
• Establish data-driven replacement schedules based on lifecycle analysis, utilization rates and repair costs.
• Collaborate on capital budgets, cost estimates and ROI analyses for equipment acquisitions or disposals.
• Ensure compliance with DOT, OSHA, MSHA and utility-industry regulations; maintain accurate records for inspections, licensing, insurance and fuel card programs.
• Manage relationships with equipment vendors, maintenance providers and transportation contractors; administer fuel card program and track fuel usage.

Qualifications

• Bachelor’s degree in business administration, logistics, finance or related field.
• 3-5 years of experience in fleet management, heavy-equipment operations or logistics; utility or public works experience preferred.
• Advanced experience using Fleetio and Samsara
• Advanced proficiency with Microsoft Excel (including pivot tables) and Power BI for data modeling, dashboard development and reporting.
• Experience with fleet management software, telematics and data analytics tools; familiarity with SQL or similar query lan.
• Strong analytical and reporting skills; ability to turn complex data into actionable insights for decision-makers.
• Knowledge of vehicle and heavy-equipment maintenance and relevant safety regulations.
• Effective communicator with strong organizational and problem-solving abilities.
• Ability and willingness to operate or move heavy equipment safely; commercial driver’s license (or ability to obtain one) required.
• Availability for occasional emergency response and storm restoration deployments.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.