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
go to method of application »
Use the link(s) below to apply on company website.
Apply via :