This job has expired, please see additional jobs below
Reporting Data Analyst
Zurich Insurance Group
Woodland Hills, CA, United States
Job Details - this job has expired, please see similar jobs below
Description
This is a 1 Yr Contract position with benefits
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
Develops reports and delivers ad hoc data requests. Serves as a liaison between the Business and IT to provide solution to their business needs; Understands customers# objectives, processes, and products as well as the business systems capabilities; Performs impact analysis of making changes to application systems and supports development of effort/cost estimates; Develops and documents functional specifications; Supports application testing, implementation, and training activities.
Essential Job Functions
Extract data and develop reports using Cognos, OBIEE Answers, or similar business query interfaces. Executes report runs manually as necessary. Extract data directly from relational databases (e.g. Oracle, SQL Server), data warehouses, or other data stores using SQL. Delivers ad hoc data requests in Excel and Access or similar format. Produce reports manually and through automated scripting; create and maintain scripts and macros used to automate reports. Understands customer’s objectives, processes, and products in order to make educated recommendations. Supports application testing, implementation, and training activities. Performs quality review checks on project deliverables. Provides input as to architecture of requested reporting applications. Promotes safety at all times and complies with safety/ergonomic standards as outlined in relevant company published manuals.
Physical Actions
Required job duties are essentially sedentary in nature, consisting of occasion walking, standing, lifting and/or carrying ten pounds maximum, seeing, speaking, and hearing.
Physical Environment
Required job duties are normally performed in a climate-controlled office environment.
Education Requirements
Bachelors Degree required
Experience Requirements
2+ years’ experience with data extraction, manipulation and presentation in a useable format.
Special Skill Requirements
• MS Excel: advanced proficiency (Pivot Tables, Pivot Charts, AutoFilter and Formulas)
• BI query tools: advanced proficiency in Cognos, OBIEE Answers, Statistica, TOAD, Tableau (preferred)
• SQL: proficient with complicated queries (many tables, many joins, complex data relationships, large databases) (preferred).
Farmers is an equal opportunity employer, committed to the strength of a diverse workforce.