acturhire
CompaniesBlog
Log in
CompaniesBlogBrowse JobsPost a JobPrivacy PolicyTerms and Conditions
© 2026 Acturhire. All rights reserved.
acturhire
CompaniesBlog
Log in
Back to Search

Role Summary

Loading...

HIGHLIGHTS

Associate-level data analyst supporting P&C portfolios at Gallagher (Keenan) in Torrance, CA. You will extract, clean, and visualize policy, claims, and financial data using SQL, Power BI and Excel, and build reporting and automation for underwriting and actuarial teams. Role supports pricing and reserving model data preparation and loss forecasting.

JOB DESCRIPTION SUMMARY

  • Prepare and reconcile policy, claims, and financial data for underwriting and actuarial use
  • Build dashboards and custom reports using Power BI and Excel
  • Use SQL to extract data and automate reporting processes
  • Support pricing and reserving model data preparation and loss forecasting
  • Flexible/remote work environment with Torrance, CA location

DOMAIN EXPERTISE

  • Policy, claims, and financial data analysis
  • P&C premium and loss ratio reporting
  • Treaty data analysis and claims coding
  • Data preparation for pricing and reserving models

KEY REQUIREMENTS

  • Minimum of 2 years’ experience in a data analyst role
  • Proficiency with SQL, Power BI, and Excel
  • Strong analytical and problem-solving skills
  • Ability to collaborate with underwriting, finance, IT, and actuarial teams

TECH STACK

  • Excel
  • Power_BI
  • Tableau
  • PowerPoint
acturhire
CompaniesBlog
Log in

Role Summary

Loading...

HIGHLIGHTS

Associate-level data analyst supporting P&C portfolios at Gallagher (Keenan) in Torrance, CA. You will extract, clean, and visualize policy, claims, and financial data using SQL, Power BI and Excel, and build reporting and automation for underwriting and actuarial teams. Role supports pricing and reserving model data preparation and loss forecasting.

JOB DESCRIPTION SUMMARY

  • Prepare and reconcile policy, claims, and financial data for underwriting and actuarial use
  • Build dashboards and custom reports using Power BI and Excel
  • Use SQL to extract data and automate reporting processes
  • Support pricing and reserving model data preparation and loss forecasting
  • Flexible/remote work environment with Torrance, CA location

DOMAIN EXPERTISE

  • Policy, claims, and financial data analysis
  • P&C premium and loss ratio reporting
  • Treaty data analysis and claims coding
  • Data preparation for pricing and reserving models

KEY REQUIREMENTS

  • Minimum of 2 years’ experience in a data analyst role
  • Proficiency with SQL, Power BI, and Excel
  • Strong analytical and problem-solving skills
  • Ability to collaborate with underwriting, finance, IT, and actuarial teams

TECH STACK

  • Excel
  • Power_BI
  • Tableau
  • PowerPoint

Job Overview

Salary
$60k - $75k
Years of Experience
2+ Years
Work Type
Permanent
Full Time

Ideal Candidate Profile

An Associate-level data analyst with 2+ years’ insurance or analytics experience, strong SQL and Power BI skills, and familiarity with P&C policy and claims data who enjoys building automated reports to support pricing and reserving.

Benefits

Health InsuranceDental InsuranceLife Insurance401(k) PlanHSA/FSA AvailableTuition ReimbursementPaid Parental LeaveTraining BudgetWellness ProgramFlexible Hours
Shortlist Forming
Closing Soon
27d
27 days ago

Strategy: Speed over Perfection

By Day 21, visibility drops significantly. Recruiters are focusing on existing candidates.

"Don't wait for a cover letter. The requisition could close tomorrow. Apply now."

Job Overview

Salary
$60k - $75k
Years of Experience
2+ Years
Work Type
Permanent
Full Time

Ideal Candidate Profile

An Associate-level data analyst with 2+ years’ insurance or analytics experience, strong SQL and Power BI skills, and familiarity with P&C policy and claims data who enjoys building automated reports to support pricing and reserving.

Benefits

Health InsuranceDental InsuranceLife Insurance401(k) PlanHSA/FSA AvailableTuition ReimbursementPaid Parental LeaveTraining BudgetWellness ProgramFlexible Hours
Shortlist Forming
Closing Soon
27d
27 days ago

Strategy: Speed over Perfection

By Day 21, visibility drops significantly. Recruiters are focusing on existing candidates.

"Don't wait for a cover letter. The requisition could close tomorrow. Apply now."

Similar Opportunities

Gallagher
1mo ago

Senior Consultant: Post Employment Benefits

Gallagher • Berwyn, United States

$76k - $148k
Gallagher
1mo ago

Senior Vice President

Gallagher • Berwyn, United States

$161k - $313k
Gallagher
1mo ago

U.S Internship - Actuary

Gallagher • Rolling Meadows, United States

$48k - $60k

Similar Opportunities

Gallagher
1mo ago

Senior Consultant: Post Employment Benefits

Gallagher • Berwyn, United States

$76k - $148k
Gallagher
1mo ago

Senior Vice President

Gallagher • Berwyn, United States

$161k - $313k
Gallagher
1mo ago

U.S Internship - Actuary

Gallagher • Rolling Meadows, United States

$48k - $60k
P&C/Broker/IC Level
Gallagher

Data Analyst

Gallagher•Torrance, California, United States•3w ago
FlexibleWorkers CompCommercial PropertyGeneral LiabilityBusiness Intelligence & ReportingData EngineeringPricing & Rating