Assistant Product Manager

Assistant Product ManagerFarmers (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. 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. Full time position. Apply by submitting your resumes at Farmers.com/Careers, Job ID: 33319 Farmers offers a competitive salary commensurate with experience, qualifications and location. Annual rate of pay: $113,256. Bonus Opportunity (based on Company and Individual Performance). 401(k). Medical. Dental. Vision. Health Savings and Flexible Spending Accounts. Life Insurance. Paid Time Off. Paid Parental Leave. Tuition Assistance. For more information, review "What we offer" on Farmers' Careers. Job Location(s): US - CA - WdlndHills-6301 Anticipated application deadline: At Farmers, the recruitment process is designed to ensure that we find the best talent to join our team. As part of this process, we typically close open positions within 8 to 21 days after posting. If you are interested in any of our open positions, we encourage you to submit your application promptly. Farmers will consider for employment all qualified applicants, including those with criminal histories, in accordance with the Los Angeles Fair Chance Initiative for Hiring Ordinance or other applicable law. Pursuant to 18 U.S.C. Section 1033, Farmers is prohibited from employing any individual who has been convicted of any criminal felony involving dishonesty or a breach of trust without prior written consent from the state Department of Insurance. It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability. Farmers is an Equal Opportunity Employer and does not discriminate in any employer/employee relations based on race, color, religion, gender, sexual orientation, gender expression, genetic information, national origin, age, disability, marital status, military and veteran's status, or any other basis protected by applicable discrimination laws. Want to learn more about our culture & opportunities? Check out Farmers' Careers and be sure to follow us on Instagram, LinkedIn, and TikTok. Spokane, WA only: Residents who prefer not to provide their address click here to submit your resume via email: careers@farmers.com.