Sr. Data Modeler job vacancy

Vacancy expired!

Position: Data Modeler

Project Locations: Florham Park, NJ OR

Conshohocken, PA OR

Purchase, NY OR

New York OR

Charlotte, NC. (

Candidate has to be on-site at any Project Location and can work as per HYBRID model)

Project Duration: 6 months to start with possibility of extension

Technical Qualifications Required:

10+ years of BI/DW and data modeling experience
4+ years of Property & Casualty Insurance business and systems such as Guidewire Policy Center, Guidewire Claims Center, (SAP FS-RI & SAP FS-CD is a huge plus, NOT required)
Strong Knowledge and experience of
Data Warehousing, ETL and
BI architectures, concepts and
frameworks
Deep knowledge of
Kimball and
Inmon approaches and the core differences
Experience in
data modeling principles/methods including
conceptual, logical &
physical Data Models
Capable of facilitating data discovery sessions involving business subject matter experts
Experience in
translating/mapping relational data models into Data Base Schemas
Experience with
modeling tools (such as ERWin and ER/Studio)
Knowledge of
RDBMS platforms (e.g. SQL Server, DB2) with experience in generating DDL)
Ability to create and maintain conceptual/business, logical and physical data models
Ability to translate a logical model into a physical model, adding appropriate physical objects needed to create the database e.g. indexes
Experience maintaining a model repository
Ability to synchronize models to ensure that database structures match models
Familiar with metadata ingestion and translation
BS in Computer Science, Information Management or Statistics