Job Title: Distributor Incentives Analyst
Department: Sales and Distribution
Location: Lagos
Job Description:
* Maintain, update and review a commission utilization database for all credit distributors to ensure a timely offset of utilized commissions.
* Reporting on Trade Partner sales activities and Trade Partner commission position for profitability
* Interprete, analyze and design templates for processing Trade Partners’ commissions and other incentives based on subsisting Discount Annexure.
* Liaise with BI-EDW team for documentation and maintenance of a comprehensive data base of MSISDNs qualifying for special commissions and incentives and carry out necessary reconciliation
* Analyze and validate reports from BI-EDW to ensure data integrity for completeness and accuracy
* Partake in all projects and business modeling to put in place a system for enhancing and generating reports for all commissions and other incentives
* Design report specifications for new commission approval and template for processing corporate client’s commissions and other incentives
* Analyze Trade Partner commission trend performance in line with the projection and advise the regions
* Relationship management and resolution of distributors’ queries relating to commissions and other incentives
* Reporting functions including trend analysis and effective discount analysis etc.
* Reconcile and validate all monthly ongoing revenue service commission (ORSC) payable
* Analyze and propose accounting treatment including accruals for all Trade Partners’ commissions and other incentives
* Participate in all business intelligence (BI) projects to put in place a system for generating reports for all commissions and incentives.
* Analyze and provide over and under accrual reports for commissions and other incentives on a monthly basis
* Maintain an updated reconciliation report of accruals/actual payment posted in the general ledger.
* Market intelligence gathering to monitor the trade partners compliance and behaviours
* Collate, check and analyze regional reports data on trade partners performance
* Review and Analyze commission/incentive across the telecoms industry
Job Conditions:
* Standard MTN working conditions
* May work extended hours
Reporting To: Sales Analysis and Reporting Manager
Required Skills:
* 4 years working experience in a commercial environment
* Data mining and analysis experience
* Expertise in the use of Microsoft Excel, Microsoft power point, ACL and other data processing tools
Employment Status: Permanent
Qualification:
* First degree or equivalent in Accounting/Banking and Finance
This vacancy expires on 10/20/2010
To apply, goto:
http://careers.mtnonline.com/vacancies.asp?deptid=10&id=1518
