Farmers Insurance

Business Solutions Analyst

Farmers Insurance

full-time

Posted on:

Location Type: Hybrid

Location: Woodland HillsCaliforniaUnited States

Visit company website

Explore more

AI Apply
Apply

Salary

💰 $158,808 per year

Tech Stack

About the role

  • partners with business teams to design and implement complex data and analytics-centric and value-added systems and solutions that enable business outcomes
  • develops complex value-based analytics solutions for quality, business process functionality, or other strategic/data/analytic initiatives that are complex in nature
  • collaborates with cross-functional teams to identify and establish analytics requirements
  • creates detailed documentation and business plans that address stakeholder needs
  • liaises between IT, data science/R&D teams and Product Management for analytics models and data solutions
  • develops and implements complex enterprise-wide data integration strategies that utilize various data-marts and data warehouse applications to enhance reporting
  • continuously works across departments with a variety of stakeholders to develop and execute project plans, improve data platforms, dashboards, and reports to meet emerging and changing business demands and guidelines
  • consults with minimal guidance on UAT, technical specifications, strategic planning, contract design, technical support, testing updates, and trainings
  • learns and uses new Microsoft Office Products, SQL, and other tools to extract data and build dashboards

Requirements

  • Bachelor’s degree, or foreign equivalent, in Business Administration, Finance, or a closely related field
  • 5 years of experience in the job offered, or as a Product Analyst, Business Analyst, or similar analyst position
  • 3 years of experience with each of the following:
  • working in P&C insurance industry;
  • coding in SQL including Tables, Window Functions, Case Statements, and Partition;
  • working with Excel analytical tools, including pivot tables, charts, data validation, and what-if / scenario analyses;
  • working with Excel data management tools, including data tables, linking across files, nested formulas, array formulas and data cleaning;
  • working with Power BI Dashboards and metric builds.
Benefits
  • 401(k)
  • Medical
  • Dental
  • Vision
  • Health Savings and Flexible Spending Accounts
  • Life Insurance
  • Paid Time Off
  • Paid Parental Leave
  • Tuition Assistance
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
data analyticsdata integrationdata warehousingSQLExcelPower BIUATtechnical specificationsproject planningdata cleaning
Soft Skills
collaborationcommunicationstakeholder managementproblem-solvingstrategic planning