Officer – Data Warehouse & BI (Database Administration)

Kenya Revenue Authority (KRA)

Software & Data

Nairobi Full Time

Banking, Finance & Insurance KSh Confidential

1 month ago

Job Summary

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

Minimum Qualification:Bachelor
Experience Level:Entry level
Experience Length:1 year

Job Description/Requirements

Key Responsibilities

Maintains, develops, deploy and scheduling of ETL (Extract, Transform and Load) workflows in the data warehouse ecosystem
Maintains, develops and deploy Business Intelligence(BI) catalogues/reports/dashboards in the data warehouse ecosystem
Maintains the data warehouse architecture and all related documentation
installations, 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
Maintains Data Quality and Integrity of the data warehouse.
Oversees 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 Online Analytical Processing (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:

Data Warehousing and Business Intelligence
ETL Tools e.g Informatica Power Center, Oracle Data Integrator, etc
BI Tools e.g OBIEE, PowerBI

Relevant Work Experience

Have a least one (1) year hands-on working experience in management of data warehousing & BI environments

Skills Required

Hands-on experience in RDBMS installation, tuning and troubleshooting.
Working experience in Unix and Windows operating systems.
Ability to manage enterprise databases on RDBMS like Oracle, Postgres, MySQL and MS SQL Server.
Demonstrate ability to diagnose and performance tune databases for optimal performance
Experience in using ETL tools such as Informatica Power Centre or ODI will be added advantage.
Experience in using BI tools such as Oracle BI and or BI Publisher will be an added advantage
Experience in Programming/scripting languages such as SQL, PL/SQL or other programming languages (Perl, PHP, Java, etc.)

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

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.

Application process:

To view the open job postings, click on the tab ‘Employment Opportunities’ on the ‘Applicant Cockpit’ page.
Under the heading ‘Job Search’ click the ‘Start’ button to view all available vacancies.
Click on the Job posting to display the details of the position.
To apply for the position, click ‘Apply’ button at the top of the page.
Follow the instructions to complete and submit your application.
Kindly note that all mandatory fields must be completed.
To complete the process of application, click the ‘Send Application Now’ button after reviewing and accepting the ‘Data Privacy Statement’.

In case of any challenges, please send your email query to isupporthr@kra.go.ke

If you experience any delay in receiving an email notification at the end of the e-recruitment registration process, please refresh your email. In case of any challenge, please send your query to isupporthr@kra.go.ke

Kenya Revenue Authority does not charge any fee at any stage of the recruitment process (application, shortlisting, interviewing, and/or offer)

Important Safety Tips

Do not make any payment without confirming with the BrighterMonday Customer Support Team.
If you think this advert is not genuine, please report it via the Report Job link below.

Report Job

Get Insured through mTek Services

You can explore medical and personal accident insurance covers conveniently. Compare pricing from various insurance companies, save, and budget

Get Insured