Airtel Money BI & Reporting at Airtel Tanzania

At Airtel Africa, we act with passion, energy, and a can-do attitude. Innovation with an entrepreneurial spirit drive us. If you like “ordinary”, then we are not for you.

We champion diversity. We anticipate, adapt, and deliver solutions that enrich the lives of communities we serve. we roll up our sleeves to win with our customers.

By choosing Airtel, you choose to be part of a winning team. All this in addition to a brilliant opportunity to build a career in your field of expertise, across our different operating companies in Africa.

Airtel Africa is proud to be an equal opportunity employer and remain fully committed to diversity and inclusion in the workplace.

Responsibilities

Manage Airtel Money Business reporting, BI & Market Intelligence

• Create business intelligence tools or systems, including design of related databases, spreadsheets, or outputs and maintain or update Airtel Money business intelligence tools, databases, dashboards, systems, or methods
• 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
• 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 Airtel Money business performance, most often using data that has been gathered into a data warehouse or a data cube and occasionally working from operational data
• Analyze competitive market strategies through analysis of related products, 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 Airtel Money Customer Base, Agent base, product performance growth and Revenue Growth
• Prepare quarterly Airtel Money reports for presentation to the Airtel Tanzania 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 Airtel Money 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 Airtel Money Commercial teams visibility on business performance

• Bring greater business visibility and insight to the broadest audiences of business users – business development(C2B, B2C, Mobile banking, B2B, consumer products(Cash In, Cash Out, P2P, Airtime Purchase, Data Bundles Purchase, Loans, Card), enterprise sales teams(corporate and merchant account performance), allowing any user in the organization to have we-based self-service access to up-to-the moment, relevant, and actionable intelligence
• Generate customer and product reports providing technical support for existing reports, dashboards, or other tools
• Airtel Money 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 queries 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 Airtel Money 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 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
  

Team & Stakeholder Engagement

• Prepare presentations on monthly performance for Sales and Distribution
• Manage timely flow of business intelligence information to users.
  

Qualifications

Educational Level

• Bachelor’s degree in computer science/IT or related field and MBA

Relevant Experience

• At least 4 years’ experience in service reporting tools like Oracle Business Intelligence Enterprise Edition, Oracle Discoverer
• At least 3 years’ experience in Planning and Reporting
• Strong Business Knowledge - Must have exposure to telco BI and Planning preference will be given to candidates with Mobile Money Knowledge.