Job Purpose:

Responsible for collecting, cleaning, and interpreting complex financial data to generate actionable insights, ensuring regulatory compliance and guiding strategic decision-making. Safeguard the absolute integrity, accuracy, timely, high-quality and completeness of financial data used for financial/statutory reporting, tax compliance, and external audits. Leverage deep knowledge of the bank’s data architecture to automate financial reporting, manage complex GL mappings, resolve audit findings, and ensure all financial data extraction complies with relevant regulations and standards.

Main Responsibilities:

Data Management and Governance

• Clean, filter, and organize raw data to remove errors and ensure accuracy.
• Gathering data from primary or secondary sources, maintaining databases, and ensuring data integrity.
• Maintaining accuracy in financial records and ensuring data, such as customer transactions, is properly analyzed.
• Strengthen financial data governance practices by ensuring adherence to internal data standards, regulatory requirements, and bank-wide governance frameworks
• Identify data quality gaps and drive continuous improvement initiatives to enhance accuracy, completeness, and reliability of financial datasets.
• Maintain and enhance Finance data dictionaries, metadata, and documentation for transparency and consistency across the department.
• Ensure all data extraction and reporting methodologies comply with Tax laws, IFRS standards and BOT (Bank of Tanzania) regulatory reporting requirements.
• Design and implement controls around End User Computing (EUC) tools (e.g., complex Excel models, SQL queries) used in financial reporting to mitigate operational risk.
• Perform data validation, reconciliations, and quality assurance between core banking systems and reporting tools.

Data Extraction, Systems Support and Automation

• Provide technical support to Finance teams regarding data systems and analytics tools
• Write complex SQL queries to pull data from diverse databases for financial reporting.
• Support Finance systems enhancements, including automation of reports using Python, R, or Advanced Excel to automate recurring, high-volume financial reports.
• Implement and advocate for tools that optimize data acquisition, storage, and reporting procedures.

Financial Reporting and Tax Support

• Support monthly, quarterly and annual financial reporting cycles
• Manage the data extraction and validation process for financial, regulatory, and tax reports/returns.
• Develop and maintain automated data pipelines that feed into the financial reporting pack, minimizing manual intervention and reducing reporting cycle time.
• Perform deep-dive analysis on variances in financial reports by tracing data back to transaction-level sources in the core banking system.
• Serve as the focal point for external and internal auditors regarding data lineage; explain how system figures translate to financial statements.
• Manage the mapping of the General Ledger (GL) to financial listing lines, ensuring that new products or system codes are correctly mapped to the right P&L and Balance Sheet lines immediately upon creation.
• Support tax filings by generating precise, transaction-level data sets required for tax computations (e.g., VAT, Excise duty, Withholding Tax) and reconciling them with GL.

Systems & Data Integrity

• Demonstrate expert-level understanding of the Banks Core Banking System and peripheral systems (Credit, Treasury, Trade Finance, etc.) to identify data quality issues at the source.
• Proactively monitor the Health of the GL by running daily/weekly scripts to catch imbalances, suspense account hang-ups, or unmapped transactions before month-end.
• Act as the Finance departments representative in IT/System projects to ensure that any system changes or migrations do not disrupt financial reporting logic.

Knowledge and Skills:

• Advanced Systems Knowledge – Deep understanding of Banking Data structures, Core Banking Systems (e.g., Flexcube/T24), and Ledger Architecture.
• Understanding database design, relational databases, and ETL processes.
• Data Proficiency – Advanced SQL skills for querying large databases; proficiency in Python or R for data analysis and data manipulation, Excel (advanced), and data visualization tools (Tableau, Power BI).
• Financial Acumen – Strong understanding of IFRS (International Financial Reporting Standards), Tax Law, and accounting principles.
• Audit Readiness – Ability to translate complex system logic into clear explanations for Auditors and Tax authorities.
• Technical Problem Solving – Ability to troubleshoot GL imbalances and trace data errors from the financial statement down to the specific system transaction log.
• Communication – Ability to present complex data insights to non-technical stakeholders.

Qualifications and Experience:

• Bachelor’s degree in Finance, Accounting, Data Science, Computer Science, Actuarial Science or related fields.
• Professional Accounting certification (CPA/ACCA) will be an added advantage.
• Certifications in Data Analytics (e.g., Google Data Analytics, Microsoft Certified Data Analyst Associate) are an added advantage.
• Minimum of 4 years’ experience with Finance related systems in a Banking or Financial Services environment.
• Proven track record of supporting financial audits and managing General Ledger (GL) frameworks.
• Experience in dealing with large datasets and financial modeling for statutory reporting (AGM level).

• Clean, filter, and organize raw data to remove errors and ensure accuracy.
• Gathering data from primary or secondary sources, maintaining databases, and ensuring data integrity.
• Maintaining accuracy in financial records and ensuring data, such as customer transactions, is properly analyzed.
• Strengthen financial data governance practices by ensuring adherence to internal data standards, regulatory requirements, and bank-wide governance frameworks
• Identify data quality gaps and drive continuous improvement initiatives to enhance accuracy, completeness, and reliability of financial datasets.
• Maintain and enhance Finance data dictionaries, metadata, and documentation for transparency and consistency across the department.
• Ensure all data extraction and reporting methodologies comply with Tax laws, IFRS standards and BOT (Bank of Tanzania) regulatory reporting requirements.
• Design and implement controls around End User Computing (EUC) tools (e.g., complex Excel models, SQL queries) used in financial reporting to mitigate operational risk.
• Perform data validation, reconciliations, and quality assurance between core banking systems and reporting tools.
• Provide technical support to Finance teams regarding data systems and analytics tools
• Write complex SQL queries to pull data from diverse databases for financial reporting.
• Support Finance systems enhancements, including automation of reports using Python, R, or Advanced Excel to automate recurring, high-volume financial reports.
• Implement and advocate for tools that optimize data acquisition, storage, and reporting procedures.
• Support monthly, quarterly and annual financial reporting cycles
• Manage the data extraction and validation process for financial, regulatory, and tax reports/returns.
• Develop and maintain automated data pipelines that feed into the financial reporting pack, minimizing manual intervention and reducing reporting cycle time.
• Perform deep-dive analysis on variances in financial reports by tracing data back to transaction-level sources in the core banking system.
• Serve as the focal point for external and internal auditors regarding data lineage; explain how system figures translate to financial statements.
• Manage the mapping of the General Ledger (GL) to financial listing lines, ensuring that new products or system codes are correctly mapped to the right P&L and Balance Sheet lines immediately upon creation.
• Support tax filings by generating precise, transaction-level data sets required for tax computations (e.g., VAT, Excise duty, Withholding Tax) and reconciling them with GL.
• Demonstrate expert-level understanding of the Banks Core Banking System and peripheral systems (Credit, Treasury, Trade Finance, etc.) to identify data quality issues at the source.
• Proactively monitor the Health of the GL by running daily/weekly scripts to catch imbalances, suspense account hang-ups, or unmapped transactions before month-end.
• Act as the Finance departments representative in IT/System projects to ensure that any system changes or migrations do not disrupt financial reporting logic.

• Advanced SQL skills for querying large databases
• Proficiency in Python or R for data analysis and data manipulation
• Advanced Excel skills
• Data visualization tools (Tableau, Power BI)
• Deep understanding of Banking Data structures, Core Banking Systems (e.g., Flexcube/T24), and Ledger Architecture.
• Understanding database design, relational databases, and ETL processes.
• Strong understanding of IFRS (International Financial Reporting Standards), Tax Law, and accounting principles.
• Ability to translate complex system logic into clear explanations for Auditors and Tax authorities.
• Ability to troubleshoot GL imbalances and trace data errors from the financial statement down to the specific system transaction log.
• Ability to present complex data insights to non-technical stakeholders.

• Bachelor’s degree in Finance, Accounting, Data Science, Computer Science, Actuarial Science or related fields.
• Professional Accounting certification (CPA/ACCA) will be an added advantage.
• Certifications in Data Analytics (e.g., Google Data Analytics, Microsoft Certified Data Analyst Associate) are an added advantage.
• Proven track record of supporting financial audits and managing General Ledger (GL) frameworks.