Business Intelligence & Analytics at National Bank of Kenya

The overall responsibility for the job holder will be to build and maintain a single platform for financial data (data warehouse) for the Bank to meet Finance and Business MIS/reporting requirements that include providing multi-dimensional reporting capability.

He/ she will be expected to maintain data integrity in the data warehouse and assist in data analysis and administration.

Key Responsibilities:

• Define the architecture and relationships of the company systems and work to eradicate any potential silos of data.
• Ensure effective business data governance. This includes data quality, data management, data policies, business process management, and risk management
  surrounding the handling of business data.
• Responsible for the overall development and maintenance of business performance reports.
• Supports and challenges the business units through KPI based tools and insights
• Collect, organise, analyse and interpret data and statistical information to extrapolate behaviour and patterns from the data that will provide innovation direction and use cases back to the business using SQL .
• Maintain a single platform for financial data to ensure data is up to date, reconciled and in use for customers on a daily basis.
• Ensure MIS/reporting requirements are integrated in the platform and achieve optimized way of accessing data in the organization.
• Management of Interfaces between Finance systems and other Organizations’ software to ensure data integrity.
• Developing and maintenance of Standard reports in the applications including Business performance, growth drivers, access matrices and data integrity controls.
• Support users in Designing Queries for running of adhoc reports as required by business.
• Ensure Systems Security and Access control in line with the organization’s standards for Finance applications.
• Training of Management Information users in all Finance Information Technology systems and applications as necessary.
• First level support for Finance data systems and applications including the Data Warehouse, Oracle GL system, OBIEE.
• Support users to come up with innovative ways to fully utilize available Information Technology and thereby improve effectiveness and efficiency in Finance Information related activities.
• Improve Service Level Agreements in system and issues resolution as per the Finance Division guidelines.
• Track and coordinate resolution of financial data problems and logged tickets.
• Formulate test cases and coordinate user testing in liaison with relevant stakeholders for systems that impact Finance.
• Business Continuity Planning (BCP) and Disaster Recovery Plan (DRP) for finance systems.
• Operational Risk responsibilities – Identify, monitor and report weaknesses or breaches on the supporting data systems and data.
• Stakeholder management to ensure service delivery is as set in the Service Level Agreement.

Qualifications

• Bachelor’s degree in Information Technology, Engineering or Computer Science from a recognized University.
• A post graduate qualification in either ICT or Statistics will be an added advantage.
• Professional qualifications in Accounting will be desirable.
• Oracle certification (OCP).
• Experience with one of the market leading Business intelligence tools e.g. SAS, Business Objects, Hyperion, Cognos, Applix, Proclarity or Embedded solutions within ERPs and
• Database experience including experience in coding across commercial databases (e.g. Oracle, Teradata, MySQL.
• At least (5) years’ experience in Business Intelligence or busy ICT department handling data management preferably in Banking.
• Advanced knowledge of Excel, Word and PowerPoint
• Strong analytical and numerical ability – able to analyse and interpret data, evaluate data and make recommendations based on data and market trends.
• Exceptional programming skills with latest programming languages
• In depth knowledge of office automation software& products as well as Database administration & ETL processes.
• Project Management Experience.
• Ability to think creatively and develop innovative solutions.
• Excellent interpersonal, communication and presentation skills.
• Integrity and courage to challenge business actions.
• Knowledge in designing of data cubes and Data marts is highly desirable
• Knowledge of leading enterprise databases e.g. Oracle, SQL is a pre-requisite
• Demonstrated experience in business analysis and requirements capture.
• Data Quality & Cleansing experience
• An understanding of the organizations accounting and reporting needs.
• Analytical skills in 4 GL’s and CASE tools.