Junior Data Analyst - Insurance Data & Reporting

McNeil & Co.; Manila; On-site; PHP 3,752,000 - 6,879,000; Full time

Job summary

Arch Capital Group Ltd. is seeking a data-focused analyst to monitor exposure and claim data, develop WC reporting, and support regulatory filings across divisions. You will work with Arch business units to ensure data quality and timely responses to inquiries.

The role requires advanced Excel, SQL, and knowledge of relational databases, plus strong communication and organizational skills to manage multiple priorities and large data sets.

Qualifications

• Advanced Excel with macros for data processing and reporting.
• Experience with relational databases and SQL.
• Knowledge of Workers Compensation data and regulatory filings a plus.
• Strong written and verbal communication skills.
• Excellent organization and problem-solving abilities.

Responsibilities

• Monitor exposure and claim data to improve quality and avoid penalties.
• Create documentation for WC data call reporting across divisions.
• Serve as key contact for Allianz legacy functions.
• Resolve USR bureau criticisms and external inquiries.
• Handle Medical and Indemnity Data Call inquiries from data boards.
• Compile data and generate reports for staff review.
• Support WC surcharge and assessment payment obligations.
• Perform data collection and analysis for ad-hoc requests.

Skills

Advanced Excel (macros)

SQL

Relational databases

Communication skills

Organization & problem-solving

Prioritization

Data set supervision

Education

Bachelor's Degree in Information Systems or Data Science

2-5 years working experience in Insurance/Finance

Tools

Snowflake

Job description

Arch Capital Group Ltd. is seeking a data-focused analyst to monitor exposure and claim data, develop WC reporting, and support regulatory filings across divisions. You will work with Arch business units to ensure data quality and timely responses to inquiries.

The role requires advanced Excel, SQL, and knowledge of relational databases, plus strong communication and organizational skills to manage multiple priorities and large data sets.