P&C Actuarial Data Analyst

Title:

Company:

Job Category:

Job Description:

About Everest:

Everest is a global leader in risk management rooted in a rich 50 year heritage of enabling businesses to survive and thrive and economies to function and flourish. We are underwriters of risk growth progress and opportunity. We are a global team focused on disciplined capital allocation and long-term value creation for all stakeholders who care deeply about our impact on communities and the wider world.

Job Summary:

As a P&C Actuarial Data Analyst youll play a vital role on a collaborative Actuarial team serving as the bridge between raw data and meaningful analysis.

In this role youll ensure the accuracy completeness and integrity of the data that fuels pricing reserving and strategic decisionmaking. Youll work handson with large complex datasetspremium and claims bordereaux policy and claims system extracts and data from manual or disparate sourcestransforming them into clean reliable analysisready information. If you enjoy being the data detective behind smart business decisions this is a role where you can truly make an impact.

This is a hybrid position based in Toronto.

Responsibilities include but are not limited to:

• 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 analysisready 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 decisionmaking

• 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

Required Qualifications

• 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 problemsolving skills with the ability to navigate ambiguity confidently

Preferred Experience

• Handson 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)

The base salary range for this position is CAD 55000 - CAD 85000 annually. The offered rate of compensation will be based on individual education experience qualifications and work location. All offers include access to a variety of benefits to employees including health insurance coverage an employee wellness program life and disability insurance retirement savings plan paid holidays and paid time off (PTO). This position is a current vacancy.

What if I dont meet every requirement At Everest we are dedicated to building an inclusive and authentic workplace. So if you are excited about this role but your past experience doesnt align perfectly with every element in the job description we still encourage you to apply. You may be just the right candidate for this or other roles. Please let us know if you need any accommodations throughout the application or interview process.

Our Culture

At Everest our purpose is to provide the world with protection. We help clients and businesses thrive fuel global economies and create sustainable value for our colleagues shareholders and the communities that we serve. We also pride ourselves on having a unique and inclusive culture which is driven by a unified set of values and behaviors. Clickhereto learn more about our culture.

• Our Valuesare the guiding principles that inform our decisions actions and behaviors. They are an expression of our culture and an integral part of how we work: Talent. Thoughtful assumption of risk. Execution. Efficiency. Humility. Leadership. Collaboration. Inclusion and Belonging.
• Our Colleague Behaviorsdefine how we operate and interact with each other no matter our location level or function: Respect everyone. Pursue better. Lead by example. Own our outcomes. Win together.

All colleagues are held accountable to upholding and supporting our values and behaviors across the company. This includes day to day interactions with fellow colleagues and the global communities we serve.

Type:

Time Type:

Primary Location:

Additional Locations: