Data Analyst I
Los Angeles , California
October 20, 2017

We are Farmers!

Join a team of diverse professionals at Farmers to acquire skills on the job and apply your learned knowledge to future roles at Farmers. Farmers Insurance also offers extensive training opportunities through the award winning University of Farmers named by Training magazine amongst top 10 corporate training units in the world. Start your career at Farmers today!

Job Summary

The Data Analyst will perform complex analysis in an evolving data environment. In addition to very strong technical skills, this position requires to have superb analytical and communication skills. The ability to extract and analyze data, pattern, and related trends is needed; with the subsequent ability to create and execute business-centric test scenarios to ensure quality control standards are achieved.

Essential Job Functions

  • Responsible for analytic data needs of the business users
  • Develop SQL queries and support ad-hoc requests / reports.
  • Assess and measure quality of data in data warehouse, marts, and analytic dashboards
  • Perform data profiling and analysis and create data quality metrics/dashboards in Tableau to communicate results
  • Identify and troubleshoot data quality issues on new or existing analytics/reports.
  • Extract, load, and reconcile large amounts of data across multiple system platforms and sources to validate user-centric scenarios.
  • Identify data sources, develop data flow diagrams and document the process.
  • Review data to determine operational impacts and needed actions; elevate issues, trends, areas for improvement and opportunities to management.
  • Manage customer expectations and internal deliverables to ensure timely and efficient delivery of data analytics
  • Effective liaison with all relevant business stakeholders and system owners
  • Liaise among business stakeholders to elicit and communicate user-centric scenarios, data quality metrics, processes and procedures

Physical Actions

Required job duties are essentially sedentary work consisting of occasional walking, standing and lifting and/or carrying 10 lbs. maximum, and seeing.

Physical Environment

Required job duties are normally performed in a climate controlled office environment.

Education Requirements

Bachelor's degree in business, Statistics or computer science

Experience Requirements

Three years of related experience is required

Special Skill Requirement

  • Proficient skills in Data Mining
  • Proficient skills in Analytic Models
  • Advanced skills in SQL, SAS, Python, Toad, MS Office, VISIO
  • Proficient skills in Business Object and Tableau, IDQ (data profiling tool)
  • Knowledge of Informatica is preferred
  • Strong understanding of data warehouse/marts, data models, data relationships, reporting schemas, data transformations
  • Good interpersonal skills
  • Outstanding attention to detail
  • Ability to work with little or no supervision
  • Proven ability to meet established deadlines
  • Strong analytical and problem solving skills
  • Good multi-tasking skills
  • A strong drive for results
  • Demonstrated focus for customer satisfaction
  • Ability to function in a high volume setting with tight deadlines
  • Ability to collaborate effectively and work as part of a team
  • Good written and oral communication skills
  • Able to participate in and facilitate discussions with complex content

Farmers is an equal opportunity employer, committed to the strength of a diverse workforce.

A little about us:

Not ready to apply? Join our Talent Network.

Know someone who would be interested in this job? Share it with your network.