[Hiring] Data Analyst @Farmers Insurance

Role Description

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 data using Cognos ReportNet, OBIEE Answers, or similar business query interfaces.
• Extract data directly from relational databases (e.g. Oracle, SQL Server), data warehouses, or other data stores using SQL.
• Format data for business use in Excel, Access, or similar format.
• Produce reports manually and through automated scripting; create and maintain scripts and macros used to automate reports.
• Support application testing for enhancements or system upgrades; identify and communicate data quality issues or data differences.
• Communicate effectively:
• 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 at least one line of business (LOB), and effectively support the data needs of that LOB.
• Demonstrate commitment to lifelong learning.
• Exemplify good teamwork:
• Proactively communicate with customers and team members.
• Provide excellent customer service by making realistic commitments and keeping them.
• Work productively on assigned tasks.
• Collaborate effectively with other team members.
• Demonstrate accountability to management and customers for hours spent on assigned tasks.
• Diligently strive to deliver value in the fewest possible hours.

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

• 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, in Information Systems or related field.

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.
• External Candidates: 2+ years experience with data extraction, manipulation and presentation in usable format.

Special Skill Requirement

• MS Excel: advanced proficiency (Pivot Tables, Pivot Charts, AutoFilter, and formulas).
• BI query tools: proficient in Cognos ReportNet, OBIEE Answers, BusinessObjects, STATISTICA (preferred), or similar systems.
• MS Access: proficient with loading data, writing queries, and manipulating data.
• SQL: proficient with basic queries involving a few tables and limited criteria.

Benefits

• This position offers a competitive compensation and benefits package designed to support your wellbeing, growth, and work–life balance.
• While specific benefits may vary by country and employee level, offerings generally include competitive salary opportunities, performance-based bonuses, comprehensive benefits, and ongoing training and development resources.

Important Hiring Conditions and Disclosures

• Personal Data Processing: The personal data provided during the recruitment and selection process will be collected, processed, and retained for legitimate recruitment and compliance purposes, in accordance with applicable data protection and privacy laws and FBS internal policies.
• Legal Authorization to Work: Employment with FBS is conditional upon the candidate having valid, local legal authorization to work in the country where the role is based at the time of hire. FBS does not sponsor or obtain work authorization unless explicitly stated.
• Exclusivity of Employment and Conflict of Interest: Upon acceptance of an offer and during employment with FBS, employees will not be permitted to engage in parallel employment, professional activities, or paid work for other entities. Any ownership, partnership, directorship, or participation in other businesses or companies must be fully disclosed and formally reviewed in accordance with FBS internal conflict-of-interest and external engagement policies prior to the start date or as soon as such circumstances arise. Failure to comply with these conditions may impact the hiring decision or employment continuation.