Job Type
Full-time
Description
An opportunity has opened up to work at Tri-National! We are a Transportation and Logistics company, an employer of choice with a family friendly culture and fast-moving environment that is innovative and growing. You would report to the VP of Finance, create weekly reports, and work closely with the Accounting & Operations departments. Be able to collaborate on a team and communicate in a professional and efficient demeanor. Are you eager to grow with Tri-National and showcase your Microsoft Excel and analytical skills?
Job Responsibilities
- Update, maintain, and develop Area Lane Analysis (ALA) files on a weekly basis
- Attend and facilitate the weekly ALA meeting and displaying the ALA spreadsheet
- Prepare and maintain monthly sales reports for the sales staff
- Track MPG performance discrepancies between ALA and Dashboard
- Report weekly Key indicators to ownership and upper management
- Maintain records of rate addenda and ensure that contracts are signed and binding to both parties
- Review any contracts for adverse terms for new customers as they come through the onboarding process
- Maintain the fuel setup tools on our system and keep customers up to date with rate agreements to support Billing
- Support sales staff with research/data compilation as requested for new and existing customers
- Work with Billing/Accounting to make sure pre-programmed rates are current and up-to-date
- Produce monthly mileage report for VP Finance and accounting team
- Provide weekly reports to monitor fleet performance based on ALA data
- Perform ad hoc analysis when requested by ownership and upper management
- Review unusual fluctuations in performance metrics when identified by analytics tests and correct when necessary
- Distribute weekly the unbilled loads report
- When necessary, assist accounting and billing teams when outside carriers are used on TNI loads
- Compile data for some state specific monthly and annual reporting
Requirements
- Bachelor’s degree in Accounting, Finance, Statistics or Mathematics
- Advanced Excel skills are required
- 1 year of relevant experience a plus
- Possesses strong communication, interpersonal and analytical skills