Senior Analyst - Dealer Commissions Analytics Johannesburg, South Africa Dealer Commissions 2 P ...

Senior Analyst - Dealer Commissions AnalyticsJohannesburg, South Africa 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: Closing date for Applications: 13 April 2026. 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 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 companiesTop skillsFinancial ModelingFinancial AnalysisFinance1. Analyst2. Senior Analyst3. Business Intelligence Analyst4. Lead Analyst5. Business Analyst