Data & Analytics Assistant; Excel Guru

Our Client in the IT Industry, is seeking to employ a junior Data & Analytics Assistant (Excel Guru), to interpret complex financial and commission structures; based in Walmer Port Elizabeth.

Requirements:

• Advanced Microsoft Excel (pivot tables, VLOOKUP/XLOOKUP, SUMIFS, IF formulas, data validation).
• Experience with Power Query or Power BI (advantageous).
• Experience using internal CRM, ERP, or commission management systems.
• Strong data reconciliation skills.
• Ability to interpret complex commission structures.
• Ability to handle confidential financial information.
• Experience in commission analysis, finance, or data analysis.
• Experience working with large data sets.
• Experience in financial services, telecoms, or partner-based environments (advantageous).

Responsibilities, but not limited to:

Commission Processing

• Import, clean, and validate commission data from internal systems and external providers.
• Calculate monthly commissions based on agreed commission structures.
• Apply adjustments, overrides, clawbacks, and special incentive rules.
• Ensure timely and accurate commission payouts.

Data Management & Analysis

• Maintain and update commission calculation models in Excel.
• Perform reconciliations between internal systems and source files.
• Identify discrepancies and resolve commission disputes.
• Analyze commission trends and provide insights to management.

Reporting

• Prepare monthly commission statements for partners/sales teams.
• Generate management reports on commission expense and performance.
• Support finance with accrual calculations and forecasting.

System & Process Improvement

• Maintain internal commission systems and documentation.
• Improve automation within Excel (formulas, Power Query, pivot tables, macros if required).
• Assist with testing and implementation of new commission systems.
• Develop standard operating procedures for commission processing.

Compliance & Governance

• Ensure commission calculations comply with company policies and agreements.
• Maintain audit trails and supporting documentation.
• Assist with internal and external audits.

Please note that should you not receive a response within 2 weeks of applying, you may consider your application unsuccessful.