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