Transportation Optimization Analyst

PiVAL International•Guelph, ON

About The Position

Pival International Inc. is a global logistics and supply chain management company with a comprehensive menu of warehousing logistics solutions and transportation solutions, including time sensitivity (land and air), FTL, LTL, intermodal. Our work is guided by three core values that define who we are and how we operate: Integrity – We act with honesty, transparency, and respect in every interaction. Commitment – We take ownership, follow through on our responsibilities, and strive for excellence. Curiosity – We embrace learning, asking questions, and seeking continuous improvement. These values are central to how we deliver quality, collaborate as a team, and support our customers. They are reflected in every role across the organization and guide our decisions, behaviors, and growth. Reporting to the Director of Finance, the incumbent of this role will primarily work in conjunction with Sales (Business Development and Customer Success), Transportation Operations, Warehouse Operations, Finance, and IT to manage and oversee financial, business and supply chain analyses. The incumbent will be a solid communicator capable of analyzing clients’ supply chain data (DC network, shipment data profile, inventory levels, etc.) to recommend improved Supply Chain solutions and present findings to senior level internal stakeholders and/or high-profile clientele. Success in the role will be defined by the efficient use of analytical and operational expertise of the incumbent to drive financial performance and enhance profitability within the company.

Requirements

3-5 Years related to job descriptions
A numerate 4-year bachelor’s degree (required); Preferred disciplines include Industrial Engineering, Finance, Operations Research, Supply Chain Management, Mathematics, Applied Statistics, etc.
Strong analytical abilities and able to turn analysis into actionable decisions
Demonstrated experience in supporting a highly skilled team and implementing complex initiatives/projects
Proven track record of achieving results in a high-pressure environment
High level of interpersonal, critical thinking, communication, and organizational skills
Ability to manage multiple priorities in a fast-paced environment
Demonstrated ability to make meaningful sense of abstract ideas and ability to hep team members thrive in a fluid work environment
Comfortable with situational communication and tailoring details to different audience
Intermediate-to-Advanced working knowledge of MS Excel is required
Responsible for following best Quality, Environmental and Sustainable practices and ensuring procedures are adhered to within day-to-day operations.
Knowledgeable with the ISO9001:2015 and ISO14001:2015 Standard requirements applicable to assigned functions and role.
Takes accountability and supports team to contribute to the effectiveness of the quality (QMS) and environmental (EMS) management systems.

Nice To Haves

An MBA or a Masters (Not Required) is an asset.
A 2-year associate's degree may be considered if candidate has >5 years cognate experience
Previous experience supporting a logistics/supply-chain operation is considered an asset
General working knowledge of common logistics technologies (WMS, TMS, YMS, etc.) will be an asset; Specifically, 1-2 years hands-on experience with any TMS and WMS is preferred.
Intermediate-to-Advanced working knowledge of BI and dashboard style visualizations tools (Tableau, Power BI, etc.) will be an asset
General exposure to Data Aggregation and Automation tools (e.g. Alteryx, UIPath, etc.) will be an asset
Supply Chain Management Professional (SCMP) designation preferred but not required

Responsibilities

Supports company’s internal RFP process with Transportation and Distribution pricing solutions; Provides pricing and profitability analyses for prospective opportunities
Reviews, writes, distributes and documents all contracts for new customers
Supports the customer onboarding process from a financial standpoint - including customer set-up, billing set-up, contract management, contract compliance, etc.
Supports company’s competitive bid efforts in all external Transportation and Warehousing partners’ RFP/RFQ opportunities
Prepares and presents monthly revenue reports – Distribution Centers, Distribution & Transportation Customers
Maintains monthly KPIs and create Performance Dashboards for Sales, Distribution, Transportation and Finance to be presented to leadership during monthly S&OP meetings
Maintains and updates standard rate cards in response to market demands and PiVAL operations
Collaborates with Finance and IT to ensure existing and new Transportation contracts (Carrier cost rates and client sell rates) are accurately captured in the TMS
Assists Transportation Operations in streamlining end-to-end transportation needs to deliver the required Transportation service at the optimal cost.
Collaborates with IT to address issues in TMS contracts: Out of Contract lanes, Billing exceptions, etc.
Periodically (weekly/bi-weekly/monthly/annual) updates Transportation rates in the TMS (e.g., weekly fuel surcharges based on weekly FCA fuel surcharges and different carrier contracts)
Creates internal and external reports (Power BI Reports, Deck presentations and Spreadsheets) for business use
Leads all Transportation and Distribution Analytics support on projects focused on strategic corporate initiatives
Computes quarterly incentive payouts for Sales, Expedite and Transportation teams according to their respective Incentive Programs
Collaborates with the Directors of Finance, Distribution, Transportation and sales on annual Revenue and Cost budgeting efforts.
Manages ad-hoc projects, data analysis requirements, and implements supply chain optimization projects
Provides analytical support (Transportation Route Analysis, Warehouse Greenfield Analysis, Scheduling Optimization, Pricing analytics, etc.) for all Transportation and Warehousing projects, new business opportunities, proposals and acquisitions
Interprets and analyzes clients’ Supply Chain data (Transportation, Distribution, Inventory, etc.) using statistical techniques
Documents SOPs for routine Transportation and Distribution processes (e.g., rate updates in the TMS, AP/AR Pricing reconciliations, etc.) and maintains thorough documentation of all assigned projects
Provides analytical supports to Transportation during Carrier Contract negotiations and pricing
Partners with IT to research/implement Transportation software solutions to take advantage of emerging technologies; Presents and communicates use-cases and POCs (Proof of Concepts) for such solutions to Leadership and Operations
Other tasks as assigned