Job Description
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 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