Role Summary

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

Back to Search

Role Summary

HIGHLIGHTS

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

Role Summary

HIGHLIGHTS

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