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