Assistant Manager – Data Warehouse
Job Summary
This role is responsible
for administration and maintenance of organisation wide Data Warehouse ecosystem
Key Responsibilities
- Manages
day-to-day operations of Data Warehouse and BI Team and supervision of
staff in this Unit.
- Plans
and reviews systems deployment and performance requirements.
- Administers
the data warehousing environment, including installation, configuration,
security, testing, data growth, performance and troubleshooting, platform
upgrades, support agreements and disaster recovery.
- Develops,
tests and deploys extraction, transformation, and load (ETL) processes.
- Manages
scheduling of ETL processes.
- Manages
the Data warehouse and Business Intelligence IT Infrastructure.
- Oversees
the evaluation, design and implementation of database enhancements.
- Integration
of diverse data sources with the data warehouse.
- Ensure
quality and integrity of Data Warehouse is maintained.
- Liaises
with other section/s in regards to capacity Planning and ensuring optimal
utilization of the database system 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
- PRINCE2
- ETL
Tools e.g Informatica Power Center, Oracle Data Integrator, etc
- BI
Tools e.g OBIEE, PowerBI, etc
Relevant Work Experience
Have at least four (4)
years’ working experience in management of data warehousing & BI in a busy
environment; one (1) of which should have been at a supervisory role
Technical 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 advantage
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
- Report
writing skills
How to Apply
Deadline for Applications 14 December 2022.