Business Analyst II

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. Start your career at Farmers today! 
Job Summary:

Responsible for analysis of data related to particular lines of business. This position requires strong skills in quantitative analysis, communication (verbal and written), and business understanding, including the ability to identify trends and recommend changes to systems or processes that can improve results. Responsible for ad-hoc and recurring data extraction and analysis; also contributes to larger advanced analytical (data modeling) projects. Works closely with Underwriting leadership (managers, directors, and above) to deliver the necessary support and insight to improve decision-making.


Essential Job Functions:

Analyze data to solve business problems:

  • Think critically about data required and possible analysis approaches to solve business problems

  • Understand and apply the scientific method (hypothesize, experiment/test, and learn)

  • Possess intermediate computation skills
  • Understand relational databases and how to extract and manipulate data using business query interfaces

  • Produce ad-hoc and recurring reports and analyses as assigned
  • Perform analysis using Excel, Access, and similar applications
  • Conduct Internet research as needed
  • Use standard statistical or business intelligence packages to perform analysis

  • Interpret results obtained from these packages
  • Effectively use graphical techniques to visually explore and present data

  • Understand statistical inference#its scope, limitations, and proper role in business analysis

  • Express generally posed business problems in a statistical context
  • Understand how to obtain a suitable sample from a population and how to make inferences from that sample

  • Apply commonly used analytic techniques to reveal insights from data.

  • Communicate effectively:
  • Be concise and precise in written communication
  • Incorporate best practices in developing intuitive reports to share with a broad audience

  • Document approaches or unique aspects of data to aid understanding
  • Create impactful PowerPoint presentations to summarize results of analysis projects;

  • Deliver presentations to business partners#effectively explain complicated concepts, analysis conclusions, and business implications

  • Understand insurance and business concepts
  • Understand the business rules and business processes of multiple lines of business

  • Apply understanding of the principles of management, accounting, finance, and marketing

  • Understand and apply the principles of optimization (seeking to maximize value given competing/scarce resources)

  • Demonstrate commitment to lifelong learning
  • Exemplify good teamwork
  • Proactively communicate with customers and team members
  • Provide excellent customer service by making realistic commitments and keeping them

  • Work productively on assigned tasks
  • Collaborate effectively with other team members
  • Demonstrate accountability to management and customers for hours spent on assigned tasks

  • Diligently strive to deliver value in the fewest possible hours

Physical Actions:

  • Essentially sedentary work consisting of occasional walking, standing, and lifting/carrying 10 lbs. maximum
  • Functional ability of seeing, hearing and speakingAbility to type proficiently

Physical Environment:

Work in a climate-controlled office, with occasional travel by car or airplane

Education Requirements:

High school diploma or equivalent required. Bachelor's degree preferred. Completion of, or actively pursuing, a major insurance designation # (Preferred) Masters degree in related area (e.g. Statistics, Finance, Business Administration).

Experience Requirements:


Four years of experience with business reporting and analysis, understanding a business problem, gathering requirements and data, applying quantitative and qualitative analysis techniques to the data, and sharing analysis/report results as well as:


  • Advanced ability to conduct detailed analysis of data
  • Advanced ability to develop executive facing reports
  • Ability to self-manage, upward manage, and lead with influence 

  •  Excellent written and verbal communication skills
  • Ability to read a room and communicate with the audience 
  • Strong attention to details
  • Quick to adapt to change 
  • Advanced with Excel and PPT

Special Skill Requirements:

  • MS Excel: advanced proficiency (Pivot Tables, Pivot Charts, AutoFilter, and formulas)

  • BI query tools: advanced proficiency in querying and manipulating data (Cognos ReportNet OBIEE Answers

  • Microsoft Access, or similar)
  • Quantitative analysis: proficient with descriptive statistics, data profiling, advanced data visualization techniques, and some advanced analysis methods (e.g. simulation, regression) STATISTICA experience is a plus

  • Business process: experience in claims handling/management; knowledge of relevant business rules and data associated with those rules

  • Farmers transactional systems: advanced understanding of workflow and data features arising from workflow and business rules

  • MS PowerPoint: proficient in creating logical, impactful presentations

  • Communication: professional, concise, and precise in both written and verbal communication

Farmers is an equal opportunity employer, committed to the strength of a diverse workforce. 
Schedule: Full-time

Job Posting: 08/16/2019