Reporting Analyst

CAA Insurance Company; Vaughan; On-site; CAD 85,000 - 115,000; Full time

Benefits offered by this job

Wellness program

Education reimbursement

Rewards and discounts

Defined contribution plan

Travel incentives

Job summary

CAA Club Group in Thornhill is seeking an Actuarial Analytics professional to analyze insurance performance and provide data-driven recommendations for growth. You will develop and maintain performance reports using EDW data to inform management decisions.

The candidate should have a degree in Mathematics, Economics or Actuarial Science, 3-5 years of data reporting in financial services, and strong Power BI and Python skills. SQL/VBA and MS Office are assets; designations are a plus.

Qualifications

• 3-5 years data reporting experience in the financial services industry. P&C Insurance industry experience is a definite asset.
• Forecast reporting, data collection, data analysis, report generation and quality assurance experience is required
• Professional designation preferred but not required: CIP/FCIP, CA. CMA. CPA, CGA or equivalent
• Database Administration experience is a preferred asset
• Working experience with MS Office products, SQL or database query tools including VBM and VBA is an asset
• Power BI and Python experience are required

Responsibilities

• Analyze insurance performance historical data to understand the reasons for past performance and make recommendations that will influence the business growth and/or address portfolio / business concerns
• Conduct regular, ongoing reviews on the sales performance measurements for each distribution channels, as well as portfolio analysis to assess quality of business being written
• Recommend changes or adherence to prudent underwriting guidelines and practices
• Respond to business needs by identifying appropriate information to analyze utilizing a variety of sources in data mining
• Identify, understand, and communicate profitability drivers while collaborating with multi distribution channels, claims and accounting areas
• Find ways to automate reports based on user requests or by observing frequency of ad-hoc reports being requested
• Identify opportunities and responding to changes to ensure adherence to the corporate business success strategy
• Communicate and consult proposed changes in underwriting rules, guidelines, practices and gaps based on findings
• Provide Insurance field trend analysis, forecasts reports and findings that anticipate outcome
• Ability to utilize EDW data / GW data, industry information and trend analysis to provide management recommendations
• Provide detailed analysis of statistics that are outside of anticipated norms

Skills

Power BI

Python

SQL

Data analysis

Data reporting

MS Office

Education

Bachelor's degree in Mathematics, Economics or Actuarial Science

Tools

VBM

VBA

Job description

Requisition ID7511-Posted11/04/2026-Actuarial Analytics-Insurance Operations-THORNHILL-Insurance-CAA Club Group-Mid-Career-0 - 10%-Full Time- Job Location (country) (1) - Job Location (region) (1)

For over 50 years,our Property and Casualty insurance Company, CAA Insurance,has provided dependable and trustworthy service to protect Canadians and what matters to them. CAA Insurance Company offers a dynamic professional environment which strives to offer the ultimate customer experience. We share in each other’s successes, drive change and support each other while cultivating a great working environment to deliver on what is best for the customer.

Who we are

At CCG, we are committed to delivering an exceptional Associate experience. We offer:

Work-life harmony with access to an award-winning holistic wellness program,
Continuous learning through our robust corporate curriculum and education reimbursement program,
Incredible rewards, travel incentives, and product and service discounts,
Pay-for-performance and best-in-class recognition programs, and
Competitive benefits that include a defined contribution plan, personal spending account, and so much more.

Join our growing team where everyone belongs!

What You Will Do:

• Analyze insurance performance historical data to understand the reasons for past performance and make recommendations that will influence the business growth and/or address portfolio / business concerns
• Conduct regular, ongoing reviews on the sales performance measurements for each distribution channels, as well as portfolio analysis to assess quality of business being written
• Recommend changes or adherence to prudent underwriting guidelines and practices
• Respond to business needs by identifying appropriate information to analyze utilizing a variety of sources in data mining
• Identify, understand, and communicate profitability drivers while collaborating with multi distribution channels, claims and accounting areas
• Find ways to automate reports based on user requests or by observing frequency of ad-hoc reports being requested
• Identify opportunities and responding to changes to ensure adherence to the corporate business success strategy
• Communicate and consult proposed changes in underwriting rules, guidelines, practices and gaps based on findings
• Provide Insurance field trend analysis, forecasts reports and findings that anticipate outcome
• Ability to utilize EDW data / GW data, industry information and trend analysis to provide management recommendations
• Provide detailed analysis of statistics that are outside of anticipated norms

Who You Are:

• University Degree in Mathematics, Economics or Actuarial Science
• 3-5 years data reporting experience in the financial services industry. P&C Insurance industry experience is a definite asset.
• Forecast reporting, data collection, data analysis, report generation and quality assurance experience is required
• Professional designation preferred but not required: CIP/FCIP, CA. CMA. CPA, CGA or equivalent
• Database Administration experience is a preferred asset
• Working experience with MS Office products, SQL or database query tools including VBM and VBA is an asset
• Power BI and Python experience are required
• Excellent interpersonal, verbal and written communication skills
• Excellent problem solver, detail oriented, ability to work in a team environment as well as work independently
• Strong analytical and decision‑making skills

Please note that we may use AI tools to help us through the recruitment process.

Our Commitment

We are an equal opportunity employer and are committed to providing employment accommodation in accordance with the Ontario Human Rights Code and the Accessibility for Ontarians with Disabilities Act, 2005 (AODA). CAA CCG will provide accommodations to job applicants with disabilities throughout the recruitment process. If you require an accommodation, please notify us and we will work with you to meet your needs.