Business Intelligence and Data Analyst - Oakville, Canada - ASL Distribution

ASL Distribution

Verified Company

Oakville, Canada

2 weeks ago

Posted by:

Sophia Lee

beBee Recruiter

Description

Position:
Business Intelligence and Data Analyst

Department:
Data Analytics & Business Systems Engineering

Reports to:
Senior Manager

Data Analytics & Business Systems Engineering

Revision Date:
June 16, 2023

About Us:

ASL Distribution is more than just a transportation and warehousing company.

Our proven 60+ year history as a third-party logistics provider means we have the experience necessary to offer knowledgeable and proactive solutions to all our clients' logistics, shipping, warehousing, and distribution needs.

We are a dynamic and passionate third-party logistics provider. ASL offers their clients a diverse range of customized services, such as warehousing and distribution. This allows them to partner with clients on a unique level to help achieve their logistics goals.

About the Position:

You will be responsible for operational excellence, financial performance, customer obsession, continuous process improvement, statistical analysis, turning data into insights/Predictive Analytics, and data visualization.

What the Company Will Provide to You:

A fun, fast-paced, open, and friendly work environment
Competitive average salary
Company benefits (after the probationary period)
Education Reimbursement program
Company events

Duties/Responsibilities:

As the Business Intelligence Data Analyst, your duties will include:

Develop a system to measure, monitor and report business critical KPIs as defined by the leadership group across all Hubs for the Precision
Final Mile division. This will include a pilot with one hub, as well as a rollout across all hubs
Work closely with the Director of Operations, to develop a daily operating report (DOR) to forecast daily volume and capacity requirements (vehicles by type, sort crew, IOOs from productivity measures) based on historical data and trends on orders/pieces/stops, volume variation from peak/nonpeak, Amazon vs nonAmazon hubs
Analyze the current routing process and use data analytics in combination with potential dynamic routing software to improve route efficiency, cost to serve, service time by stop, and optimize other customerfacing KPIs including recommendations on improving margin per route, minimizing route overlaps
Work with the Finance and Operations group to revamp the current manual process of reporting driver margins for each settlement period including trends over a period of time and reporting various metrics and insights from the trend such as stops/hour, pieces/hour, miles/stop, total time vs drive time %
Use data to profile terminal, revenue, and customer shipments by hub considering various characteristics such as size, cube, stackability, weight as well as pieces, stops, route density
Revamp the current agency usage monitoring system especially during peak to strike a balance against cost and service SLAs. Measure and monitor % agency usage as set by leadership daily and report any anomalies by the hub
Revamp current IOOs topup process by creating a system of identifying and capturing true topups, approval by a terminal manager, providing consolidated inputs for driver settlement report as well as and reporting relevant metrics by the driver by hub
Take over Daily management of OTD, DBDC, Aging, MOSD, Dock Sort, and IOO health reporting
Revamp existing customer rate increases tracking system to simplify notifications on expiration dates, new rates preparation, approval, submission to customers, system updates, and invoice review by using process automation, desktop flows, and API integration
Revamp existing versions of Carpediabased Eval and management rollup report to reflect changes in business, new KPIs
Develop a system to measure, monitor and report margin by customer, margin by route, and margin by driver including daily P/L
Revamp existing costing models to better capture costs by category, improve spot quotes turnaround time and business margins by route/customer
Develop a system to measure overall ASL's customer service delivery against the R5 model by monitoring and reporting ontime deliveries, deep diving into custom customer claims to improve underlying business operations, tracking customer complaints and resolutions, preparing QBR reports, and presentations for key accounts, etc.
Develop a database for all customers with relevant KPIs on revenue streams, revenue mix, fixed vs variable cost to serve, seasonality, IT capabilities, cultural fit, margin per month, etc. to provide insights to the leadership team on building a solid customer base aimed at maximizing asset utilization and profit margin
Develop and present one business case per month as part of a continuous process improvement work stream driven by data analytics aimed at increasing revenue, reducing cost, improving assets utilization, enhancing customer experience, etc. Take into consideration efforts vs value, cost of implementation, ROI, payback, risk assessment, etc.
Develop a