Job Description

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.

General Responsibilities

• To build relationships and liaise with various stakeholders across the business to ensure cohesion and drive a collaborative work environment.
• To submit any reports and/or supervise any projects and activities as may be directed from time to time.
• To participate in the definition of an IT Governance framework and compliance.
• To assist their superior in the preparation of the Unit’s business plan and underlying budgets.
• To perform any duties that may be assigned to him/her from line management from time to time.
• The candidate must also be willing to work on call and travel on occasion in order to attend training/conferences or manage supplier relations.

Qualifications, Skills & Competencies 

Mandatory

Skill

• 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, modelling, analysis, distribution etc.)
• Be organised, meticulous and prepared to work under pressure.
• Have good verbal and written communication skills.

Experience

• Minimum of two years’ experience in Data Development/ Data Warehousing ;
• Working knowledge of ETL and ELT 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/Financial 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