Data Modeler - Remote

Position: Data Modeler - Initial Remote
Location: New York

1 month ago Be among the first 25 applicants

Role Title

Data Modeler

Role Location(s)

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

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
• Participate in a collaborative working environment using the agile methodology
• Provide technical leadership and guidance to business partners, peers and vendor partners
• Perform 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

Education Requirements

• BS in Computer Science, Information Management or Statistics

Primary Skill

APEX, Internet, Shell Scripting, Tableau Desktop

Seniority level

• Mid‑Senior level

Employment type

• Full‑time

Job function

• Other

Industries

• IT Services and IT Consulting

Additional Information

Referrals increase your chances of interviewing at The Dignify Solutions, LLC by 2x

Apply BELOW