Atlantic Packaging Products Ltd -
59 emplois
Toronto, ON
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
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