Business Intelligence and Data Analyst

1 month ago

Oakville, Canada ASL Distribution Full time

**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/non-peak, Amazon vs non-Amazon 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 customer-facing 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 top-up process by creating a system of identifying and capturing true top-ups, 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 Carpedia-based Eval and management roll-up 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 on-time 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

  • Data Intelligence Advocate

    3 weeks ago

    Oakville, Canada Geotab Full time

    Who we are:Geotab ® is a global leader in IoT and connected transportation and certified “Great Place to Work™.” We are a company of diverse and talented individuals who work together to help businesses grow and succeed, and increase the safety and sustainability of our communities.Geotab is advancing security, connecting commercial vehicles to the...

  • Data Analyst

    5 days ago

    Oakville, Canada Geotab Full time

    Who you are: We are always looking for amazing talent who can contribute to our growth and deliver results! Geotab is seeking a Data Analyst, this role involves analyzing clearly defined datasets using diverse tools to address specific business requirements and uncover valuable insights. This position focuses on discerning how analysis results can directly...

  • Data Analyst

    4 days ago

    Oakville, Canada Geotab Full time

    Who you are: We are always looking for amazing talent who can contribute to our growth and deliver results! Geotab is seeking a Data Analyst, this role involves analyzing clearly defined datasets using diverse tools to address specific business requirements and uncover valuable insights. This position focuses on discerning how analysis results can directly...

  • Senior Data Analyst, ITS

    1 month ago

    Oakville, Canada Geotab Full time

    Who we are:Geotab ® is a global leader in IoT and connected transportation and certified “Great Place to Work™.” We are a company of diverse and talented individuals who work together to help businesses grow and succeed, and increase the safety and sustainability of our communities.Geotab is advancing security, connecting commercial vehicles to the...

  • Data Analyst Operations Oakville, ON

    2 days ago

    Oakville, Canada Geotab Inc. Full time

    We are always looking for amazing talent who can contribute to our growth and deliver results! Geotab is seeking a Data Analyst, this role involves analyzing clearly defined datasets using diverse tools to address specific business requirements and uncover valuable insights. This position focuses on discerning how analysis results can directly enhance the...

  • Data Analyst Operations Oakville, ON

    3 days ago

    Oakville, Canada Geotab Inc. Full time

    We are always looking for amazing talent who can contribute to our growth and deliver results! Geotab is seeking a Data Analyst, this role involves analyzing clearly defined datasets using diverse tools to address specific business requirements and uncover valuable insights. This position focuses on discerning how analysis results can directly enhance the...

  • Data Analyst Operations Oakville, ON

    3 days ago

    Oakville, Canada Geotab Inc. Full time

    We are always looking for amazing talent who can contribute to our growth and deliver results! Geotab is seeking a Data Analyst, this role involves analyzing clearly defined datasets using diverse tools to address specific business requirements and uncover valuable insights. This position focuses on discerning how analysis results can directly enhance the...

  • Lead People Data Analyst

    1 month ago

    Oakville, Canada Geotab Full time

    Who we are: Geotab ® is a global leader in IoT and connected transportation and certified “Great Place to Work.” We are a company of diverse and talented individuals who work together to help businesses grow and succeed, and increase the safety and sustainability of our communities. Geotab is advancing security, connecting commercial vehicles to the...

  • Senior Data Analyst

    2 weeks ago

    Oakville, Canada Geotab Full time

    Who we are:Geotab ® is a global leader in IoT and connected transportation and certified “Great Place to Work™.” We are a company of diverse and talented individuals who work together to help businesses grow and succeed, and increase the safety and sustainability of our communities.Geotab is advancing security, connecting commercial vehicles to the...

  • Data Analyst

    1 day ago

    Oakville, Canada BioScript Solutions Full time

    At BioScript Solutions, we’re committed to simplifying access to specialty care for people with chronic health conditions and rare diseases. From our home base in Atlantic Canada, we’ve grown into a national network of 13 pharmacies, 100+ Coverdale Clinics, and comprehensive patient support programs (NavieGo) that serve thousands of people across the...

  • Summer Student

    1 month ago

    Oakville, Canada FCT Full time

    Sommaire de la compagnie Venez travailler pour une entreprise qui est engagée dans la réussite de chacun de ses employés. C’est un milieu de travail où les innovateurs et les collaborateurs se rencontrent et tirent parti des talents de chacun. Un endroit où la diversité est accueillie et célébrée. FCT offre la meilleure assurance titres de...

  • Enrolment & Graduate Reporting Analyst (Temporary)

    1 month ago

    Oakville, Canada Sheridan College Full time

    Reporting directly to the Associate Registrar, Records, Registration and Scheduling, the Analyst identifies, designs, manages enhancements, collects, stores, analyzes and preserves the Enrolment and Graduate Data Repositories. From this repository, the Analyst fulfills all enrolment and graduate-related business needs and reporting requirements as identified...

  • Investigative Analyst

    1 month ago

    Oakville, Canada Halton Regional Police Service Full time

    **The Team you are Joining - Who We Are**: The Halton Regional Police Service contributes to the safety and well-being of more than 620,000 residents in Halton Region which includes the Towns of Milton, Halton Hills and Oakville, and the City of Burlington. It is our continual pursuit of excellence that keeps Halton at the forefront of policing and as a...

  • Sr. Data Analyst, Risk

    1 week ago

    Oakville, Canada Sagen Full time

    Reporting to the Director, Risk Analytics, the Sr. Data Analyst will play a key role in data storytelling and leveraging data science algorithms to extract trends, patterns, and insights from our organization’s data to identify emerging risks and risk mitigation strategies. Responsibilities Creating solutions and strategies to business problems using...

  • Sr. Data Analyst, Risk

    1 week ago

    Oakville, Canada Sagen Full time

    Reporting to the Director, Risk Analytics, the Sr. Data Analyst will play a key role in data storytelling and leveraging data science algorithms to extract trends, patterns, and insights from our organization's data to identify emerging risks and risk mitigation strategies. Responsibilities Creating solutions and strategies to business problems...

  • Sr. Data Analyst, Risk

    2 weeks ago

    Oakville, Canada Sagen Full time

    Reporting to the Director, Risk Analytics, the Sr. Data Analyst will play a key role in data storytelling and leveraging data science algorithms to extract trends, patterns, and insights from our organization’s data to identify emerging risks and risk mitigation strategies. Responsibilities Creating solutions and strategies to business problems using...

  • Sr. Data Analyst, Risk

    2 weeks ago

    Oakville, Canada Sagen Full time

    Reporting to the Director, Risk Analytics, the Sr. Data Analyst will play a key role in data storytelling and leveraging data science algorithms to extract trends, patterns, and insights from our organization’s data to identify emerging risks and risk mitigation strategies. Responsibilities Creating solutions and strategies to business problems using...

  • Sr. Data Analyst, Risk

    2 weeks ago

    Oakville, Canada Sagen Full time

    Reporting to the Director, Risk Analytics, the Sr. Data Analyst will play a key role in data storytelling and leveraging data science algorithms to extract trends, patterns, and insights from our organization’s data to identify emerging risks and risk mitigation strategies. Responsibilities Creating solutions and strategies to business problems using...

  • Data Engineer

    2 weeks ago

    Oakville, Ontario, Canada Finsana Full time

    Salary: SUMMARYFINSANA is a global fintech company that specializes in catering to underserved and underbanked consumers. Our organization has a passion for helping people financially through our technology solutions which has allowed us to serve millions of consumers globally.Headquartered in Montreal, Canada with offices in the United States and Latin...

  • Data Engineer

    2 weeks ago

    Oakville, Canada Finsana Full time

    Salary: SUMMARYFINSANA is a global fintech company that specializes in catering to underserved and underbanked consumers. Our organization has a passion for helping people financially through our technology solutions which has allowed us to serve millions of consumers globally.Headquartered in Montreal, Canada with offices in the United States and Latin...