Farmers Insurance Business Insight Analyst II in Woodland Hills, California
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!
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.
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.
Required job duties are normally performed in a climate controlled office environment, with occasional travel by car or airplane.
Four-year college degree in Applied Math/Statistics, Computer Science, Business or related field.
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.
Job: *Strategic Management & Administration
Organization: *Farmers Insurance
Title: Business Insight Analyst II
Location: California-Woodland Hills
Requisition ID: 190006S2