Data Analyst I

We are Farmers!

We are… more than just your favorite commercials.  At Farmers, we strive to deliver peace of mind to our customers by providing protection and comprehensive advice and delivering in the moments of truth. That means having people who can help us meet changing customer and business needs. Farmers high-performance culture is focused on results and the people who achieve them. We hold ourselves and others accountable for sustainably growing the business and each other. We seek solutions, own our actions, and grow through discomfort. We see setbacks as opportunities while continuously asking ourselves how we impact our customers.

Farmers is an award winning, equal opportunity employer, committed to the strength of a diverse workforce. We are dedicated to supporting the well-being of our people through our extensive suite of benefits, as well as the well-being of the communities we serve through employee volunteer programs and nonprofit partnerships. Helping others in their time of need isn’t just our business – it’s our culture!  To learn more about our high-performance culture and open opportunities, check out www.Farmers.com/careers/corporate and be sure to follow us on Instagram, LinkedIn, and TikTok.

Job Summary

Provide data in response to one-time or recurring requests for reports or analysis. Understand customer objectives and processes; effectively communicate system capabilities and limitations; and deliver available data. Analyze data quality and take corrective action. Analyze impact of system changes to data/reporting infrastructure (support testing and implementation activities).

Essential Job Functions

• Extract and manipulate data to solve business problems
• Respond to new requests for reports/data
• Understand customer objectives and processes
• Review and refine requirements and communicate estimated hours and timeline to complete
• Extract, blend and analyze data using PowerBI, Power Query, Snowflake, Alteryx, or similar business query interfaces
• Extract data directly from relational databases (e.g. Snowflake), data warehouses, or other data stores using SQL
• Create meaningful, data driven reports using Power BI or Excel to drive business decisions.
• Document process used to produce reports and dashboards in conformity with department expectations.
• Support application testing for enhancements or system upgrades
• Identify and communicate data quality issues or data differences.
• Implement Agile methodology to organize and streamline work prioritization.
• Communicate effectively with team members and business partners
• Be concise and precise in written communication
• Incorporate best practices in developing intuitive reports to share with a broad audience
• Describe and document unique aspects or limitations of data to aid understanding.
• Demonstrate business understanding
• Develop in-depth knowledge of data associated with Shared Services and effectively support their reporting and analysis needs
• Demonstrate commitment to lifelong learning.
• Exemplify good teamwork
• Provide excellent customer service by making realistic commitments and keeping them
• Work productively on assigned tasks
• Collaborate effectively with other team members
  
  

Physical Actions

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

Physical Environment

• Ideal candidate will reside within 50 miles of a Farmers hub location, but open to virtual applicants
• 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

Experience Requirements

• Internal Candidates: (Preferred) 2+ years of Farmers or other insurance claims experience. Technical experience that involves querying and manipulating data to address business problems.
  
  

Special Skill Requirement

• Microsoft 365 products proficiency, Alteryx, Power BI, SQL (Snowflake), SAP S4/HANA, BPC, Analysis for Office
  
  

Benefits

• Farmers offers a competitive salary commensurate with experience, qualifications and location.
• CA Only: $82,560 - $119,300
• CO Only: $77,360 - $103,200
• HI Only: $77,360 - $110,200
• IL Only: $77,360 - $110,200
• NY/ DC Only: $75,440 - $116,300
• Albany County: $82,560 - $103,200
• WA Only: $77,360 - $137,750
• Bonus Opportunity (based on Company and Individual Performance)
• 401(k)
• Medical
• Dental
• Vision
• Health Savings and Flexible Spending Accounts
• Life Insurance
• Paid Time Off
• Paid Parental Leave
• Tuition Assistance
• For more information, review “What we offer” on https://www.farmers.com/careers/corporate/#offer
  
  

Job Location(s): R_US - United States, US - AZ, US - CA, US - CA - WdlndHills-6301, US - CA - WdlndHills-6303, US - CO, US - FL, US - GA, US - IL, US - KS, US - MI, US - MN, US - MO, US - MO - StLouis-Olive, US - NV, US - OH, US - OK, US - OR, US - TX, US - TX - Dallas-DallasPy, US - TX - Grand Prarie

Candidate qualifications may be reviewed against the requirements for the associated levels of this positions core function

Anticipated application deadline: At Farmers, the recruitment process is designed to ensure that we find the best talent to join our team. As part of this process, the posting will be taken down on approximately 5/17/24. If you are interested in any of our open positions, we encourage you to submit your application promptly.

Want to learn more about our culture & opportunities? Check out www.Farmers.com/careers/corporate and be sure to follow us on Instagram, LinkedIn, and TikTok.