Data Warehouse Analyst - $85/hr Tallahassee

Location: Tallahassee
Posted on: November 20, 2024

Job Description:

This Data Warehouse Analyst Position Features:

Title: (1) Data Warehouse Analyst

Work Schedule: M-F, 8:00 am ? 5:00 pm OR 7:30 am ? 4:30 pm (FLEXIBLE)

Start Date: ASAP - Assignment End Date: 12/31/2014 (3 months)

Bill Rate: $75.00 - $85.00 / hour

Location: Tallahassee, FL

A Data Warehouse Analyst is needed in the Enterprise Information Management group to perform data integration (ETL - Extract-Transform-Load) activities. This resource will work on the Clearinghouse to CDW Data Integration project and the CAIS V2 to V3 and Generic Assignment Module project for CDW.

Position Summary:

This position is responsible for data analysis, data modeling and data mapping for the Data Warehouse solution of the Core Guidewire project. The Data Warehouse Data Analyst will work closely with the Data Warehouse staff and use their knowledge of the Guidewire application, data model, and database to develop data models and data maps for the Guidewire Data Mart and enterprise Data Warehouse. Candidates may have a background in Business Analysis, Systems Analysis, Data Warehouse Design, and/or Data Warehouse ETL (Extract-Transform-Load) requirements.

Essential Functions:

? Analyzes Guidewire source system data to understand the data structure, definitions and anomalies.

? Interacts with customers as needed to better define and understand the general reporting requirements.

? Interacts with other technical team members to establish Data Warehouse data model requirements and designs.

? Designs data structures, data models and data mappings for the Guidewire Data Mart and an Enterprise Data Warehouse solution.

? Design, develop and publish standard data dictionary reports for each data model produced.

? Develop data management documentation for communication and education to the Business and Information Technology communities.

Required Knowledge, Skills, and Abilities:

? Knowledge of the Guidewire application, data model and data structures

? Knowledge of Relational, Star Schema and Dimensional database modeling techniques.

? Knowledge of Denormalized and Reporting table database modeling techniques.

? Strong quantitative, data analysis and analytical skills.

? SQL query, SQL DML (Data Manipulation Language) and relational database design skills.

? Ability to read, interpret and develop Data Flow Diagrams.

Required Education:

? Minimum three years experience with the Guidewire application, data model and data structures

? Minimum two years experience developing data mappings, data models and data dictionaries

? Property & Casualty insurance experience is strongly desired, two years experience is preferred

? Large data warehouse projects experience is strongly desired, two years experience is preferred

? Data modeling tool experience is preferred, such as ERWin, PowerDesigner, or Embarcadero.

? Computer literacy in Microsoft Word, Excel and Outlook, required. We are an equal employment opportunity employer and will consider all qualified candidates without regard to disability or protected veteran status.

Keywords: , Tallahassee , Data Warehouse Analyst - $85/hr Tallahassee, IT / Software / Systems , Tallahassee, Florida