Role Title: Reconciliation Analyst – M-Pesa and Government Integrated Systems
Function: IT & Billing
Sub-function: Intelligence and Data
Reports to: TEF Supervisor’

Role Purpose:
Conduct M-Pesa reconciliation, reviewing and resolving discrepancies across all internal and external accounts.
Perform daily reviews of data transmitted to government systems, reconciling and resolving discrepancies efficiently.
Core Competencies, Knowledge, and Experience:
Programming & SQL Knowledge: Proven ability to write and optimize SQL statements.
Attention to Detail: Strong focus on data accuracy and reconciliation.
Experience: At least two (2) years in the IT field.
Data Management: Expertise in working with large datasets in Management Information Systems (MIS) and integrating data sources via API or ETL processes.
Data Visualization: Proficiency in platforms such as Power BI.
Key Accountabilities and Responsibilities:
Data Reconciliation:
Review data transmitted to government systems daily.
Identify and resolve discrepancies between source systems and final outputs.
M-Pesa Transactions:
Address discrepancies in M-Pesa transactions for internal and external accounts.
Provide timely resolutions through communication with third parties and government entities.
Reporting:
Develop and maintain data integrity checks and reconciliation processes.
Prepare daily, weekly, and monthly reconciliation reports.
System Management:
Oversee operations, administration, and security of systems within the Intelligence and Data division.
Implement Business Continuity Planning (BCP) and Disaster Recovery Planning (DRP) for relevant systems.

Required Qualifications and Skills:

Education: Bachelor’s degree in Computer Science, Computer Engineering, or a related field.
Technical Proficiency:
Strong understanding of BI and data warehouse practices.
Expertise in MS Office applications (Excel, Word, Outlook, PowerPoint).
Communication: Excellent written and verbal communication skills.
Adaptability: Ability to multitask, prioritize critical tasks, and work well under pressure.
Key Performance Indicators:
M-Pesa Reconciliation: Ensure all authorized transactions are reconciled end-to-end.
Government Integrated System: Reconcile transmitted data accurately and resolve discrepancies.
Third-party Management: Maintain effective communication and issue resolution.
System Uptime: Ensure consistent operational performance.