Sorry, this listing is no longer accepting applications. Don’t worry, we have more awesome opportunities and internships for you.
Pilot Freight Services

Pilot Freight Services

Financial Data Analyst

Glen Mills, PA
Full Time
Paid
  • Responsibilities

    PILOT FREIGHT SERVICES seeks a full time  FINANCIAL DATA ANALYST to work at  our CORPORATE OFFICE IN GLEN MILLS, PA.

    JOB SUMMARY

    Pilot is going through a rapid transformation, using data and analytics to grow the business in new ways. This position will support the FP&A group by learning business intelligence and visualization tools that can automate reporting and improve reporting accuracy. This role will contribute on budgeting, forecasting, and monthly management reporting. The position will support the Director of Financial Planning & Analysis.

    RESPONSIBILITIES:

    • Become the FP&A data subject matter expert utilizing Alteryx and Tableau
    • Automate time consuming and manual FP&A tasks using Alteryx
    • Create and publish finalized FP&A operational dashboards and KPIs to Tableau
    • Connect the FP&A team to the transactional software so that we can better understand customer and shipment level profitability
    • Be the liaison between the FP&A and Data & Analytics teams
    • Learn Workday GL Reporting function to build custom reports for the FP&A team
    • Support the Company's FP&A function including understanding, analyzing and reporting on the Company's revenues, purchase transportation expenses, operational expenses, SG&A expenses and capital expenditures. This includes identifying trends and analyzing and explaining material variances to budget.
    • Perform special projects and ad hoc analysis as requested
  • Qualifications
    • Bachelor's degree in a computer science, finance, accounting, economics, mathematics or related degree is required.
    • At least one year of related experience is preferred.
    • Position requires a strong aptitude to quickly learn BI and Visualization software.
    • Proficient Excel modeling and PowerPoint skills.
    • Must be detail oriented.
  • Industry
    Logistics and Supply Chain
  • About Us

    Pilot Freight Services is a leading freight forwarder and 3rd party logistics provider that ships heavy, bulky freight for business-to-business and business-to-consumer customers. Pilot’s customers include Fortune 100 companies to local businesses. The company focuses on providing customized solutions for customers, meaning Pilot excels when other carriers can’t!