Data Analyst-Junior

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

With a company culture rooted in collaboration, expertise and innovation, we aim to promote progress and inspire our clients, employees, investors and communities to achieve their greatest potential. Our work is the catalyst that helps others achieve their goals. In short, We Enable Possibility℠.

Responsibilities

• . Monitor various exposure and claim data sets and work with Arch business units and support teams to improve data quality and avoid financial penalties, where possible.
• . Responsible for creating necessary documentation to support aggregate financial and state-specific Workers Compensation data call reporting for all of Arch’s business divisions.
• . Fill role as key-contact for any obligations mirrored to handle Allianz legacy functions.
• . Assist in the resolution of Unit Statistical Reports (USR) bureau criticisms or other external inquiries. Work with staff to remedy any systemic data anomalies.
• . Assist in the resolution of Medical Data Call and Indemnity Data Call inquiries received from the various data collection organizations.
• . Compile data, create reports from various systems and send them to staff for review and submission.
• . Assist in the fulfillment of WC surcharge and assessment payment obligations as needed in support of staff.
• . Perform data collection and analysis in support of ad-hoc and recurring requests by staff.

Qualifications Required Skills/Experience

• . Advanced Microsoft Excel skills including macro generation.
• . Experience with relational databases and SQL.
• . Strong foundational knowledge of Workers Compensation line of business is a plus.
• . Firm understanding of regulatory requirements as it relates to statistical data call filings.
• . Knowledge of Snowflake is a plus.
• . Good written and oral communication skills.
• . Good organizational and problem-solving skills.
• . Ability to manage competing priorities and meet deadlines.
• . Must be able to manage the supervision of large data sets including analysis, accuracy, and attention to detailed definitions of data being requested.
• . Willingness to advise management if something is unclear or if there are any suggestions for a potential improvement opportunity.

Education

• . Bachelor's Degree in informational system or data science preferred.
• . 2-5 working experience in Insurance/Finance field.

Do you like solving complex business problems, working with talented colleagues and have an innovative mindset? Arch may be a great fit for you.

Arch Capital Group Ltd. is a Bermuda-based specialty insurer that provides insurance, reinsurance and mortgage insurance on a worldwide basis. With a 20+-year track record of delivering results and a coveted position on the S&P 500 index, Arch is a great place to grow your career.

Attention Job Seekers: Arch Capital Group Ltd. (Arch) and its affiliates take your interest in working here very seriously. Please be vigilant to fraudulent activity if you receive a communication or email asking you to submit any personal information. You should only enter your information into our official career portal. We never make job offers without a formal, in person, interview process. We never ask you to send money of any kind.