Position Summary:

Precision Parcel & Package Deliveries (a division of ASL Distribution), is looking for a Finance Coordinator to start immediately, this is a Temporary to Permanent position for the right candidate.

We are looking for a self-motivated and professional individual, who will report directly to the Finance Manager

Experience working in Accounting, Finance, Administration or related field

Experience with pivot tables, pivot charts, solver, vlookup, xlookup, countifs, index match, macros, conditional formatting, what if analysis, visual basic, SQL is an asset

Key Responsibilities:

Review and verify data received for any errors and omissionsAdd additional data into excel files and verify all data is correctGenerate customer invoices through excel or macros Keep track of all invoices sent in customer foldersVerify invoice discrepancies and resolve client billing issuesCorrespond with customers and respond to inquiriesPrepare payment files for processing and send to payments departmentKeep track of all payment files sentResearch and resolve any payment discrepancies Correspond with vendors and respond to inquiriesPrepare summaries, reconciliations, audit reports for internal managementCorrespond with internal departments and respond to inquiriesAssist with month-end tasks and special projectsOther responsibilities as assignedMonday-Friday 8:30am - 5pm

Required Qualifications and Competencies:

Diploma or degree in Accounting, Finance, Business Administration or combination of comparable skills and experienceMinimum 1 year experience Experience in MS Excel including pivot tables and charts, vlookup, xlookupStrong attention to detail and accuracy is a mustExcellent organizational and time-management skillsEffective communication abilities, both verbal and writtenStrong solutions-oriented mindset, with the ability to problem-solve, adapt and pivotMaintain high levels of confidentiality and demonstrate integrity and accountabilityProficiency in data management, analysis, and reportingAbility to work independently and as part of a team in a fast-paced environmentProven ability to exercise diplomacy, professionalism and good judgment

Not Required but are definite assets:

Experience in creating, running, and troubleshooting macros to automate repetitive tasks, streamlining data processing, and enhancing reporting efficiencyExperience with Excel’s advanced data manipulation tools, such as Power Query, to efficiently handle large and complex datasets Proficiency in SQL for querying and manipulating large datasets Familiarity with data warehousing, ETL processes, and data management best practices Experience with Power BI Experience with visual basic