Business Insight 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. Start your career at Farmers today! 
  
Job Summary 
  
  • Responsible for supporting Distribution objectives for acquisition, retention, cross-selling, and profitability by identifying, designing and implementing advanced analytic projects.
     
  • Coordinates with business partners including Sales, Marketing, IT, Product Management, Distribution, Finance and to understand the business challenges and opportunities to tailor data analytics efforts to meet their needs.
  • Serves as a key subject matter expert in data analytics that supports various growth models. 
  • Ability to gather an in depth knowledge of Farmers database architecture and data querying in order to create business requirements for data enhancements and data fixes that support Distribution functions.
     
  • Take leadership role in solving complex data problems by combining knowledge of property and casualty insurance business, macroeconomic variables, combining different data sources and statistical models to improve quality and/or productivity, reduce costs, and increase customer experience.
  • Leverages customer information such as transactional and behavioral data, demographic and attitudinal overlays, and primary and secondary research to make business decisions regarding areas of opportunity, segmentation of agents, planning, product development, competitive intelligence and other functional areas.
  • Leads Distribution analytics team projects while balancing multiple priorities and effectively communicating the benefits and limits of data modeling, data integrity, optimization, and data constraints.
     
  
Essential Job Functions 
  
  • Perform analytical studies (modeling, data analysis and reporting) focusing on core business initiatives and present findings to a broader audience.
  • Summarizes analytical data into user-friendly reports translating highly technical, detailed data into recommendations for corporate execution.
  • Create and maintain reports by querying and assembling data using programs such as Excel, SQL and performing statistical analysis using SAS or R programming.
     
  • Understands and prioritizes analytical needs to deliver solutions and drive implementation.
  • Provides quantitative analyses and statistical modeling that impact strategic decision-making.
  • Utilizes Relational Database Management System or RDBMS such as DB2 and SQL server to surface relevant analysis and opportunities to support client's key business objectives.
  • Serves as a team member on complex, strategic analysis projects ensuring high quality deliverables.
     
  • Present studies and relevant recommendations to management that drive efforts around innovation and profitability.
     
  • Validate new data to existing data to ensure that reports/models are accurate.
  • Provides feedback and insight on assignments while assisting with material analysis.
  • Performs competitive intelligence research and analysis leveraging internal and external data.
  • Delivers actionable program measurement and drives marketing tactics and strategy through data analytics.
  • Provides tactical marketing and analysis support to internal customers including: extensive customer profiling, segmentation, customer lifetime value analysis, response and attrition models, holistic customer business views, in-depth campaign assessment and local market opportunity, planning and analysis.
  • Identifies opportunities to generate revenue and cut costs by identifying potential new markets, monitoring customer shifts, purchasing patterns, etc.
  • 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. Functional ability of seeing, hearing, and speaking is required. 
  
Physical Environment 
  
Required job duties are normally performed in a climate controlled office environment, with occasional travel by car or airplane. 
  
Education Requirements 
  
Four-year college degree in Applied Math/Statistics, Computer Science, Business or related field. 
  
Experience Requirements 
  
At least three to five years analytics experience, data-driven decision making, business planning, marketing, or consulting with Farmers or equivalent external experience. Proficiency with Tableau data visualization tool.
  
Special Skill Requirement 
  
  • Minimum of 3 years of analytics experience
  • Highly skilled in using Microsoft Office software such as Excel (including formulas, calculations, charts, graphs, pivot tables, etc.), PowerPoint, Word, Outlook
  • High Proficiency with SQL and other data mining software and experience with scripting languages (e.g. R or Python)
  • Relational Database Management System management skills
  • Experience with Data Visualization tool such as Tableau
  • Ability to work independently and effectively in a team
  • Ability to teach others and be a great team player
  • Ability to create effective business partner relationships
  • Excellent verbal and written communication skills
  • Strong technical skills in marketing analysis, statistical analysis, mathematical modeling, optimization and simulation

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

Job Posting: 06/21/2019