Actuarial Analyst

3 weeks ago Be among the first 25 applicants Get AI-powered advice on this job and more exclusive features. Direct message the job poster from ECLARO 5-6 years' experience, P&C background is preferred. Heavy data input and analysis. Responsibilities Aggregate and stack loss runs from various file types. Interpret and analyze large volumes of data (mostly Excel and PDF) to identify claims that pierced multiple layers of an insurance tower (i.e., a claim that exhausted the SIR limit and impacted at least one additional layer above the SIR). Produce ground-up gross indemnity & ALAE for each claim by combining all losses for an event. Identify data anomalies and raise questions as needed. Proficiency in Excel: populate multiple sections of the rater. Apply basic Excel formulas to aggregate losses efficiently. Experience with insurance data: familiarity with terms such as gross vs. net loss, SIR vs deductible, indemnity and ALAE, paid vs. reported. Medical Professional Liability familiarity is a plus. Attention to detail and problem-solving: ensure accuracy in data aggregation and entry. Verify claims with the same or similar claimant, date of loss, and allegation. Analyze actuarial funding studies: extract necessary information such as expected loss for the prospective period, retention limit, and exposures, and enter into the rater. Identify the limit structure for each product (Professional Liability, General Liability, Abuse & Molestation, etc.) and enter limits within the rater. Identify ALAE treatment. Identify risk characteristics: determine the healthcare segment and healthcare category from submissions. Strong communication skills: explain data issues clearly to underwriters or actuaries and collaborate with actuaries when needed to determine the best way to capture data and risk. Qualifications 5-6 years' experience; P&C background preferred. Strong data input and analysis capabilities. Proficiency in Excel; ability to populate rater sections and use formulas for aggregation. Experience with insurance data and terminology (gross vs. net loss, SIR vs deductible, indemnity and ALAE, paid vs reported). Medical Professional Liability familiarity is a plus. Attention to detail and problem-solving skills; meticulous data validation for claims with similar identifiers. Ability to interpret funding studies to extract expected loss, retention, and exposures for input into the rater. Ability to identify limit structures and ALAE treatment across products. Ability to identify risk characteristics (healthcare segment and category) from submissions. Strong written and verbal communication skills; able to explain data issues to underwriters and actuaries. Seniority level Mid-Senior level Employment type Full-time Job function Analyst and Research Industries: Insurance Referrals increase your chances of interviewing at ECLARO by 2x Get notified about new Actuarial Analyst jobs in Philippines. #J-18808-Ljbffr