Commercial Data Analyst with Power Query

INDIRECT SALES REPORTING CONTROLLER

Diversey is looking for an;

INDIRECT SALES REPORTING CONTROLLER - with POWER QUERY (definite period of 1 year)

Aim of this job: process ISR data (indirect sales reporting and Ship Through rebate payments) process end to end according the distributor / end customer contracts

Role:

- Manage ISR (indirect sales reporting) process end to end

- Recording and maintenance of contracts in the IT system

- matching of indirect data (customers / materials / contract data) to Diversey master records

- Support business with uploading the indirect sales data into our sales reporting system

- Calculate Ship Through payments for Distributors and review existing Ship Through calculations for accuracy.  

  Ensure we pay the contracted amount of Ship Through rebate only.

- Review Ship Through calculation with Sales and Distributors

- Clarification of differences and removal of unjustified support requirements

- Clarification of inconsistencies in connection with the contracts with sales representatives and internal sales

- Track the loading and the payments in an ISR tracker to have a good overview of the status to give

  reliable information to sales

- Ensure documentation of customer contract, customer pricing and Ship Through payments in order to satisfy audit needs

- Determination, reconciliation and posting of advance payments to specialist wholesalers

- Support the business with the price increase for indirect customer contracts

- Ensure clear communication with sales, finance, distributor and end customers (if needed) about ISR and Ship Through

- Continuously improve and harmonize the ISR process

- Work closely with Sales to drive simplification

- Work closely together with other relevant departments  

Qualifications:

- Business graduate from university  or equivalent qualification.

- Financial or Accounting qualification  beneficial

- 2-3 years experience in Customer Service / Backoffice or Finance function

- Basic accounting understanding

- High numeracy skills

- Professional user of Excel, Google documents, Word

- SAP knowledge is advantage (customer master data, pricing, rebate, AR)

- Fluent English

- Good team player, good communication skills (verbal and written)

- Logical thinking, precise

- Able to take responsibility

-Decisive, to be able to decide alone

- Able to handle the full process

Requirements

Key Competencies:

High level of competence within Power Query

Functional/ technical skills

Managing through systems

Integrity & Trust

Drive for results

Customer focus

Priority setting

Organisational Savvy

Decisive

Strong personality

Business acumen

Listening

Informing

Dealing with ambiguity

Managing and measuring work

Other skills required:

- Good communication skills

-High level of numeracy

-'hands-on, can do' person that is not afraid to make his/her hands dirty and take on difficult issues both

Benefits

RON 14,630 plus meal vouchers

There is potential for this role to extend beyond the initial 12 month contract.