Python and SQL (Actuarial Analyst)

Arch Global Services (Philippines) Inc.; Cebu City; On-site; PHP 334,800 - 558,000; Full time

Job summary

A leading insurance firm seeks an aspiring actuary in Cebu City to perform profitability reviews, collaborate with underwriters, and build tools for pricing. A Bachelor’s degree in a quantitative field is required. Candidates should have strong SQL skills and a demonstrated interest in actuarial science. This role offers an excellent opportunity for professional growth in the insurance sector.

Qualifications

• Proficient in SQL and programming skills with Python preferred.
• Strong oral and written communication skills.
• Demonstrated interest in actuarial science.

Responsibilities

• Conduct profitability reviews and new submission analyses.
• Monitor portfolio rate changes and pricing adequacy.
• Support design and maintenance of actuarial tools.
• Collaborate with underwriters on rate plan improvements.

Skills

SQL

Excel

Python

Written communication

Oral communication

Project management

Analytical problem-solving

Collaboration

Education

Bachelor’s degree in a quantitative discipline

Tools

PowerPoint

Job description

Overview

Arch Insurance Group is seeking a motivated aspiring actuary to join our team. Our group supports P&C Programs, MidCorp Programs and Entertainment. The business units provide highly specialized and tailored insurance products in Commercial Auto, General Liability, Property, Workers Compensation and Excess Umbrella.

This position is an excellent opportunity for a new actuarial candidate looking for intellectual and professional challenges, learning actuarial skills and understanding various products in P&C insurance.

The role includes portfolio profitability reviews, large account pricing, actuarial parameter studies, building actuarial/underwriting tools as well as monitoring and reporting on strategy executions, emerging trends and leading indicators. This position will require strong database and programming skills, curiosity, quick learning, problem solving, as well as strategic business thinking.

Responsibilities

• Profitability Reviews / New Submission Analyses
• Review products by applying actuarial concepts and techniques to determine portfolio profitability; analyzing and digging into detailed segmentation
• Monitor and Report
• Monitor portfolio rate change, pricing adequacy and underwriting mix change on new and renewal business to help Program Managers make informed decisions
• Actuarial Studies
• Analyses and research to improve pricing parameters and segmentation to better identify profitable opportunities
• Tool Building
• Designing, programming, maintaining, and supporting tools used in pricing, and book monitoring
• New Product Support / Rate Plan Improvements
• Collaborate with Underwriters to create and revise rating plans; develop state specific support for insurance departments

Qualifications

• Skills: Proficient in SQL, Excel/Word/PowerPoint and experience with Python preferred
• Communication: both oral and written communication including presentations and market
• Leadership: Able to lead discussion with cross-functional teams
• Collaboration: Able to collaborate with cross-functional business partners
• Efficiency: Strong productivity and organizational skills. Ability to deliver high quality work product in an efficient manner
• Project Management: Strong project management
• Analytical and quantitative skills: theoretical and analytical problem-solver with creativity
• Demonstrated interest in actuarial science and insurance; no experience required
• Interest in and ability to complete the actuarial exams and achieve professional property & casualty actuarial credential

Additional Information

Bachelor’s degree with a concentration in a quantitative discipline such as actuarial science, statistics, computer science, mathematics, economics, or operations research