Commercial Product Analyst

Job Description

  
We are Farmers! 
  
Join a team of diverse professionals at Farmers to acquire skills on the job and apply your learned knowledge to future roles at Farmers. Farmers Insurance also offers extensive training opportunities through the award winning University of Farmers named by Training magazine amongst top 10 corporate training units in the world.

Want to learn more about our culture & opportunities? Check out farmers.com/careers and be sure to follow us on Instagram and LinkedIn!

  
Job Summary 
  
Analyzes existing procedures; Develops recommendations for improvements & refinements; handles routine problems stemming from inquiries from region; maintains existing forms, records and procedures. 
  
Essential Job Functions 
  
Reviews Commercial systems (including, but not limited to, CLS, Mainfile, Reinsurance) processing and recommends design changes to improve processing or incorporate coverage/underwriting rule changes. Develops test matrices, provides review and sign off for Commercial systems testing. Provides assistance to Home Office and Regional Commercial departments regarding rating methodology and systems processing. Handles to completion Regional inquiries or correspondence, including PCSTs and telephone calls; routes as necessary to other departments and does follow up to insure timely completion. Coordinates new and revised procedures with necessary staff departments; drafts memos, manual pages and procedure bulletins as necessary. Conducts studies as requested by supervisor and recommends modifications or refinements required as a result of changes in policies or programs. Reviews Field Bulletins, training and Marketing materials for accuracy as regards operations or procedures. Conducts Field travel as necessary to Regional Offices or vendors. Performs other functions as assigned. 
  
Physical Actions 
  
Required job duties are essentially sedentary work consisting of occasional walking standing and lifting and/or carrying 10 lbs. maximum. 
  
Physical Environment 
  
Required job duties are normally performed in a climate controlled office environment. 
  
Education Requirements 
  
Four year college degree is preferred but not required – preferably in Math, Statistics, Finance, Economics or Data Analytics
  
Experience Requirements 
  
For applicants without a four year degree, three years with Farmers Insurance Group as a Senior Commercial Service Analyst. 
  
Special Skill Requirement 
  
  • Moderate to advanced Microsoft Excel experience (Pivot Tables, Formulas, V-lookup, etc.) 
  • SAS or SQL is highly preferred but not required
  • Strong aptitude and ability to learn different analytical tools/programs
  
Farmers is an equal opportunity employer, committed to the strength of a diverse workforce. 
 

Schedule: Full-time

Job Posting: 03/26/2020