Finance Coordinator (Precision Parcel and Package)
About the role
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
rk4EfZdsJ0
About Challenger Motor Freight Inc
Challenger is a North American leader in the supply chain industry and has been since its inception in 1975. The Challenger Group employs more than 2,000 people and operates approximately 1,500 trucks and 3,300 trailers. As one of the largest privately owned truckload carriers in Canada, Challenger has been consistently recognized by its customers and within the industry for the outstanding quality of its services.
This year, Challenger was once again given the honour of being recognized as one of Canada’s Best Managed Companies, and has been a Platinum member since 2007. Challenger is an active leader in many significant green initiatives, including LEED certification of their headquarters and SmartWay Transport partnership.
In addition to our state of the art HQ facilities in Cambridge, Ontario, the Challenger Group has facilities in Montreal, Toronto, London, Mississauga, Vancouver, Calgary, Winnipeg, and Edmonton, Chicago and Long Beach.
Finance Coordinator (Precision Parcel and Package)
About the role
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
rk4EfZdsJ0
About Challenger Motor Freight Inc
Challenger is a North American leader in the supply chain industry and has been since its inception in 1975. The Challenger Group employs more than 2,000 people and operates approximately 1,500 trucks and 3,300 trailers. As one of the largest privately owned truckload carriers in Canada, Challenger has been consistently recognized by its customers and within the industry for the outstanding quality of its services.
This year, Challenger was once again given the honour of being recognized as one of Canada’s Best Managed Companies, and has been a Platinum member since 2007. Challenger is an active leader in many significant green initiatives, including LEED certification of their headquarters and SmartWay Transport partnership.
In addition to our state of the art HQ facilities in Cambridge, Ontario, the Challenger Group has facilities in Montreal, Toronto, London, Mississauga, Vancouver, Calgary, Winnipeg, and Edmonton, Chicago and Long Beach.