Data Warehouse Analyst - $85/hr Tallahassee
Location: Tallahassee
Posted on: October 19, 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
Click
here to apply!
|