IT Data Analyst - SQL proficient

company banner
Farmers Insurance
Analysis, Analyst, Automated, Customer Service, DB2, Excel, Management, Release, SAS, Scripts, SQL, SQL Server, Testing
Full Time, Full Time
Work from home not available Travel not required

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

Reconcile data after data loads into the personal lines data marts. Analyze the root causes of data variances. Communicate the results to the business stakeholders to obtain the release of the new data in the data marts. Analyze the system changes to automated scripts & reconciliation tableau reports and make the necessary changes.

Essential Job Functions

  • Extract data directly from relational databases (e.g. DB2, SQL Server), data warehouses, or other data stores using SQL or SAS.
  • Format data for business use in Excel, Access, or similar format.
  • Reconcile data in the target to the sources and analyze the root causes of the data variances.
  • Produce reports manually and through automated scripting and Tableau.
  • 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.
  • 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: E ssentially 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: 2+ years experience with data extraction, analysis, manipulation, reconciliation and presentation in usable format, Farmers or other insurance experience is preferred.

Special Skill Requirement

  • MS Excel: advanced proficiency (Pivot Tables, Pivot Charts, AutoFilter, and formulas).

  • SQL: proficient with queries involving multiple tables.

  • Tableau experience is preferred.

  • SAS knowledge will be a plus.

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

Schedule: Full-time

Job Posting: 07/03/2019

Company Information

Creative, innovative, collaborative—if this describes you as an IT professional, Farmers® is a great place to build your career. IT at Farmers means working outside of traditional business and technology silos to not only ensure the security of our systems, but to develop forward-thinking products to help improve the experience of millions of Farmers customers. On the Farmers IT team, sharing knowledge and creating new tools is central to the daily work, and helps to power our company culture.
Dice Id : 80153772
Position Id : 190003R6

Similar Positions at Farmers Insurance

IT Business Intelligence Reporting Administrator
  • Woodland Hills, CA
  • 2 days ago
IT Database Administrator - Woodland Hills, CA
  • Woodland Hills, CA
  • 2 days ago
IT DocuSign Engineer - Woodland Hills, CA
  • Woodland Hills, CA
  • 2 days ago
Data Management Specialist
  • Woodland Hills, CA
  • 2 days ago
ETL Subject Matter Expert
  • Woodland Hills, CA
  • 2 days ago
QA Automation Engineer
  • Woodland Hills, CA
  • 2 days ago
Senior Software QA Engineer
  • Woodland Hills, CA
  • 2 days ago
Informatica Cloud Developer
  • Woodland Hills, CA
  • 2 days ago
Data Steward
  • Multiple,
  • 2 days ago