Position Summary:
Precision Parcel & Package Deliveries (a division of ASL Distribution) is looking for a Finance Coordinator to start immediately. NEW GRADES are welcome to apply!!!
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 Excels 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
Required Experience:
Junior IC