Data Modeler

Data Modeler

Purchase, NY or New York, NY;
Florham Park, NJ;
Conshohocken, PA;
Charlotte, NC

Mid-Senior level

Full-time

Other

IT Services and IT Consulting

• 10+ years of BI/DW and data modeling experience
• 5 years of P&C insurance business and systems such as Guidewire Policy Center, Guidewire Claims Center, SAP FS-RI & SAP FS-CD is a huge plus
• Knowledge 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
• Strong interpersonal skills and ability to work as part of a team

Kibana