Summary
Date Posted: Sunday, December 04, 2022 , Base Salary: Not Disclosed

JOB DETAILS:

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
• 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
• 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

Work Hours: 8

Experience in Months: 36

Level of Education: Bachelor Degree

Job application procedure

Job Application Guidelines
Registration:
Go to https://erecruitment.kra.go.ke/login  and then click on the ‘Register’ button to start the application process.
After registration, you will receive an email enabling you to confirm your email address and complete your registration.
Log on:
After registration go to https://erecruitment.kra.go.ke/login 
Key in your username and password then click on ‘Log in’ to access your account.
After successful log in, the system will open the ‘Applicant Cockpit’.
Candidate Profile (To create or update applicant detail):
On the ‘Applicant Cockpit’ page, go to the tab ‘Candidate Profile’.
Click on ‘My Profile’ to create and update your profile.
Follow the instructions to complete your profile.
The process will end by clicking the tab “Overview and Release”.
Ensure you click the check box on the page to complete the profile.


All Jobs

QUICK ALERT SUBSCRIPTION