Transportation Optimization Analyst

PiVAL; Kirkland; On-site; CAD 70,000 - 95,000; Full time

Job summary

Pival International Inc. is a global logistics and supply chain management company that helps optimize distribution networks and transportation costs.

The role focuses on financial and supply chain analyses to drive profitability and better decision-making for Sales, Operations, and Finance teams. Reporting to Finance leadership, you will analyze DC networks, shipment profiles, and inventory data, present findings to senior stakeholders, and support pricing, contracts, and KPI reporting across

Qualifications

• Strong analytical abilities and ability to translate analysis into actionable decisions.
• Experience supporting a highly skilled team and implementing complex initiatives/projects.
• Proven track record of achieving results in a high-pressure environment.
• Excellent interpersonal, critical thinking, communication, and organizational skills.

Responsibilities

• Supports internal RFP process with pricing and profitability analyses for opportunities.
• Reviews, writes, and documents contracts for new customers.
• Supports onboarding from a financial standpoint—customer setup, billing, contract management, compliance.
• Supports competitive bid efforts in external Transportation and Warehousing RFP/RFQ opportunities.
• Creates internal and external reports (Power BI, Deck presentations, Spreadsheets) for business use.

Skills

Excel

Power BI

Tableau

Data analysis

Education

Bachelor’s degree in a relevant field

MBA or Master’s degree (asset)

Tools

WMS

TMS

BI tools

Job description

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.

Role 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

Others (Routine)

• 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

Others (As Needed)

• 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

Requirements

• Experience: 3-5 Years related to job descriptions
• Education: A numerate 4-year bachelor’s degree (required); Preferred disciplines include Industrial Engineering, Finance, Operations Research, Supply Chain Management, Mathematics, Applied Statistics, etc. 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

Competencies & Skills

• 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
• Previous experience supporting a logistics/supply-chain operation is considered an asset
• Comfortable with situational communication and tailoring details to different audience
• 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 MS Excel is required
• 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
• 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.