Data Modeler

Role: Data Modeler

Job Type:- Full Time or Contract

Location: Purchase, NY; Florham Park, NJ; NYC,NY; Charlotte, NC;

Rate: Market

Years of Experience Required- 10+ Years

Job Description -

ROLE RESPONSIBILITIES

• Develop entity relationships (ER models) for normalized and dimensional models
• Assist and guide existing Data Modelers and Data Architects
• Technical evaluation for assignments involving existing models for legacy applications and creation of new model in support of application development
• Work closely with the ETL, BI, DBA and other teams to develop appropriate data models
• Participates in collaborative working environment using the agile methodology
• Provide technical leadership and guidance to business partners, peers and vendor partners

Performs related duties as assigned or requested TECHNICAL QUALIFICATIONS

• 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