Assistant Product Manager

Farmers Insurance Careers•Los Angeles, CA

4h•$113,256•Hybrid

About The Position

Farmers (Woodland Hills, CA) seeks an Assistant Product Manager to lead and guide peers in developing a more robust data extraction framework to support future scalability and efficiency. Specific duties include: lead and guide peers in identifying potential new data sources and developing a more robust data extraction framework using Python and SQL to support future scalability and efficiency (20%); lead development, improvement, and troubleshooting of premium change tools while guiding actuarial and analytics teams to optimize use and streamline data debugging (25%); conduct training sessions to guide employees in navigating and extracting structured data from complex files using effective tools (10%); extract and clean large datasets from sources such as Cloud data (Snowflake) and XML/JSON files (10%); analyze internal loss ratio data and develop business proposal on rate and underwriting actions to ensure the state hits financial goals (15%); and utilize actuarial knowledge in P&C (Property and Casualty) insurance to interpret pricing tool outputs and investigate unexpected values (20%). Option to work remotely with required travel to local offices 3 days/week, if within 50 miles of remote worksite.

Requirements

Position requires a Bachelor’s degree, or foreign equivalent, in Analytics, or a closely related field of study, plus 5 years of experience in the job offered, or as a Product Analyst, or similar data science or pricing actuarial position.
In the alternative will accept a Master’s degree, or foreign equivalent, in Analytics, or a closely related field of study, plus 2 years of experience in the job offered, or as a Product Analyst, or similar data science or pricing actuarial position.
Must have 2 years of experience with each of the following: working in P&C insurance industry, including working within Personal Lines; automating data ingestion pipelines using Python and SQL to streamline preprocessing; using R, Snowflake, Jupyter Notebooks, SAS, and Git; developing a process to parse and extract specific data fields from structured XML and JSON files for further analysis; creating dashboards using Power BI and Plotly to communicate insights to stakeholders; developing and implementing pricing tools for personal lines using actuarial concepts and theories; analyzing large insurance datasets to identify trends, loss drivers, and segmentation opportunities; and partnering with underwriting, product, and finance teams to align pricing strategies with business goals.
Option to work remotely with required travel to local offices 3 days/week, if within 50 miles of remote worksite.

Responsibilities

lead and guide peers in identifying potential new data sources and developing a more robust data extraction framework using Python and SQL to support future scalability and efficiency (20%)
lead development, improvement, and troubleshooting of premium change tools while guiding actuarial and analytics teams to optimize use and streamline data debugging (25%)
conduct training sessions to guide employees in navigating and extracting structured data from complex files using effective tools (10%)
extract and clean large datasets from sources such as Cloud data (Snowflake) and XML/JSON files (10%)
analyze internal loss ratio data and develop business proposal on rate and underwriting actions to ensure the state hits financial goals (15%)
utilize actuarial knowledge in P&C (Property and Casualty) insurance to interpret pricing tool outputs and investigate unexpected values (20%)