Farmers Insurance
is hiring
Data Analyst
About Our Company
The companies comprising the Farmers Insurance Group of Companies® currently make up one of the country's largest insurers of vehicles, homes and small businesses, and provide a wide range of other specialty insurance and financial services products.
In business since 1928, today at Farmers® we proudly serve more than 10 million households with more than 19 million individual insurance policies across all 50 states through the efforts of nearly 48,000 exclusive and independent agents and approximately 21,000 employees. Our experience provides a rich history and legacy of service and strong customer relationships, while our focus on smart innovation, technology and entrepreneurship helps us to stay creative, to continually improve our product offerings and to drive the evolution of the insurance industry. Farmers Insurance Exchange®, the largest of the three primary insurance insurers that make up Farmers Insurance, is recognized as one of the largest U.S. companies on the 2017 Fortune 500 list.
At Farmers®, we understand that every encounter with customers is an opportunity to differentiate ourselves with our personalized service and have an overall positive impact on their lives. We pride ourselves on helping the individuals and businesses we serve become smarter and better prepared to protect the things that matter most to them.
We are also deeply committed to giving back. The Farmers culture is built around opportunities to volunteer and help improve the communities in which we work and live.
Job Description & Responsibilities
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
Requirements
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
What we offer
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.
