Everest is a global leader in risk management, focused on enabling businesses to thrive and economies to function. The P&C Actuarial Data Analyst will play a vital role in ensuring the accuracy and integrity of data for pricing, reserving, and strategic decision-making.
Responsibilities
- Clean, validate, and reconcile large, complex datasets to identify errors, inconsistencies, and missing information across multiple data sources
- Process, map, and standardize incoming premium and claims bordereaux from various partners
- Investigate and resolve bordereau discrepancies by collaborating closely with underwriting and operations teams
- Provide data support for monthly, quarterly, and annual actuarial reporting
- Act as a data investigator, identifying anomalies, tracing issues to their source, determining root causes, and recommending remediation solutions
- Manipulate, aggregate, and transform large volumes of data using advanced Excel, Power Query, and related tools to prepare analysis‑ready datasets
- Partner with actuaries to understand data requirements for pricing models, reserving analyses, and profitability studies
- Deliver clean, accurate, and timely datasets to support actuarial decision‑making
- Identify opportunities to improve data collection, validation, and processing efficiency; contribute to the development of best practices for actuarial data management
- Maintain clear, concise documentation of data sources, processes, and transformations to ensure transparency, repeatability, and auditability
Skills
- Advanced proficiency in Microsoft Excel, including complex formulas (VLOOKUP/XLOOKUP, INDEX/MATCH, SUMIFS), Pivot Tables, and Power Query
- Proven experience cleansing, manipulating, and validating large, complex, and often unstructured datasets
- Exceptional attention to detail and a strong commitment to data accuracy
- Strong investigative and problem‑solving skills, with the ability to navigate ambiguity confidently
- Hands‑on experience working with premium and claims bordereaux
- Familiarity with manual policy and claims tracking systems
- Working knowledge of SQL for querying and data manipulation
- Experience with data visualization tools such as Power BI or Tableau
- Basic understanding of P&C insurance concepts (e.g., written vs. earned premium, incurred vs. paid losses)
Benefits
- Health insurance coverage
- An employee wellness program
- Life and disability insurance
- Retirement savings plan
- Paid holidays
- Paid time off (PTO)
Company Overview
- Everest Group, Ltd. It was founded in 1973, and is headquartered in Hamilton, Hamilton, BMU, with a workforce of 1001-5000 employees. Its website is https://www.everestglobal.com/.