An exciting new role has become available for a Revenue Assurance Technical Specialist. The purpose of the position will be to design data modeling processes to create algorithms and predictive models and perform custom analysis. In addition, the Revenue Assurance Technical Specialist will be developing and supporting dashboard\tools assist the Revenue Assurance Division to reduce the company’s revenue exposure, as well as building AI/ML tools that automate certain processes within the function.
Duties and Responsibilities:
- Identifying valuable data sources and automating collection processes
- Undertaking preprocessing of structured and unstructured data to discover trends and patterns
- Building predictive models and machine learning algorithms to automate processes
- Combining models through machine learning, artificial intelligence (AI) and related technologies
- Presenting information using data visualisation techniques
- Designing, developing and delivering revenue assurance solutions such as reports, data cubes, dashboards and ad hoc data access solutions using best practices
- Understanding data and data mart models and becoming familiar with the business information contained in each as well as the source systems
- Working closely with Analysts and User Representatives for the technical delivery of reporting solutions
- Debugging report issues by analysing data sources and SQL to provide quick resolutions
- Participating in requirement gathering sessions and producing necessary design, development and testing documentation
- Reviewing designs, code and testing with the Project Team as appropriate
- Analysing requirements, assessing current state and strategic goals and devising plans for delivering the most appropriate solution
- Managing reporting data marts by ensuring they are continuously updated and contain relevant information and dashboards that are sufficiently summarised for reporting
- Working closely with Database Administrators (DBAs) to fix performance bottlenecks in reporting
- Supporting and administering existing revenue assurance dashboards
- Proposing improvements in existing revenue assurance dashboards
- Creating data reporting solutions and implementing reporting standards
- Preparing written reports on a monthly basis or as required
- Relating information across multiple dimensions, highlighting areas of interest for the business and applying the correct measurements and analysis techniques
- Providing oral presentations of statistical or technical scientific information to inform and report on the progress of data collation and integration
- Providing information at a sufficiently summarised level for business management analysis, planning and control
- Developing tools, templates and processes to assist in the automation of workflows
- Using investigative techniques to analyse business questions
- Identifying sources of information, extracting and analysing data into reports and presenting findings to the business
- Extracting, organising, cleaning and structuring data to provide reliable and timely information
- Collating and integrating data for reporting purposes
- Developing operational procedures for the extraction, editing, verification and management of statistical data
Minimum Requirements:
- GSM Certification and an IT Degree or Diploma
- At least 2 years’ experience within a GSM environment
- Strong IT systems experience
- At least 2 years’ experience in a software development environment
- Experience in application and web servers (Apache, Tomcat, SUN etc.)
- At least 2 years’ experience in data architecture design
- Working knowledge of J2EE (EJB/CMP, JMS, JSP, JNDI, JDBC)
- Working knowledge of XML (XSL/T, Xpath) HTML and Web Services (SOAP)
- Working knowledge of RDBMS and SQL (SQL Server, Oracle, MySQL) and stored procedures
- Working knowledge of Linux, Red Hat and Ubuntu knowledge
- Working knowledge of Python, Java, .NET and PHP programming
- Good knowledge of SAS, SQL and other analytical tools
- Excellent knowledge of Office (Word, Excel and PowerPoint)
- Strong knowledge of revenue assurance and GSM fraud