P&C Actuarial Data Analyst

Everest Insurance Company Of Canada is a global leader in risk management, focused on enabling businesses to thrive. The P&C Actuarial Data Analyst will ensure the accuracy and integrity of data for pricing, reserving, and strategic decision-making, working hands-on with large datasets to deliver analysis-ready information.

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