We have an urgent requirement for Senior Developer Consultant – INSIS (Non-Life, Medical & Reinsurance)  for one of the Insurance  client in Abu Dhabi

 Design, develop, configure, and maintain INSIS core insurance modules including quotation, underwriting, claims, medical, and reinsurance, while providing L2/L3 production support. --Must

Act as SME for Non-Life, Medical, and Reinsurance processes, covering treaty management, facultative business, ceding, recoveries, RI accounting, and regulatory reporting.--Must

Develop Oracle SQL/PLSQL solutions, optimize backend tables, views, and materialized views, build APIs, system integrations, reporting solutions, and perform performance tuning.--Must

Collaborate with business, finance, actuarial, and IT teams to translate requirements into solutions, manage enhancements, support testing and deployments, ensure compliance, and mentor junior developers--Must

 

Role Overview:

We are a leading insurance company committed to deliver innovative and customer-centric solutions to our clients. We are seeking a Senior INSIS Developer Consultant with strongtechnical skills, in-depth Non-Life and Medical insurance domain knowledge, and proven Reinsurance expertise. The Consultant requires functional expertise across the quotation,underwriting, claims, reinsurance and reporting modules, together with a solid understanding of INSIS backend tables, views and materialised views. It focuses on developing, enhancingand supporting the INSIS core platform, and on acting as the key link between business users, vendors and IT teams. Future involvement in enhancement initiatives and projectimplementations may be required.Functional ResponsibilitiesServe as SME for INSIS Non-Life, Medical and Reinsurance business processes.Understand and support the quotation, policy issuance, endorsement, cancellation, reversal and renewal processes.Support underwriting rules, rating, sum insured, exposure (EML/PML) and accumulation requirements.Support the claims lifecycle, including registration, reserving (OSLR), payments, recoveries and claim events.Support Medical processes, including member enrolment, tables of benefits, pre- authorisation, provider networks and eClaims.Act as Reinsurance SME across:o treaty setup and configurationo proportional (Quota Share, Surplus) and non-proportional (XoL, Cat XoL)treatieso facultative placements, ceding, receding and retentiono treaty capacity and RI accountingSupport premium and claims cession, RI recoveries, XoL event recoveries, reinstatement premiums and RI statements.Support reinsurance reporting, including Risk Profile, Claims Compare, bordereaux and treaty statistics.Collaborate with Underwriting, Claims, Medical Operations, Reinsurance, Finance and Actuarial teams.Translate business requirements into functional and technical specifications and user stories.Conduct gap analysis and impact assessments for enhancement requests.Support SIT, EBT and UAT activities and business sign-off.Technical ResponsibilitiesDesign, develop, configure and maintain INSIS functionality across the quotation, underwriting, claims and reinsurance modules.Develop and maintain reinsurance logic, including:o premium and claims distributiono treaty allocation and FAC handlingo cancellation/reversal impacts on cessionsDevelop and optimise PL/SQL packages, procedures, functions, triggers, views and materialised views.Maintain a strong understanding of the INSIS data model, including core tables, custom tables, views and MVs, especially the reinsurance and ceding tables.Build and maintain interfaces with Oracle Financials, data platforms, TPAs and healthregulatory platforms (DoH / DHA).Develop and validate operational, financial, reinsurance and regulatory reports.Perform data validation and reconciliation between INSIS, reinsurance and financeusing SQL, including share percentages, ceded premiums and sum insured.Perform root cause analysis for incidents and production issues, including RIdistribution discrepancies.Perform code reviews and performance tuning.Coordinate releases, deployments and post-deployment validation.Prepare technical specifications, data mappings and deployment documentation.Application Support & GovernanceProvide L2/L3 support for INSIS and meet agreed SLAs.Coordinate with vendors and implementation partners for issue resolution, patchesand upgrades.Manage incidents, enhancements and change requests through their lifecycle.Track regulatory changes affecting Non-Life, Medical and Reinsurance.Identify opportunities for process automation and operational improvements.Mentor junior developers and promote coding standards and best practices.Support audit, compliance and IT governance requirements.
Experience required for the Consultant8+ years in software development, including at least 5 years hands-on with INSIS or acomparable core insurance platform.Strong Non-Life and Medical insurance domain knowledge, ideally in the UAE/GCCmarket.Proven Reinsurance expertise, including:o treaty and facultative structureso proportional and non-proportional cedingo RI accounting, recoveries and reinsurance reportingProven functional knowledge of the quotation, underwriting, claims, reinsurance andreporting modules.Experience handling production support, incidents and enhancement requests.Ability to bridge business and technical teams.Technical Skills required for the ConsultantINSIS Configuration and DevelopmentReinsurance Module (Treaty, FAC, Ceding, XoL)Oracle SQL and PL/SQLBackend Tables, Views and Materialised ViewsReporting and Data AnalysisAPI and System IntegrationPerformance Tuning