Job Description :
Role: Database Modeler
Contract: 12+ months
Location: West Chester, PA

Job Description:
The successful candidate will create or modify data models.

Job Requisites:
7-10+ years in data modeling experience - at the logical and physical level, with a strong focus on dimensional modeling/OLAP
Understanding of normalization of entities and tables; ensure use of proper constraints, naming standards, data types & lengths.
Transform logical data model to physical data model.
Generate DDL from physical data model for database implementation.
Document data mapping - source to target.
Maintain metadata documentation/dictionary information in data modeling tool
Work closely with business analyst(s) and IT resources to decipher business requirements and translate them to a logical data model.
Good communication skills - able to explain and walk through design concepts to various resources (business, application development, management)
Retail experience

Required Technologies:
OLAP RDBMS (Teradata, Netezza), Data warehouse schemas (Star, Snowflake), dimensional data modeling, SQL Tools (AQT, SQL Navigator), Data modeling tools (Erwin 9.5 and Model Mart), Proficient with writing SQL

Client : Compunnel