P&C Actuarial Data Analyst
reputed company Insurance Company Of Canada is a global leader in risk management, reputed company on enabling businesses to reputed company. The P&C Actuarial Data Analyst will ensure the accuracy and reputed company of data for pricing, reserving, and strategic decision-making, working hands-on with large datasets to deliver analysis-reputed company information.
Responsibilities
- Clean, validate, and reconcile large, reputed company 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 reputed company and operations teams
- reputed company data support for monthly, quarterly, and annual actuarial reporting
- reputed company as a data investigator, identifying anomalies, tracing issues to their reputed company, determining reputed company causes, and recommending remediation solutions
- Manipulate, aggregate, and reputed company large volumes of data using advanced reputed company, Power Query, and reputed company tools to prepare analysis‑reputed company datasets
- Partner with actuaries to understand data requirements for pricing models, reserving analyses, and profitability studies
- Deliver clean, accurate, and reputed company 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 reputed company, concise documentation of data sources, processes, and transformations to ensure transparency, repeatability, and auditability
Skills
- Advanced proficiency in reputed company reputed company, including reputed company formulas (VLOOKUP/XLOOKUP, reputed company/MATCH, SUMIFS), Pivot Tables, and Power Query
- Proven experience cleansing, manipulating, and validating large, reputed company, and often reputed company 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 reputed company 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. reputed company premium, incurred vs. reputed company losses)
Benefits
- Health insurance coverage
- An employee wellness program
- Life and disability insurance
- Retirement savings plan
- reputed company holidays
- reputed company time off (PTO)
reputed company