Senior Data Modeler

Role: Senior Data Modeler
Location: Purchase, NY; Florham Park, NJ, Conshohocken, PA
Duration: Long term
Rate: Market
Job Description-

• 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
Tuesday- Thursday Remote