Junior Analyst Mills - Logistics (6 month contract)

at  Atlantic Packaging Products Ltd

Scarborough, ON, Canada -

Start DateExpiry DateSalaryPosted OnExperienceSkillsTelecommuteSponsor Visa
Immediate26 Nov, 2024Not Specified31 Aug, 2024N/ATime Management,Power Bi,Numbers,Databases,Coding ExperienceNoNo
Add to Wishlist Apply All Jobs
Required Visa Status:
CitizenGC
US CitizenStudent Visa
H1BCPT
OPTH4 Spouse of H1B
GC Green Card
Employment Type:
Full TimePart Time
PermanentIndependent - 1099
Contract – W2C2H Independent
C2H W2Contract – Corp 2 Corp
Contract to Hire – Corp 2 Corp

Description:

REQUIREMENTS:

  • Proven track record of working with Power BI
  • Coding experience an asset
  • Energetic, proactive problem-solver and a team player in a fast-moving environment
  • Excellent time management, communication & organization skills
  • Skilled in Dashboarding (Power BI), PowerQuery, DAX etc.
  • Experienced in building, managing databases along with complex querying capabilities (nice-to-have) and TMS-WMS experience (nice-to-have)
  • Trained in Quantitative disciplines e.g. Computer Science/Engineering/Accounting with interest in numbers and minute attention to detail is a must
  • Looking for a positive, organized team worker with a re-engineering and continuous improvement attitude

Responsibilities:

  • Thorough experience in automating Data Pipeline, Data Cleansing using DAX, Power Query
  • Proficiency in automating repetitive tasks using power automate
  • Populate/Maintain the database of the paid/unpaid invoices, processed from Mills end
  • Reconcile paid/unpaid invoices list everyday to maintain data integrity in Atlantic’s systems
  • Resolve problems related to the shipping/commercial documents and correct the information in ERP/Applications
  • Ensure invoice data, price data have no discrepancies within the database, invoices and the ERP
  • Communicate with vendors for collecting invoices, PODs & Statements
  • Coordinate with other departments to make sure invoices are payment-ready
  • Validate the hand-written timesheets against the ERP data and ensure correct data sent to the vendors &/or other stakeholders
  • Work with shippers to source/record freight rates, weights, axles, date etc. & ensure carriers are following the requirements including Proforma
  • Process freight invoices from carriers. Prepare freight invoices (after thorough checking) to be paid
  • e-mailing notifications, price advisories, memos/letters, outstanding reports, spreadsheets recording rates/shipping points and/or warehouse activity, as well as other misc. information.
  • Assist in resolving invoicing issues and coordinating to resolve the issue proactively
  • Creating, tracking and maintaining various reports for statistical, and quality purposes
  • Other duties as instructed by the supervisor or the team lead


REQUIREMENT SUMMARY

Min:N/AMax:5.0 year(s)

Information Technology/IT

IT Software - Other

Other

Graduate

Proficient

1

Scarborough, ON, Canada