Analytics Engineer

Oona Insurance Philippines; Muntinlupa; On-site; PHP 700,000 - 1,000,000; Full time

Job summary

Oona Insurance Philippines is seeking a business-minded Analytics Engineer with deep expertise in Non-Life and Health Insurance domains to bridge our core operations and data infrastructure. You will manage insurance data lifecycles, from underwriting to reserves and premiums.

You will design data models, build ETL pipelines in SSIS, translate insurance metrics into the data layer, and collaborate with actuaries, underwriters, claims, and finance to deliver reliable analytical data products.

Qualifications

• BS in a quantitative field or related degree.
• 3–5 years of Insurance data experience or related field.
• Solid understanding of core insurance financials and policy lifecycles.
• Advanced SSMS/SSIS and T-SQL skills; cloud is a plus.

Responsibilities

• Design robust data models (Star/Snowflake) in SSMS for insurance data lifecycles.
• Build and maintain ETL pipelines using SSIS and complex T-SQL.
• Translate insurance metrics into the data layer (GWP, Net Earned Premium, Loss Ratios).
• Address as-of reporting and retroactive data challenges with advanced T-SQL.
• Collaborate with actuaries, underwriters, claims managers, and finance.

Skills

SSMS

SSIS

T-SQL

TSQLT

Cloud

Analytical mindset

Business acumen

Policy lifecycles

Education

BS in Computer Science

BS in Data Analytics

BS in Actuarial Science

BS in Finance

Tools

SSMS

SSIS

T-SQL

Job description

We are seeking a business-minded Analytics Engineer with deep expertise in the Non-Life and Health Insurance domains who will act as the vital bridge between our core business operations and our data infrastructure. Managing insurance data lifecycles will be your primary focus, ranging from policy underwriting, claims reserve changes, and earned vs. unearned premiums.

Functions (Duties and Responsibilities):

• Design and optimize robust, business-centric data models (Star and Snowflake schemas) within SSMS that accurately map the complex data lifecycles of insurance policies and claims.
• Build, scale, and maintain stable ETL pipelines using SSIS and complex T-SQL stored procedures, ensuring clean and optimized structures for business analytics.
• Translate nuanced insurance metrics directly into the data layer, including Gross Written Premium (GWP), Net Earned Premium, Loss Ratios, Claims Reserves etc.
• Solve complex insurance data problems, such as retroactively adjusted claims, policy endorsements, and historical point-in-time ('as-of') financial reporting using advanced T-SQL.

Stakeholder Collaboration

• Partner closely with Actuaries, Underwriters, Claims Managers, and Finance teams to turn messy production source data into reliable, intuitive analytical data products.

Job Skills And Qualifications

• Education: BS in Computer Science, Data Analytics, Actuarial Science, Finance or related quantitative field
• Domain Expertise: Minimum 3 to 5 years of Insurance data experience or related field
• Business Acumen: Strong understanding of core insurance financials, policy lifecycles, and claims states.
• Technical Expertise: Advance proficiency in SSMS, SSIS, TSQL, TSQLT. Cloud is a plus.
• Analytical Mindset: Proven ability to prioritize business context and data quality over pure engineering output.

Candidates who can start immediately are preferred.