F

Farmers Insurance

Multiline insurer of auto and home

Fbs – Mexico - Business System Analyst, SQL & Power BI, Remote

Data AnalysisUpdated on Nov 14
Full-timeRemote in MexicoRemote

About the Job

Requirements

  • A high school diploma or equivalent is required.
  • External candidates must have at least 2 years of experience extracting and manipulating data and presenting it in a usable format.
  • Internal candidates are preferred to have at least 2 years of Farmers or other insurance claims experience and technical experience querying and manipulating data to address business problems.
  • Advanced proficiency in Microsoft Excel, including Pivot Tables, Pivot Charts, AutoFilter, and formulas.
  • Proficiency in business intelligence query tools such as Cognos ReportNet, OBIEE Answers, BusinessObjects, or similar systems.
  • Proficiency in Microsoft Access, including loading data, writing queries, and manipulating data.
  • Proficiency in SQL for basic queries involving a few tables and limited criteria.
  • Ability to type proficiently.
  • Ability to perform essentially sedentary work with occasional walking, standing, and lifting or carrying up to 10 pounds; functional ability to see, hear, and speak.

Responsibilities

  • Provide data in response to one-time or recurring requests for reports or analysis.
  • Understand customer objectives and processes, communicate system capabilities and limitations, and deliver available data.
  • Analyze data quality and take corrective action.
  • Analyze the impact of system changes to data and reporting infrastructure, and support testing and implementation activities.
  • Extract and manipulate data to solve business problems.
  • Respond to new requests for reports or data by understanding customer objectives and processes, reviewing and refining requirements, and communicating estimated hours and timelines.
  • Extract data using Cognos ReportNet, OBIEE Answers, or similar business query interfaces.
  • Extract data directly from relational databases, data warehouses, or other data stores using SQL.
  • Format data for business use in Excel, Access, or a 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, and identify and communicate data quality issues or data differences.
  • Use best practices to develop intuitive reports for broad audiences, and describe and document unique aspects or limitations of data to aid understanding.
  • Develop in-depth knowledge of data associated with at least one line of business and support that line of business's data needs.
  • Proactively communicate with customers and team members; make realistic commitments and keep them; work productively on assigned tasks; collaborate with team members; account to management and customers for hours spent on assigned tasks; and deliver value efficiently.
  • Work in a climate-controlled office, with occasional travel by car or airplane.

Desired Qualifications

  • A bachelor's degree in Information Systems or a related field is preferred.
  • Proficiency in STATISTICA is preferred.

About the Company

Farmers Insurance

Multiline insurer of auto and home

Farmers Insurance Group offers auto, home, life, and business insurance plus related financial services across all 50 states. Policies are underwritten and supported by risk management and claims handling, with sales through a mix of exclusive and independent agents who focus on long-term relationships. It stands out by combining nationwide coverage with a multiline product lineup and an emphasis on ongoing service and cross-selling rather than one-off transactions. Its goal is to protect customers’ assets and finances with reliable coverage while growing its business through lasting relationships.

Company size
10,001+
Company stage
Debt Financing
Total funding
$300M
Headquarters
Los Angeles, CA
Founded
1928

Recently Posted Jobs

Explore more opportunities at Farmers Insurance

See more jobs