Senior Analyst - Dealer Commissions Analytics

Job Description

When it comes to putting people first, we're number 1.

The number 1 Top Employer in South Africa.
Certified by the Top Employer Institute 2025

Role Purpose:

To manage all data required for the Payments and Claims Query Reporting when Vodacom’s goods and Services are sold to our subscribers

Your responsibilities will include:

Data Analysis & Reporting

• Analyze large datasets from multiple sources (e.g., billing, CRM, ERP) to extract financial insights.
• Develop and maintain financial dashboards and reports using Power BI and Excel.
• Automate recurring financial reports and ensure data accuracy and consistency.
• Perform variance analysis, forecasting, and budgeting support.
• To respect and maintain confidentiality of data.

Data Engineering & Management

• Design and maintain SQL-based data pipelines to support financial reporting needs.
• Ensure data integrity, quality, and governance across financial datasets.
• Collaborate with IT and BI teams to optimize data architecture and performance.

Finance Support

• Assist in month-end and year-end financial processes with data-driven insights.
• Support revenue assurance, cost analysis, and profitability tracking.
• Translate financial requirements into technical specifications for data solutions.

Trade Partner Support

• To carry out weekly TPI payments for all partner types and provide the necessary reporting thereof
• To resolve claim-related queries submitted by Trade Partners via Remedy
• To perform the weekly and monthly reporting as required for month-end purposes
• To timeously prepare, review and maintain all SOX-related controls/documents
• To manage ad hoc projects to drive automation within the Dealer Commissions environment

The ideal candidate for this role will have:

• Matric - essential
• A relevant Bachelor’s degree
• Professional certifications (e.g., Microsoft Power BI, SQL, CIMA/ACCA) are a plus
• 2-5 years of experience in SQL’s, Power BI and Financial/Data Modelling
• Must have Excel Advanced experience/qualifications
• 3 Years or more Reporting experience
• Experience in dealing with Internal and External Parties to resolve queries
• Experience in dealing with senior Execs & key stakeholders
• Experience in extracting data and organizing it in meaningful formats.

Job Knowledge:
• Reconciliation and Reporting Tools/Models
• MS Excel advanced – Power BI
• Eppix/Siebel/Infoweb - advantageous
• SQL’s – advanced
• Strong IT skills
• Database Understanding.
• Ability to work with large datasets.

Job Related Skills:
• Interpersonal skills
• Problem resolution skills
• Excellent communication skills – both written and spoken
• Time Management Skills
• Attention to detail

Technical Skills
• Advanced Excel (Power Query, PivotTables, VBA/macros a plus)
• Power BI (DAX, data modeling, dashboard design)
• Advance SQL (complex queries, sql tuning)
• Experience and knowledge with data warehousing/ETL processes
• Familiarity with cloud platforms (Azure, AWS, or GCP) is advantageous

Finance Knowledge
• Strong understanding of financial principles (P&L, balance sheet, cash flow)
• Experience working with finance teams or in a finance function
• Telecoms industry experience is highly desirable

Soft Skills
• Strong analytical and problem-solving skills
• Excellent communication and stakeholder engagement
• Ability to work independently and manage multiple priorities

We make an impact by offering:

• Enticing incentive programs and competitive benefit packages
• Retirement funds, risk benefits, and medical aid benefits
• Cell phone and data benefits, advantages fibre connection discounts, and exclusive staff discounts offered in collaboration with partner companies

Closing date for Applications: 19 August 2025.

The base location for this role is Midrand, Vodacom Campus.

The company's approved Employment Equity Plan and Targets will be considered as part of the recruitment process. As an Equal Opportunities employer, we actively encourage and welcome people with various disabilities to apply.
Vodacom is committed to an organisational culture that recognises, appreciates, and values diversity & inclusion