Supervisor – Data Warehouse & BI (Database Administration)

Kenya Revenue Authority (KRA)

Software & Data

1 month ago

Job Summary

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

  • Minimum Qualification:Bachelor
  • Experience Level:Mid level
  • Experience Length:3 years

Job Description/Requirements

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

Share Job Post

Stay Updated

Join our newsletter and get the latest job listings and career insights delivered straight to your inbox.

We care about the protection of your data. Read our privacy policy.

Lorem ipsum

Lorem ipsum dolor (Location) Lorem ipsum KSh Confidential

Job Function : Lorem ipsum

4 months ago

Lorem ipsum

Lorem ipsum dolor (Location) Lorem ipsum KSh Confidential

Job Function : Lorem ipsum

4 months ago

Lorem ipsum

Lorem ipsum dolor (Location) Lorem ipsum KSh Confidential

Job Function : Lorem ipsum

4 months ago

Stay Updated

Join our newsletter and get the latest job listings and career insights delivered straight to your inbox.

We care about the protection of your data. Read our privacy policy.

This action will pause all job alerts. Are you sure?

Cancel Proceed
Follow us On:
Follow us on FacebookFollow us on InstagramFollow us on LinkedInFollow us on TwitterFollow us on YouTube
Get it on Google Play
2023 BrighterMonday