Hybrid Personal Lines State Management Product Analyst, I, II, Sr.

at Farmers Insurance

• Job title: Personal Lines State Management Product Analyst, I, II, Sr.
• Job type: Full Time
• Experience level: Senior
• Salary: $76,375 - $137,940 per year
• Degree requirement: High School Diploma
• Tech skills: SQL
• Location requirements: Hybrid, Spokane, United States

About the role

• Analyst positions within Farmers' Personal Lines State Management Team driving product strategies and revenue growth through data analysis and communication with state offices.

Responsibilities

• Sr. Product Analyst: Analyzes information using data correlation, and statistical analysis. Develops data and information structure. Creates and modifies computer programs to extract information from company databases. Prepares state indications and other analyses of loss experience, retention, and expense data. Suggests enhancements to standard methodologies. Performs primary field research, including customer, distribution, competitor, insurance department, and market surveys. Works with State Offices to support rate proposal and marketing plan development. Identifies market segments and develops specialized pricing approaches. Prepares exhibits for state filings and responds to requests from regulators for additional data. Provides detailed requirements for systems implementation projects. Measures and monitors performance of states, initiatives, and identified segments. Facilitates through other parts of the organization to accomplish results. Performs other duties as assigned.
• Product Analyst II: Analyzes information using data manipulation, correlation, and statistical analysis. Modifies computer programs to extract information from company databases. Prepares state indications and other analyses of loss experience, retention, and expense data. Responsible for development of data and information structure. Performs primary field research, including customer, distribution, competitor, insurance department, and market surveys. Identifies market segments and develops specialized pricing approaches. Measures and monitors performance of states, initiatives, and identified segments Facilitates through other parts of the organization to accomplish results. Performs other duties as assigned.
• Product Analyst I: Maintains contact with State Offices and Personal Lines Marketing to benefit product development activities. Analyzes, researches and creates new personal lines insurance products which are likely to be implemented territory-wide. Coordinates development and implementation of new personal lines insurance products with other functional departments; chairs coordinating meetings where assigned. Initiates preparation and publication of procedure bulletins, field bulletins and marketing kits regarding the introduction of new products. Follows up regularly with other functional departments, Agents/District Managers, State Offices and Service Centers to verify that new products have been implemented correctly. Performs other duties as assigned.

Requirements

• 3 years experience in similar role or one year in Product Analyst II role
• 2 years of related experience or 1.5 years in Product Analyst I role
• Strong analytical and problem-solving skills with a keen attention to detail
• Technical skills with platforms such as SAS, SQL, Excel, PowerBI preferred
• Strong Excel (vlookups, pivot tables) spreadsheets and databases;
• other tools such as SQL, PowerBI, SAS preferred
• Word and basic programming for statistical purposes for the Sr. Product Analyst level role
• Excellent verbal/written communication skills, including ability to make effective presentations and for the Sr. Product Analyst role ability to write articles publishable in trade magazines
• Self-motivated, organized, and able to manage multiple priorities in a fast-paced environment
• Goal oriented team player with a positive attitude
• Excellent time management skills
• Strong relationship building.

Benefits

• 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