Junior Analyst Mills - Logistics (6 month contract)
at Atlantic Packaging Products Ltd
Scarborough, ON, Canada -
Start Date | Expiry Date | Salary | Posted On | Experience | Skills | Telecommute | Sponsor Visa |
---|---|---|---|---|---|---|---|
Immediate | 26 Nov, 2024 | Not Specified | 31 Aug, 2024 | N/A | Time Management,Power Bi,Numbers,Databases,Coding Experience | No | No |
Required Visa Status:
Citizen | GC |
US Citizen | Student Visa |
H1B | CPT |
OPT | H4 Spouse of H1B |
GC Green Card |
Employment Type:
Full Time | Part Time |
Permanent | Independent - 1099 |
Contract – W2 | C2H Independent |
C2H W2 | Contract – 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