Data Analyst

Job Description

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 
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). Contribute data and expertise to the success of complex analysis projects. 
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 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;
  • Scope and deliver data for analytic purposes (data designed for the construction of advanced mathematical models); measure, document, and address data quality issues; maintain datasets and dataset documentation; and contribute knowledge and expertise to the success of the project
Communicate effectively:
  • Be concise and precise in written communication;
  • Incorporate best practices in developing intuitive reports to share with a broad audience; and
  • Describe and document unique aspects or limitations of data to aid understanding.
Demonstrate business understanding:
  • Develop in-depth knowledge of data associated with multiple lines of business (LOBs), and effectively support the data needs of those LOBs
  • 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;
  • Share effective SQL or other data extraction/manipulation techniques with team members;
  • Debug problems with report automation or queries; propose and implement remedies
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 and Master's degree, preferably in Information Systems or related field, preferred.
Experience Requirements 
4+ years' experience with data extraction, manipulation, and presentation in usable format  
Special Skill Requirement 
  • SQL: proficient with complicated queries (many tables, many joins, complex data relationships, large databases)
  • Report automation: proficient with scripting tools and languages (batch files and VBA for Excel)
  • Communication: professional, concise, and precise in verbal and written communication
  • Microsoft SQL Server, T-SQL
  • Oracle, PL/SQL
  • SSIS, Alteryx and Tableau preferred
Farmers is an equal opportunity employer, committed to the strength of a diverse workforce. 

Schedule: Full-time

Job Posting: 08/16/2019