Job Description

This position is on a temporary contract of two years.

Overall Purpose of the Position

To drive and perform the activities to develop, maintain and support the Banks’ Enterprise Data Warehouse, Business Intelligence and Reporting Solutions, ensuring that the business has timely access to quality data in an efficient and effective manner and that our data stores are maintained inline with industry standards.

Operational Responsibilities

·       To carry out all assigned tasks efficiently and effectively, in adherence with internal policies and procedures.

·       To participate in the design and implementation of process improvements for the team.

·   To participate in periodic system reviews to identify possible gaps and process inconsistencies and propose re-alignment strategies including the necessary training programmes. 

Data Warehouse

·       To participate in the architecture design and development of the Data Warehouse, including recoverability, resilience, data quality, data integrity and security in accordance with the Bank’s standards and industry best practices.

·       To implement and maintain version control.

·       To ensure proper segregation of duties within the team when it comes to implementing changes on test and production environments.

·       To ensure, at all times, a current version of the documentation related to Data Warehouse architecture, data model and data dictionary is maintained.

·       To monitor the state of data quality, including integrity, accuracy and consistency, within the Data Warehouse and establish goals for data quality improvements and take corrective action where necessary, including recommending updates at source with the data stewards.

·       To perform the design and development activities of Data Warehouse integration with third party systems.

·       To research and stay abreast of emerging Data Warehouse technologies and design methods.

Business Intelligence and Reporting

·       To design and drive the development and implementation of BI solutions.

·       To provide ad-hoc reports as per client/end user requirements.

·       To assist our internal clients/end users in the definition of their business requirements.

·       To assist/train end-users in the use of data query analysis and reporting tools.

·       To promote the use of BI, BI Initiatives and Reporting tools.

Performance Management

·       To establish and monitor process improvements and efficiencies to improve on the defined KPIs.

·       To carry out performance benchmarking, tuning and optimisation to achieve the Bank’s desired performance results on/from the Data Warehouse.

Qualifications, Skills & Competencies 

 Mandatory

Skill

• Excellent communication skills (including written and oral) - able to relate to various members of the organisation;
• Ability to challenge the status quo and inspire others to identify opportunities and areas  for improvement;
• Proven experience of working under pressure and to tight deadlines.
• Customer Driven with an ability to prioritise issues based on impact.
• Excellent understanding of data administration and management functions (collection, analysis, distribution etc.)

Experience

• Minimum of two years’ experience in Data Development/ Data Warehousing ;
• Working knowledge of ETL and ETL techniques (technologies include Microsoft SSIS and SAP Data Services)
• Experience in designing, developing and implementing Data Warehouse environments;
• Hands on experience with SQL, PL/SQL and Transact SQL;
• Knowledge of Data Reporting and KPIs.

 Qualification

• Possess a first degree level of education in IT or Engineering or equivalent specialised training in data warehousing and/or BI;.

Desirable

Skill

• Requirements gathering;
• Business and Process ANalysis;

Experience

• Software Development;
• Sprint planning.

Qualification

• Banking/ Accounting Qualification.

Position level (1 being the highest level)

1. Head of Department
2. Managerial & Specialist Positions
3. Middle Management & Specialist Positions
4. Technical & Clerical Positions