Analyst (Supplier Compliance, Promotions, Rebates, Pricing)

- Read and understand our client’s agreements with their suppliers in English (agreements can be within Emails, Business Contracts, Price Change Forms...)
- Using Excel and some SQL, perform analysis on the client’s transactional data (Accounts Payable, Invoice Details, Purchase Orders, Sales…)
- Compare the client’s transactional data with the client’s agreements to validate if all transactions have been paid correctly
- Identify any historical transactions have some sort of payment error (where the data does not match to the agreement)
- Create detailed reports in Excel to describe and calculate any payment errors identified
- Discuss your findings by e-mails or IM with the overseas project teams and customers located in Australia, New Zealand, etc.
- Using our tools and the available data/agreements, attempt to recover the missing monies from our client’s suppliers which would correct & resolve any errors identified
- Additional processing, transformation, and validation of data may also be required to assist with the analysis, recovery, and resolution of the errors
- Other assignments by line manager