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.
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.
- 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.
- 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
Montreal, Qc
