The Dignify Solutions, LLC
4 weeks ago Be among the first 25 applicants
Role Summary And Responsibilities
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.
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
REQUIRED TECHNICAL QUALIFICATIONS (in Order Of Level Of Need)
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
Primary Skill: Kibana, Load Balancing
Seniority level
Mid-Senior level
Employment type
Full-time
Job function
Other
Industries
IT Services and IT Consulting
Jersey City, NJ $110,000.00-$120,000.00
#J-18808-Ljbffr
Role Summary And Responsibilities
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.
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
REQUIRED TECHNICAL QUALIFICATIONS (in Order Of Level Of Need)
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
Primary Skill: Kibana, Load Balancing
Seniority level
Mid-Senior level
Employment type
Full-time
Job function
Other
Industries
IT Services and IT Consulting
Jersey City, NJ $110,000.00-$120,000.00
#J-18808-Ljbffr