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 Woodbridge, Ontario. The ideal candidate will be a Microsoft Excel and SQL guru, having experience with data analysis, complex calculations as well as dynamic model building. We want someone who can also take a database and design required SQL to collect and analyze historical data and perform various costing and efficiency scenarios. Knowledge of pricing, rates and costing in the transportation would be an asset. The candidate will need to 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.
- Assist Senior Management with creating specific reports as required.
- 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 3 years of experience in advanced analytical skills using VBA in Excel is required
- 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. English language skills are a must; French would be a plus.
- 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
WORKING ENVIRONMENT
This position requires confidentiality in dealing with client and corporate information, employee performance information and strategic business and financial objectives of the company.
We are a fast-paced environment, with tight deadlines, multiple priorities, and the chance to be a part of making a good company into a great company! If you are looking for a challenge, growth, and chance to be part of a terrific team, this is the place for you!
Woodbridge, ON
