Data Analytics Specialist - SQL/Python (Toronto)

Data Analytics Specialist - SQL/Python (Toronto)

04 Aug
|
CNA Canada
|
Toronto

04 Aug

CNA Canada

Toronto

Senior Data Analytics ConsultantApplylocations: Posted Todayjob requisition id: And we have the leadership to help you get there. As part of the Canadian Actuarial team, this role is responsible for delivering catastrophe (CAT) exposure analytics and pricing support for the Canadian portfolio, providing insights through portfolio analysis as well as regulatory and reinsurance reporting. The position works closely with the US Catastrophe Modeling team, bridging teams across geographies to ensure consistent methodology, shared expertise, and informed risk evaluation.

The role partners closely with underwriting, actuarial, and enterprise risk management teams, while contributing to data governance and ongoing analytics and data modernization initiatives. Lead CAT exposure monitoring and portfolio analytics, including monthly Probable Maximum Loss (PML) and Average Annual Loss (AAL) analysis, portfolio aggregation, and key account-level insights.

Explain the impact of various catastrophe modeling metrics, attributes, and assumptions to various stakeholders Perform detailed exposure analysis at account and location levels, including loss attribution and sensitivity testing, with delivery of executive-level reporting.

This includes exposure tracking, impact assessment, communication of insights during active events, and supporting preparedness planning.

Support regulatory and actuarial reporting, including CAT-related inputs for regulatory reporting.

Provide analytics to help Business Unit leadership understand their portfolio’s exposure and how it can further improve profitability.

Provide analytical support for reinsurance and capital modeling, including exposure preparation, treaty analysis, and scenario-based capital insights.

Act as a data steward for exposure and portfolio data, including validation, quality control, and establishment of data governance and standards.





Deliver regular reporting and insights to senior leadership and act as a liaison across actuarial, underwriting, enterprise risk management and operations teams.

Contribute to actuarial data modernization and tooling initiatives, including development of rating engine requirements, data architecture, and integration of analytics tools.

Other ad hoc data analysis as required.Commercial insurance knowledge is a plus.

Strong proficiency with SQL.

Experience programming in a language such as VBA, R, or Python is desired.

Advanced technical knowledge of financial and statistical practices, procedures and principles, which may include a specialty area. Ability to analyze data and provide valuable insights.

Robust knowledge of Microsoft Office Suite and other enterprise business tools, including responsible use of AI‐enabled technologies (such as Copilot or similar) to enhance efficiency, analysis and workflow in accordance with company policies.

Solid project management, organization and planning skills with the ability to manage multiple projects effectively.Education & Experience Bachelor's Degree in a relevant discipline such as Actuarial Sciences, Statistics, Mathematics, Computer Science, Engineering, or equivalent* Typically a minimum of seven years of related experience.

- Data Science or related certifications preferredOur Total Rewards philosophy reflects our commitment to building a high-performing, inclusive culture where every team member is empowered to grow, contribute, and thrive. We value the unique strengths and perspectives each individual brings to our business, our clients, and our communities. The base salary range for this position is $90,000 to $105,000, complemented by a comprehensive and competitive perks package to help our employees – and their family members – achieve their physical, financial, emotional, and social wellbeing goals. Base salary determinations are based on various factors, including but not limited to, relevant work experience, skills, certifications and location.

📌 Data Analytics Specialist - SQL/Python (Toronto)
🏢 CNA Canada
📍 Toronto

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: data analytics specialist - sql/python (toronto) / toronto

Subscribe to this job alert:

Get the latest job offers by email for: data analytics specialist - sql/python (toronto) / toronto