Job Summary

This role is responsible for administration and maintenance of organisation wide Data Warehouse ecosystem

Key Responsibilities

• Manages day-to-day operations of Data Warehouse and BI Team and supervision of staff in this Unit.
• Plans and reviews systems deployment and performance requirements.
• Administers the data warehousing environment, including installation, configuration, security, testing, data growth, performance and troubleshooting, platform upgrades, support agreements and disaster recovery.
• Develops, tests and deploys extraction, transformation, and load (ETL) processes.
• Manages scheduling of ETL processes.
• Manages the Data warehouse and Business Intelligence IT Infrastructure.
• Oversees the evaluation, design and implementation of database enhancements.
• Integration of diverse data sources with the data warehouse.
• Ensure quality and integrity of Data Warehouse is maintained.
• Liaises with other section/s in regards to capacity Planning and ensuring optimal utilization of the database system resources.
• Ensure conformity to ISO (9001/2015 and 27001/2013) and data security requirements.

Academic Qualifications

Bachelor’s degree in Computer Science, Management Information Systems, Information Technology, Electrical / Electronic Engineering, Telecommunications or any other IT related field.

Professional Qualifications

Required Certification

• Certification in Database administration.

The following certifications/training will be an added advantage:

• Unix/Linux Certified Systems Administrator/Microsoft Certified Engineer
• IT Governance e.g. COBIT 5 or ITIL
• PRINCE2
• ETL Tools e.g Informatica Power Center, Oracle Data Integrator, etc
• BI Tools e.g OBIEE, PowerBI, etc

Relevant Work Experience

• Have at least four (4) years’ working experience in management of data warehousing & BI in a busy environment; one (1) of which should have been at a supervisory role

Technical Skills Required 

• Sound experience in Database Administration.
• Experience in managing ETL tools such as Informatica Power Centre or ODI.
• Experience in managing BI tools such as Oracle BI/Power Bi.
• Experience in Programming/scripting languages such as SQL, PL/SQL or other programming languages (Perl, PHP)
• Experience in administration of Engineered Systems e.g Oracle Exadata, Oracle Exalytics will be an added advantage

Competencies Required       

• Excellent listening and communication skills
• Be proactive with good analytical and problem solving skills
• Good team player
• Ability to pay attention to details
• Ability to prioritize competing work commitments and deliver on time
• Passion for innovation and creativity
• High levels of integrity
• Ability to work under minimum supervision
• Report writing skills