Data Warehouse & BI (Database Administration)
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
- 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
How to Apply
Deadline for submission 14 December 2022.