B

Freight Auditor & Administrative Analyst - Contract

Brewers Retail Inc
1 day ago
Contract
On-site
Caledon, Ontario, Canada
Direct

Who We Are

Becoming experts on beer doesn't happen overnight - we've been in business since 1927 and today, The Beer Store is the primary distribution and sales channel for beer in Ontario and is owned by 28+ Ontario-based brewers!  Through our Retail Stores, Distribution Centres, Draught Services, Customer Experience Centre, and our Corporate Office, we form one large team that is passionate about the beer business. The Beer Store is proud to foster a respectful and inclusive culture that expands and leverages the diverse talents, experiences, and perspectives of our team members to deliver exceptional service for our customers. We continue to be successful by working together, respecting each other, having a positive attitude and by trying new and innovative ideas. Not only are we knowledgeable, passionate, and loyal ambassadors for beer, we’re also health and safety advocates, environmental champions, DEIB enthusiasts and we give proudly back to our communities. 

The Role

We are currently searching for a Freight Auditor & Administrative Analyst reporting to the Senior Manager, Freight & Distribution. This vacancy is a 12-month contract opportunity. The position involves analyzing freight shipments from initiation to payment, including tasks such as creating delivery and shipment documents, generating reports, managing payment systems, and assisting carriers with reconciliation and accessorial charges.

Location

Our Corporate Office is located in Bolton, ON. This is a field-based role with visits to the office on an as-needed basis.

 

What You'll Be Doing

  • Manage emails in multiple shared inboxes, sorting by issue type (e.g., statements, short payments, fuel surcharge inquiries, missed invoices) typically handling 50 to 70 emails per day.
  • Retrieve statements and remittances and understand various Sales Order and Purchase Order types for accurate shipment costing.
  • Ensure correct data entry for shipments and accurate addresses and vendor/carrier information for each company code.
  • Review daily reports to identify completed shipments awaiting transfer and follow up with the warehouse as needed.
  • Generate monthly reports for various freight movements and month-end analyses of fuel prices, create Ad-hoc reporting on freight transactions as required. 
  • Determine pricing by understanding logistics documents to identify issues causing incorrect shipment costs, and follow up with relevant parties to make necessary corrections for payment.
  • Use SAP transactions to analyze shipment details and assess cost relevance, identifying reasons for unpaid freight to explain to carriers or sites.
  • Processing of invoices not tied to shipments in SAP, including cost center and GL breakdowns.
  • Identify reason code for each entry to reconcile charges.
  • Manually create packages for logistics’ approval, including invoice, bill of lading, back-up documentation, payment history and correspondence.
  • Investigate and communicate disputes with carriers by Freight or Distribution Managers as needed.
  • Perform other related duties and projects as assigned.

Who You Are - Your Knowledge, Skills & Experience

Education

  • Post-Secondary education in Business Administration or Accounting

Experience

  • 3+ years experience working in Accounts Payable admin role or similar
  • Previous experience related to Freight/Logistics on a National scale would be an asset
  • Experience in SAP or an ERP would be an asset
  • Operations experience in a Distribution Centre would be an asset

Skills

  • Advanced Microsoft Excel skills (look ups, pivot tables, experience with complex spread sheets)
  • Extensive knowledge of Outlook, Word, Adobe, Teams, MFA (Manual Freight Adjustments)
  • Excellent problem-solving and analytical skills
  • Strong attention to detail with an ability to identify anomalies in large data sets
  • Demonstrates positive interpersonal skills with peers, leaders, internal and external customers
  • Excellent levels of communication both verbal and written
  • Ability to work efficiently both in a team setting and individually
  • Ability to look for patterns in the data, identify gaps and make recommendations

Compensation

Salary range? Yup, we’ve got one: $24.36 - $30.46 CAD per hour. But here’s the real deal - if you’re the perfect brew of experience, skills, and personality, we’re open to exploring beyond the range. Tell us what you’re working with, and let’s pour over it together.

What We Offer

Our success as an organization is a result of our commitment to our greatest strength…our people! We believe that any opportunity we can provide to help further your career growth and development is an investment in not only your individual success, but our overall success as a business. 

 

We work to recognize you in meaningful ways including a competitive compensation, a health benefits program, employee & family assistance program, recognition programs, hybrid work arrangement, summer hours, employee special offers, and a casual dress and work environment.

 

*Benefits and perks are dependent upon role and status and are subject to change at the sole discretion of the company. 

Equal Opportunity Employer

We are committed to providing a respectful and empowering workplace that values our greatest resource, our people. Diversity, Equity, Inclusion & Belonging are essential components of our culture that empower us to meet the needs of our employees, customers and communities. We welcome applicants from all backgrounds including racialized persons / persons of colour, women, Indigenous / Aboriginal People of North America, persons with disabilities, 2SLGBTQIA+ persons, and any other characteristic. We’re an equal opportunity employer and provide employment accommodation in accordance with provincial legislation. If contacted for an employment opportunity or testing, please advise Human Resources if you require accommodation at any stage of the recruitment process.

 

We genuinely thank you for your interest in this opportunity with us. Due to the high volume of applications we receive, only applicants selected for an interview will be contacted.