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