Job Description
We currently have an exciting career opportunity for a System Analyst - Pension within Jubilee Life Insurance
Limited. The position holder will report to the Senior Manager – Long Term Applications and will be based at our
Head Office in Nairobi.
Role Purpose
The Systems Analyst - Pensions is an applications design, development, and implementation specialist. The analyst is
responsible for identifying and implementing application solutions to solve business problems and to make business
operations more efficient. The individual is responsible for designing, developing, testing, and debugging new
functionality, enhancements, customizations, interfaces, batch processes, queries, and reports.
Main Responsibilities
1. Provide development and ongoing software support and issue resolution using Oracle SQL, PL/SQL, and Developer
Oracle Application Express (APEX).
2. Develop and support DA interfaces, C2B and B2C portals and third-party integrations.
3. Partner with other business areas within Jubilee to understand application requirements and develop programming
specifications for development.
4. Build a standards-driven, scalable, secure, and dynamic portal for the information delivery of specific based
applications.
5. Capture, log, and track applications issues and develop resolutions in the specified timeframes. This includes liaising
with system vendors if the system is vendor supported.
6. Develop enhancements, resolve issues, coordinate testing of statement releases and oversee regular production
efforts including data extracts, data imports and printing.
7. Conduct new functionality and regression tests, determine and report issues for follow-up.
8. Participates in creating new products and services where technology is concerned.
9. Contributing to smooth business operations.
10. Working on identifying the project risk and planning mitigation action with any project manager at the project level.
11. Reporting for all the weekly tasks in the form of accurate and detailed reports.
12. To perform any other duties as may be assigned by the section team lead and applications heads.
Functional Skills
1. Project management
2. Information and knowledge management
3. Operations and service management
Qualifications
1. Bachelor’s degree in computer science, Information Systems, or other related technical degree
2. OCA – Oracle Certified Associate in PL/SQL
3. APEX Version 19 and specific experience with insurance industries.
4. Reporting Technologies e.g., Oracle BI & Analytics
Relevant Experience
1. 3 years minimum hands-on experience in technology and business fields in Oracle 12c & 19c.
2. Demonstrated ability to design, develop, unit test, and deploy Oracle apps using Oracle tools such as Oracle
PL/SQL, Reports, Workflow, WebLogic, and Oracle Fusion Middleware.
3. Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL,
PL/SQL, and SQL Loader.
4. Expert in using tools such as TOAD, SQL Navigator & SQL Plus.
5. Experience in query optimization, performance, and tuning (PL/SQL).
6. Working knowledge of Web Logic, Apache, PHP / MySQL programming.