Data Warehouse & BI (Database Administration) Job in Kenya

Ad Code

Data Warehouse & BI (Database Administration) Job in Kenya

Data Warehouse & BI (Database Administration)

Job Summary

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

Key Responsibilities

  • Maintenance, development, deployment and scheduling of ETL (Extract, Transform and Load) workflows in the data warehouse ecosystem
  • Maintenance, development and deployment of Business Intelligence(BI) catalogues/reports/dashboards in the data warehouse ecosystem
  • Maintains the data warehouse architecture and all related documentation
  • installation, upgrading, patching, migration and decommissioning of all the systems/tools within the data warehouse ecosystem
  • Reviews backup designs and recovery policies and documentation for the Data warehouse
  • Ensures Data Quality and Integrity of the data warehouse is maintained.
  • Integration of diverse data sources with the data warehouse.
  • Works with Techno-Functional consultants to identify and understand Source Data Systems.

  • Uses Business Intelligence tools and OLAP cubes to generate analytical reports on large volumes of data
  • Monitors and performs tuning of data warehouse ecosystem
  • Manages user requests for reports extraction and data mining
  • Carries out configuration and testing of data warehouse ecosystem
  • Manages the execution of data loading scripts.
  • Ensures all activities are in conformity with established policies and procedures that will sustain database system’s availability, security and recoverability
  • Liaises with other section/s in regards to capacity Planning and ensuring optimal utilization of the data warehouse 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 

  • 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
  • Web Application Servers i.e. Tomcat and JBOSS, Web Logic
  • ETL Tools e.g Informatica Power Center, Oracle Data Integrator, etc
  • BI Tools e.g OBIEE, PowerBI, etc

Relevant Work Experience

  • Have at least three (3) years working experience in management of data warehousing & BI in a busy environment

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 advantageAbility to install and configure Linux/ Windows installations

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

How to Apply

Deadline for submission 14 December 2022.

Click Here to Apply.

Looking for a job? Download the Kenyan Jobs app from Google Playstore and get the latest jobs and vacancies available in Kenya, go HERE>>>