Commissions and Rebates Analyst

Industry Category	Sciences	Position	Actuarial / Statistics
Recruitment Department		Number Of Recruits	several
Work Location	Metro Manila (NCR) Taguig	Nature Of Work	Full Time
Gender Requirements	Male	Marriage Requirement	No marital status restrictions
Education Level	Open to all levels	Work Experience	No work experience restrictions
Age Requirement	Above 18 years old	Salary Package	Negotiable
Updated Date	2022-10-19	Valid Until	Long-term validity

Plan, propose and deliver active commercial management to Canon Business Services (CBS) to assist with achieving sustainable growth in line with the overall business strategy. 

Provide commercial advice and support to the CBS Sales & Marketing teams ensuring that accounting transactions are correct and entered into the system on time, accurately reflecting the CBS business. 

Essential Duties:

Commercial 

Calculate and process commissions using the commission calculation tools (MS Excel and MS Access). Maintain the sales organisational hierarchy, and make any changes to hires, terminations, or compensation plan changes within the Commission Calculator. Provide Commercial insights into the monthly commission payments by analysing sales performance at an Account Manager, Product and Channel perspective. Contribute to achieving CBS overarching goals. 

Budget Preparation 

Provide commissions input to the annual and quarterly budgeting processes. 

Decision Support through Information Analysis 

Provide Commission expertise, planning, insights, commercial analysis and decision support to the Sales & Marketing teams in CBS Act as a focal point for issues and queries for the business regarding commissions. Improve management decision making through commercially sound and insightful analysis. Provide decision support tools to management. 

Operational Excellence and Change Management 

Identify and implement process improvements to improve customer satisfaction and / or reduce costs. Maintain effective financial accounting within CBS. Preparation of month end commission accruals. Preparation of month end rebate accruals. Improve performance through continuous end to end process improvement. Ensure relevant provisions and accruals are maintained accurately. Provide or assist in the creation of tools to support business processes. Active governance and operational excellence in all processes owned by the team. 

Process 

Develops and evaluates processes to improve report management and ensure data integrity. Identifies and assists with the rectification of any incidental operating issues to ensure the best possible performance of the division. Minimise manual system interaction. All system interfaces to be automated where and whenever possible. CBS demonstrates best process practices within Canon. 

Monthly Reporting 

End of month unit reports to third party marketing companies (IDC + Informark). Average Cost/Selling Price files to marketing and commercial teams. Daily Sales reports/Performance to target reports to Sales and Marketing teams. Ad hoc analyses as required. Apply opportunities for continuous improvement of reporting function. 

Qualifications:

Minimum of 2 - 3 years relevant professional experience Tertiary qualifications in Computing and/ or Mathematics. Proven experience in a time critical analytical role (ability to meet strict deadlines). Advanced MS Access skills - Ability to import and export data, write complex SQL queries and macros. Advanced MS Excel skills - Ability to create complex formulas, manipulate pivot tables and create macros. Ability to work independently and as part of a team. Ability to problem solve and troubleshoot with elements of ambiguity Excellent communication skills (assertiveness/confidence) Good rapport with internal and external customers. Strong knowledge in ERP Financial System, Financial Modelling and, MS Visual Basic