Jobs Career Advice Signup
X

Send this job to a friend

X

Did you notice an error or suspect this job is scam? Tell us.

  • Posted: Dec 2, 2022
    Deadline: Dec 14, 2022
    • @gmail.com
    • @yahoo.com
    • @outlook.com
  • Never pay for any CBT, test or assessment as part of any recruitment process. When in doubt, contact us

    The Kenya Revenue Authority (KRA) was established by an Act of Parliament, Chapter 469 of the laws of Kenya , which became effective on 1st July 1995 . The Authority is charged with the responsibility of collecting revenue on behalf of the Government of Kenya. A Board of Directors, consisting of both public and private sector experts, makes policy decisio...
    Read more about this company

     

    Officer – Data Warehouse & BI (Database Administration)

    Job Summary

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

    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

    Method of Application

    Interested and qualified? Go to Kenya Revenue Authority (KRA) on www.kra.go.ke to apply

    Build your CV for free. Download in different templates.

  • Send your application

    View All Vacancies at Kenya Revenue Authority (KRA) Back To Home

Subscribe to Job Alert

 

Join our happy subscribers

 
 
Send your application through

GmailGmail YahoomailYahoomail