System Analyst – Pension at Jubilee Insurance

Job Description (adsbygoogle = window.adsbygoogle || []).push({}); Jubilee Insurance was established in August , as the first locally incorporated Insurance Company based in Mombasa in . Jubilee Insurance has spread its sphere of influence throughout the region to become the largest Composite insurer in East Africa, handling Life, Pensions, general and Medical insurance.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 Provide development and ongoing software support and issue resolution using Oracle SQL, PL/SQL, and Developer Oracle Application Express (APEX).Develop and support DA interfaces, C2B and B2C portals and third-party integrations.Partner with other business areas within Jubilee to understand application requirements and develop programming specifications for development.Build a standards-driven, scalable, secure, and dynamic portal for the information delivery of specific based applications.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.Develop enhancements, resolve issues, coordinate testing of statement releases and oversee regular production efforts including data extracts, data imports and printing.Conduct new functionality and regression tests, determine and report issues for follow-up.Participates in creating new products and services where technology is concerned.Contributing to smooth business operations.Working on identifying the project risk and planning mitigation action with any project manager at the project level.Reporting for all the weekly tasks in the form of accurate and detailed reports.To perform any other duties as may be assigned by the section team lead and applications heads. RequirementsFunctional Skills Project managementInformation and knowledge managementOperations and service management Qualifications Bachelor’s degree in computer science, Information Systems, or other related technical degreeOCA – Oracle Certified Associate in PL/SQLAPEX Version 19 and specific experience with insurance industries.Reporting Technologies e.g., Oracle BI & Analytics Relevant Experience 3 years minimum hands-on experience in technology and business fields in Oracle 12c & 19c.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.Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL, PL/SQL, and SQL Loader.Expert in using tools such as TOAD, SQL Navigator & SQL Plus.Experience in query optimization, performance, and tuning (PL/SQL).Working knowledge of Web Logic, Apache, PHP / MySQL programming.