Revenue Assurance ETL Developer, Data Integration & Analysis Specialist

WFO Roedl & Partner, on behalf of its client, is recruiting suitably qualified candidates to fill the position below:

Job Title: Revenue Assurance ETL Developer, Data Integration & Analysis Specialist

Location: Lagos

Role Summary/Purpose

• Support initiatives for day-to-day revenue assurance operational activities to identify and prevent revenue leakage, reduce cost, increase revenue and mitigate risks.

Essential Responsibilities
The successful candidate will be accountable for the following:

• Ensure accuracy & integrity of data & applications through analysis, coding, writing clear documentation & problem resolution.
• Analyze & translate functional specifications & change requests into technical specifications.
• Develop, test & implement program logic.
• Work with ETL tools, such as kettle, Informatica.
• Translate business needs into end user applications.
• Design, develop & test large-scale ETL application for data warehouse/Revenue Assurance application.
• Take handover and carry out effective transition of projects from implementation to support.
• Fix the gaps of the delivery or cases that are missed out at the time of UAT.
• Helping business in the exception analysis of reconciliation to find out the exact cause of mismatch and work accordingly to fix it.
• Providing Root Cause Analysis and recommendations to reduce mismatch in reconciliations.
• Automation of all the monitoring processes through scripts.
• Work closely with the offshore development team to deliver projects on time and in a high-quality manner and bring the product bugs and change requests into product enrichment propositions.
• Requirement gathering, Impact analysis and High/Low level documentation.
• Meeting with stakeholder teams to understand their needs and proactively provide quality inputs based on trends and data analysis.
• Perform control of all revenue streams to guarantee timely, complete and correct charging of the services provided (reconciliations related to various billing platforms, switch data, and customer databases).
• Ensure cross-departmental co-ordination of RA activities and prompt escalation of material incidents; analyses and follow up on RA incidents until resolution as well as definition of measures to prevent occurring that error scenario in the future.
• Provide an independent and comprehensive monthly reporting.
• Perform analysis, research and process documentation of the processes for Revenue Assurance and identify necessary control point.
• Perform data analysis of revenue assurance controls, quantify and communicate the impact/risk of issues,
• Perform root cause analysis and drive resolution cross-functionally within the organization.
• Identify and define system/process requirements necessary to control and resolve revenue leakage/opportunities.
• Setting up new and enhance existing controls to mitigate the risks associated with it.

Qualifications

• University Degree in Finance, Engineering, IT or other related fields
• Relevant IT Certifications
• ACA/ACCA/Part Qualified Chartered Accountant

Essential Requirement
The primary skills required for this role are revenue assurance, open source ETL development, data integration and analysis, application support & maintenance, in addition to:

• Financial, Technology and Operational background.
• 4-6 years' experience in revenue assurance / Technical scripting for large data base in a telecommunication / solution management company.
• Ability to develop and run queries and conduct complex data analysis required
• Project management experience.
• Attention to details, financial intelligence and Process orientated.
• Ability to multi-task effectively, very Strong analytical and problem solving skills.
• Excellent, clear verbal and written communication and reporting skills
• Desired SQL Skills - Excellent in Unix, Windows, SQL Server and Oracle. Excellent knowledge of SQL with the ability to create SQL queries
• Advanced PC skills with Microsoft Excel and Access. Excellent knowledge of data analysis/query tools.

Desired Characteristics

• Telecommunications experience
• Good knowledge of technology and business operations in 3G and 4G/LTE networks.
• Confident to manage, synthesize and influence in a cross functional environment.
• Experience in Revenue Assurance / Fraud Management with Telecom Operator.
• Translating business needs into end user apps (2 years)
• Designing, developing & testing large ETL application for data warehouse application (3 years).
• Good knowledge of open source applications like Informatica, Pentaho/Kettle, Talend, Scriptella (1 year)