Job Description

Summary

This role will be a part of Grid Automation (GA) North America Region (NAM) finance team. The successful candidate will be responsible for maintaining integrated reports to identify GA NAM region opportunities for duty refund monthly, collaborate with operations team to process the refund, track refund claim status, spot payments in the bank, and ensure cash is applied correctly and appropriate financial postings are completed. Through integrated reporting and tracking tools, the successful candidate will also support the analysis on tariff impact for GA NAM and cost recovered through refunds.
This full-time role will be based in our office in Markham Ontario, the successful candidate will be expected to work onsite in our Markham office Monday-Thursday each week.
Essentials Responsibilities

• Obtain USCBP ACE report and broker reports from multiple sources and integrate into one central report on a monthly basis
• Identify shipments where duty payments were high to target for refund claims under USMCA agreement
• Collaborate with operations team to ensure appropriate prioritization of refund claims based on value and due date
• Track and update claims submitted until refund is received
• Ensure refund payment is received in bank, cash applied, and appropriate P&L posting takes place
• Support tariff's impact assessment and reporting on cost recovered through refunds
• Support reconciliation and tie out on CTSI freight postings
• Track and analysis NAM region freight costs, support the development of standardized freight charges for various products
• Support finance closing activities during monthly and quarterly closing

Required Qualifications

• Proven organizational skills and demonstrated ability to be detail oriented
• Expertise in MS Excel and comfortable working with large dataset
• Experience building integrated report using PowerBI
• Experience with SAP ERP systems
• Ability to work with complex dataset and display analysis in a impactful way
• Demonstrated ability to work with minimum supervision
• Bachelor's degree
• Prior work experience working in a matrix environment
• Have legal authorization to work in Canada and be aware that any offer of employment is conditioned upon the successful completion of a pre-employment verification

Additional Information
Relocation Assistance Provided: No

Skills Required