BI / CVM Manager at Smartcash PSB

About the job

• To provide timely, accurate, and focused information to the Smartcash 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

Manage Smartcash 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 Smartcash 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 Smartcash 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.
• Analyze competitive market strategies through analysis of related product, market, or share trends.
• Establish an analytics capability to proactively identify opportunities for business units to efficiently leverage data. Working in conjunction with the team, he /she will develop the strategy and roadmap of the BI and analytics platform, and drive the features and functions necessary to deliver the insights needed for evolving business needs.

Provide reports for executive management business reviews

• Extract data and provide reports on Smartcash Customer Base, Agent base, product performance growth and Revenue Growth
• Prepare quarterly Smartcash 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 Smartcash 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 Smartcash 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.
• Smartcash 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.

Data Mining

• Construct data extraction queries, reports and automations to ensure compliance with quality standards and established methods for business reporting and decision support.
• Extract useful information from large data sets or databases
• Take ownership of production and testing of data operations reports using provided data sources and tools (SQL Server, Power Query, and Power Pivot.)
• Work with data and product owners to verify and obtain approval that any transformed data retains its accuracy.
• Execute one off data extraction and manipulation jobs as required.
• Ensure that any data integrity issues are reported immediately and summarized weekly to management and others authorized to receive this information.

Support development implementation of Smartcash 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.

Demonstrate (Key competencies)

Key Performance Indicators:

• 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

Qualifications

• Bachelor's or HND Degree in Computer Science/IT or related field

Relevant Experience

• 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.