Previous Job
Data Modeler
Ref No.: 18-04285
Location: New York, New York
Position Type:Right to Hire
Start Date: 04/17/2018
Data Modeler
Rate: DOE
Durration: Contract to Hire
Start: ASAP


1. Extensive data modeling experience - Normalized ER modeling and dimensional modeling. In dimensional modeling, the resource should be able to demonstrate hands-on experience in designing slowly changing dimensions, understanding and implementation of the CDC process, metrics design.
2. Should be comfortable modeling right from the conceptual modeling to logical and physical modeling.
3. Should be able to sound data modeling standards knowledge, approach to requirements gathering, physical model translations etc.
4. Should show in-depth skills in database layer, semantic layer architectures.
5. In Depth understanding of data warehouse architecture. Expertise with Hadoop (Hive, Spark, Scala, Impala) , Teradata is preferred.
6. Extensive experience in using various data modeling tools. This is to include the following:
a. Creating models from scratch
b. Reverse engineering databases and structures from flat files.
c. Creation of multiple physical models from single logical models
d. Database creation & DDL generation
e. Building data dictionary
f. PowerDesigner model reportingg. PowerDesigner repository setup and management
7. The candidate should have experience working with ETL and data visualization / analytics teams since modeling and data design will need to cater to the individual requirements during the physical modeling process.