L&H Data Integration Analyst

Job Summary

hELIOS is the Life & Health (L&H) administration platform designed to manage individual-level data. The hELIOS solution is built around three core pillars:

• Business Administration: Enhancing and simplifying treaty administration processes, including bordereaux management, claims referrals, and medical underwriting.
• Operational Efficiency: Delivering a seamless user experience through streamlined workflows, system integration, and automated data processing
• Data Centricity: Providing accessible, standardized, and accurate data to support decision-making and drive business value in areas such as knowledge management, modeling, and experience analysis.

By the strategic plan Forward 2026 horizon, hELIOS aims to be deployed across all markets-excluding the US and China-for the administration of assumed and retrocession premiums and claims. Key focus areas for the coming years include:

• Continuing the rollout of existing hELIOS functionalities (Portal, Life Admin Bordereaux, Referrals) across L&H markets, with a focus on Canada, ANZ and France.
• Expanding and stabilizing claims verification functionalities, integrated with Life Admin Bordereaux management.
• Enhancing data and reporting capabilities.
• Implementing retrocession administration functionalities.

To support this strategic vision, the hELIOS Business Competency Centre (hBCC) is seeking a L&H Data Integration Analyst based in Singapore.

This role will be responsible for supporting business users on treaty onboarding, data maintenance and data usage activities, in coordination with hBCC team members in other regions (Paris, London, Sydney).

Key duties and responsibilities

The L&H Data Integration analyst maintain a pro-active relationship with hBCC internal clients (client administrator, actuarial staff, etc.) and is responsible for the following activities:

• Treaty onboarding and maintenance

-Analyze resinsurance treaties, product literature and policy data to configure the reinsurance plans (products, benefits, controls) in the hELIOS platform.
-Examine client data (premium and claims bordereaux) to understand its structure and behaviour in the context of policy/claims processing and downstream usage in the Administration platform.
-Define or review mappings document that specify how the bordereaux data should be transformed and mapped to the hELIOS standard format.
-Develop solutions to process suboptimal cleint data, addressing issues relate to quality or completness.
-Create, maintain and validate packages for automating client data recognition, data structureing and data transformations - primarily using a bespoke self-service data transformation tool (Data Engineering), or potentially a programming language such as Python.
-Build strong cross-functional relationships with other teams to deepen understanding of data and transofmation requirements.

• Business support

-Assist end-users (e.g. Technical Accountants) in investigating data discrepancies identified during bordereaux processing, such as mismatches between premium bordereaux and statement of account figures.
-Analyze root causes, collaborate on reconciliation efforts, and recommend corrective actions, including updates to data transformation packages to ensure data accuracy and integrity.

• Data Analysis and reporting

-Support ad hoc analysis or reporting using SCOR's data platform including Databricks and Palantir Foundry.
-Develop an in-depth expertise in the hELIOS data model. Actively contribute to knowledge sharing across teams. This includes understanding the structure, relationships, and business logic embedded in the model, and effectively communicating insights to support data-driven decision-making, system integration, and continuous improvement initiatives.

Experience:

• 5+ years in Life Reinsurance or Insurance, with a focus on operations or back-office functions.
• Strong understanding of life insurance products and data transformation processes.

Technical skills:

• Proficiency in data analysis and transformation.
• Familiarity with SQL, Python, Palantir Foundry, Databricks, and VBA (preferred).

Soft skills:

• Strong analytical and problem-solving abilities.
• Excellent communication and interpersonal skills.
• Proactive, independent, and detail-oriented.
• Team-oriented with a customer-focused mindset.
• Adaptable to changing priorities and conditions.