Revenue Assurance Technical Specialist at Cell C

Main Responsibilities

Data Science

• Identify valuable data sources and automate collection processes
• Undertake preprocessing of structured and unstructured data to discover trends and patterns
• Build predictive models and machine-learning algorithms to automate processes
• Combine models through machine learning, AI, etc
• Present information using data visualization techniques

Dashboard Development and Maintenance 

• Design, develop and deliver revenue assurance solutions such as reports, cubes, dashboards, ad hoc data access solutions using best practices
• Understand data and data mart models as well as become familiar with the business information contained in each as well as the source systems
• Work closely with analysts and user representatives for technical delivery of reporting solutions
• Debug report issues by analyzing the data sources and SQLs to provide quick resolutions
• Participate in requirement gathering sessions, produce necessary design, development, and testing documentation
• Review designs, code and testing with the project team as appropriate
• Analyze requirements, assess current state as well as strategic goals and devise plans for delivering the most appropriate solution
• Management of the reporting data marts, that is, ensuring that they are updated continuously and that they contain relevant information- Dashboards (sufficiently summarized for use for reporting)
• Closely work with DBAs to fix performance bottlenecks in reporting
• Support and administer existing revenue assurance dashboard 
• Propose improvements in existing revenue assurance dashboard
• Create data reporting solutions and implement reporting standards 

Reporting and Analysis 

• Prepare written reports on a monthly basis or as required 
• Relate information across a number of dimensions, highlight areas of interest for the business, and apply the correct measurements and analysis techniques
• Provide oral presentations of statistical or technical scientific information to inform and report on the progress of data collation and integration 
• Provide information at sufficiently summarized level for business management analysis, planning and control.
• Develop tools, templates and processes to assist in automation of workflow.
• Use investigative techniques in order to analyze business questions
• Identify the source of information, extracting and analyzing into a report, and presenting findings to the business
• Extract, organize, clean, structure data to provide reliable and timely information 
• Collating and integrating data for reporting purposes 
• Develop operational procedures for the extraction, editing, verification and management of statistical data 

Qualifications

• GSM Certification preferred 
• Degree (BCom/BSC) or IT Degree/Diploma

Experience

• 2 + years’ experience within a Global System for Mobile environment
• Strong IT systems experience
• 2 + years’ experience in a software development environment
• Experience in Application and Web Servers (Apache, Tomcat, SUN etc.)
• 2 years’ experience in data architecture design
• A working knowledge of the following;
• J2EE (EJB/CMP, JMS, JSP, JNDI, JDBC)
• XML (XSL/T, Xpath) HTML and Web Services (SOAP)
• RDBMS and SQL (SQL Server, Oracle, MySQL), and Store Procedures
• Linux, Red Hat, Ubuntu knowledge
• Python, Java, .NET, PHP programming
• Good knowledge of SAS, SQL and other analytical tools
• Excellent knowledge of MS Office (Word, Excel and PowerPoint).

Essential knowledge:

• Revenue Assurance & GSM Fraud
• Computer literacy at an advanced level