BI/CVM Manager-Smartcash PSB at Airtel

Job Description

• To provide timely, accurate, and focused information to the Smart cash leadership. Develop and implement effective business and commercial reports to deliver improved decision  making, Guide Pricing Decisions and Coordinate Planning.
• Develop a framework for commercial processes & Support the Senior Leadership of Smartcash in tracking routine divisional objectives. 
• Provide all Smartcash leadership with the highest standard in development, implementation  and support of reports to meet user reporting requirements and incidents associated with the  content of access to or generation of the reports, thereby ensuring availability, completeness,  accuracy and timeliness of the same reports.

Responsibilities

Support development implementation of Smart-cash report automation:

• Lead the development and integration of data across the organization including the production, identification, and extraction of data from source systems, the transformation and loading of data into databases. 
• Data Modeling, Dimensioning and New Reports Development in line with reporting requirements adhering to the processes, and ensuring the completeness, timeliness and accuracy of standard daily, weekly and monthly reports; as well as ad hoc reports. 
• Work closely with the Airtel BI partners and vendors’ team to ensure that all ongoing development meets the business user requirements. 
• Work closely with colleagues within IT and business planning and within the business to ensure consistency in data definitions and data usage. 
• Establish and maintain policies and standards to guide data usage, storage, retention and development of definitions.
• Analyze and Simulate and Account for trends and Gaps in data provided and advise the business accordingly.
• Document specifications for business intelligence or information technology (IT) reports, dashboards, or other outputs.

Manage Smart cash Business reporting, Pricing & Market Intelligence:

• Identify and analyze industry or geographic trends with business strategy implications regularly updating management on market and competitor activities and products and will be Responsible for AM Planning, pricing and promotional strategies.
• Create business intelligence tools or systems, including design of related databases, spreadsheets, or outputs and maintain or update Smart cash business intelligence tools, databases, dashboards, systems, or methods.
• Collect mobile money business intelligence data from available industry reports, public information, field reports, or purchased sources. 
• Synthesize current business intelligence or trend data to support recommendations for action.
• Provide historical, current, and predictive views of Smart cash business performance, most often using data that has been gathered into a data warehouse or a data cube and occasionally working from operational data. 
• Communicate with customers, competitors, suppliers, professional organizations, or others to stay abreast of industry or business trends.

Provide reports for executive management business reviews:

• Extract data and provide reports on Smart-cash Customer Base, Agent base, product performance growth and Revenue Growth.
• Prepare quarterly Smart-cash reports for presentation to the board, monthly reports for Group business reviews including customer market share, agent market share, transaction volume share, transaction value share and market revenue share. 
• Analyze Smart-cash weekly Key Performance Indicators (KPI) highlighting reasons for growth or decline on the strategic business KPIs.
• Generate standard or custom reports summarizing business, financial, or economic data for review by executives, managers, clients, and other stakeholders.

Give Smart-cash Commercial teams visibility on business performance:

• Bring greater business visibility and insight to the broad audiences of business, allowing any user to up-to-the moment, relevant, and actionable intelligence. 
• Generate customer and product reports providing technical support for existing reports, dashboards, or other tools. 
•  Smart cash promotions & campaign tracking for respective product campaigns, customer acquisition initiatives, champion challengers, active customers tracking, product user profiling and segmentation.
• Actively work on routine and ad hoc data and business projects involving querying from the data warehouse.

Qualifications

• At least 3 years’ experience in service reporting tools like Oracle Business Intelligence Enterprise Edition, Oracle Discoverer.
• At least 3 years’ experience in hands-on experience in systems administration and IT supporting service including Data Warehousing as well as complex report formatting. 
• Business Knowledge - Business report formatting is an added benefit.
• Bachelor's or HND Degree in Computer Science/IT or related field.
• Databases: Oracle, MSSQL Server, PostgreSQL, MySQL. 
• SQL: PL-SQL, MS-SQL and PG-SQL.
• Reporting: Microsoft Power BI.
• Data Analysis: SPSS or R-Statistics.
• Strong analytical, problem solving and decision-making skills to evaluate alternatives and provide recommendations on business issues. 
•  Proficient in using Microsoft Offices Software.
• Proficient in using Microsoft Power Point Software.
• Insight gathering from reports and intelligence to improve customer retention and value extraction.
• Problem solving.