Job Description

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 omissions
• Add additional data into excel files and verify all data is correct
• Generate customer invoices through excel or macros
• Keep track of all invoices sent in customer folders
• Verify invoice discrepancies and resolve client billing issues
• Correspond with customers and respond to inquiries
• Prepare payment files for processing and send to payments department
• Keep track of all payment files sent
• Research and resolve any payment discrepancies
• Correspond with vendors and respond to inquiries
• Prepare summaries, reconciliations, audit reports for internal management
• Correspond with internal departments and respond to inquiries
• Assist with month-end tasks and special projects
• Other responsibilities as assigned
• Monday-Friday 8:30am - 5pm

Required Qualifications and Competencies:

• Diploma or degree in Accounting, Finance, Business Administration or combination of comparable skills and experience
• Minimum 1 year experience
• Experience in MS Excel including pivot tables and charts, vlookup, xlookup
• Strong attention to detail and accuracy is a must
• Excellent organizational and time-management skills
• Effective communication abilities, both verbal and written
• Strong solutions-oriented mindset, with the ability to problem-solve, adapt and pivot
• Maintain high levels of confidentiality and demonstrate integrity and accountability
• Proficiency in data management, analysis, and reporting
• Ability to work independently and as part of a team in a fast-paced environment
• Proven 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 efficiency
• Experience 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

Skills Required