Data Modeler

Data Modeler

The Data Modeler is responsible for defining and managing critical data structures for current and future needs. The primary responsibilities are to gather business requirements and translate them into logical data models, and to create technical design specifications including source to target mapping documentation for ETL developers.

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

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