800.268.1564
Français
Online Tracking
Secure Login

About Fastfrate:

Fastfrate Group has been providing industry-leading transportation services for more than 50 years. From what started out as an LTL over the road and intermodal carrier, Fastfrate has grown into a diverse group comprised of multiple companies operating across Canada. This evolution allows us to offer customers a full suite of asset-based transportation including over-the-road, cross-border, intermodal LTL and TL, drayage and transload, warehousing, distribution, logistics services and final mile.

Who we’re looking for:

The Fastfrate Group is looking for a Business Analyst to join our Business Analytics & Solutions (BAS) team in Port Coquitlam, British Columbia.  The ideal candidate will be familiar with Microsoft Excel and SQL.  This position being a Level 1, the candidate will have the opportunity to build their technical and analytical skills to expand to Level 2 and to Sr. level with experience.  Below is a breakdown of tasks and workload to be expected with the BA-L1

Routine Report Writing 5%

Routine Data Mining 10%

Routine Excel tool maintenance 3%

Routine Pricing / Costing analysis 45%

Routine Sharepoint maintenance 15%

Tool development 7%

SOP optimization / writing 15%

ensure to complete and deliver the project deliverables within the allowed timeline.

What you’ll do:

  • Collect and analyze data from various backend data sources to answer specific business-related questions using a variety of tools, though primarily Excel.
  • Participate in new business RFPs, doing analysis on available data to determine new rates.
  • Costing of customer accounts based on historical data to determine operating ratios
  • Monitor KPI’s and create KPI visibility report(s) on a weekly basis using MS Excel. Identify anomalies for the week and present the findings along with the visibility report for discussion.
  • Creation of SOPs in MS Word, Vision, Sharepoint medium and staff training as needed.
  • Travel to other branches may be required from time to time for short periods (1-2 days) for specific initiatives.

Must Haves:

  • University degree/Professional designation relating business analysis, data analysis, or similar is preferred
  • Operational knowledge of transportation is nice to have – LTL, TL, Intermodal/Rail, Drayage, Trans Load, Warehousing, Cross-Border, etc.
  • Minimum of 1 years of experience in advanced analytical skills using VBA in Excel is preferred
  • Experience with MS Visio is nice to have
  • Experience with Crystal Reports design and automation would be a plus
  • High level of organization skills including ability to follow established guidelines, methods and procedures to achieve desired results.
  • Time management skills (i.e. ensuring that all KPI reports are prepared correctly and in a timely manner, the ability to work under pressure and meet strict guidelines, etc.).
  • Communication skills (verbal, written, facilitation, e-mail) including an ability to interact with all levels of organization.
  • Proficient in both speaking and written for English and French
  • General computer skills including a high level of comfort with Office 365 and associated applications.
  • Experience with TMW Truckmate and its Business Intelligence software is a plus

Location:

Montreal, Qc

Contact:
leej@fastfrate.com