Underwriting Data Analyst - Submissions & Risk Insights

PNI Business Solutions, Inc.; Metro Manila; On-site; PHP 360,000 - 600,000; Full time

Job summary

PNI Business Solutions, Inc. is seeking an Underwriting Support Analyst in Metro Manila to review broker submissions, validate underwriting data, and support rating activities. You will extract information from ACORDs, loss runs, and SOVs, analyze risk factors, and maintain trackers and production metrics.

The role requires 1 year of P&C experience, strong Excel skills, and familiarity with underwriting systems. Collaboration with brokers and rating teams is essential for accuracy and efficiency.

Qualifications

• 1 year of experience in P&C insurance.
• Strong knowledge of commercial submissions, ACORD forms, loss runs, SOVs, exposure schedules, and coverage details.
• Experience analyzing TIV, limits, deductibles, classifications, occupancy, payroll, sales, and loss history.
• Proficiency in Excel, including VLOOKUP/XLOOKUP, PivotTables, formulas, filtering, and data validation.
• Familiarity with insurance rating platforms, underwriting systems, and premium calculation tools.
• Strong understanding of P&C terminology, coverage structures, rating factors, and underwriting requirements.
• Excellent data accuracy, analytical, reconciliation, and quality-control skills.
• Strong communication skills and ability to work with brokers, underwriters, and rating teams.

Responsibilities

• Review broker submissions and validate underwriting and exposure data.
• Extract key information from ACORDs, loss runs, SOVs, and supplemental applications.
• Analyze loss frequency/severity, claims status, TIV, exposures, limits, and deductibles.
• Input validated data into rating tools, underwriting systems, and Excel templates.
• Perform data reconciliation and quality checks before submission to underwriters.
• Identify and resolve missing, inconsistent, or conflicting risk information.
• Maintain submission trackers, audit logs, and production metrics.
• Support underwriters with rating, premium indication, and submission preparation.
• Identify opportunities to improve accuracy, efficiency, and process controls.

Skills

Data accuracy

Analytical skills

Quality control

Communication skills

Attention to detail

Tools

Excel (VLOOKUP/XLOOKUP)

PivotTables

Underwriting systems

Premium calculation tools

Job description

PNI Business Solutions, Inc. is seeking an Underwriting Support Analyst in Metro Manila to review broker submissions, validate underwriting data, and support rating activities. You will extract information from ACORDs, loss runs, and SOVs, analyze risk factors, and maintain trackers and production metrics.

The role requires 1 year of P&C experience, strong Excel skills, and familiarity with underwriting systems. Collaboration with brokers and rating teams is essential for accuracy and efficiency.