Data Analyst-Junior
At a glance
Junior Data Analysis & BI role at Arch Capital Group Ltd. PHL-Manila · full-time.
Pay not stated Data Analyst salary
dataroles summary, based on the employer's posting.
What you'll do
- Track exposure and claims data, then coordinate fixes with business and support teams to improve its accuracy
- Prepare records for companywide and state Workers Compensation reporting, including documentation for each filing
- Handle Allianz legacy obligations and help resolve bureau critiques, outside inquiries and data-call questions
- Pull information from multiple systems, build reports for staff review, and support surcharge and assessment payments
- Analyze data for recurring and one-off staff requests, checking accuracy and the definitions behind each data set
What you bring
- You have two to five years of work in insurance or finance
- You can use advanced Excel features, including building macros, and work with SQL and relational databases
- You understand regulatory rules for statistical data filings and can communicate clearly in writing and conversation
- You can organize competing deadlines, troubleshoot data issues and flag unclear requests or possible improvements
Who this fits
This junior role suits someone comfortable overseeing large data sets with close attention to accuracy and detail. A bachelor's degree in information systems or data science is preferred.
From the employer
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.
Additional Information
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. If this job isn’t the right fit but you’re interested in working for Arch, create a job alert! Simply create an account and opt in to receive emails when we have job openings that meet your criteria. Join our talent community to share your preferences directly with Arch’s Talent Acquisition team.