Sr. Data Modeler (P&C Insurance Domain only)

Job Title: Sr. Data Modeler

Location: Remote but need to visit client once a month (Philadelphia, PA)

Duration: C2C

Job Description:

Primary skills: P&C Insurance (commercial/Specialty Lines), Data Modelling, SQL, Data warehousing, ER tools

Responsibilities

• Design and implement data modeling solutions using relational and/or dimensional databases based on need.
• Work closely with Data Architects to design databases or data warehouses using a mixture of conceptual, logical and physical data models.
• Assist with the development and maturing of data modeling standards, guidelines, processes, and procedure for P&C Commercial/ Specialty line products.
• Conduct evaluations of existing project data systems, including constructing as-is data models (reverse engineer) and identifying foundational data model. Make recommendations for how data should be modeled based on the results of completed evaluations.
• Lead offshore team with source to target mappings based on data model design.
• Maintain basic understanding of all ACORD standards and responsible for engineering DDL with respect to P&C Commercial/ Specialty line products.

Requirements

• Strong Data Modeling experience using ER diagrams, using tools like Erwin.
• Strong proficiency and experience in Data modeling (Conceptual, Logical, Physical, 3nF, Dimensional) at enterprise level.
• Gathering and translating business requirements into technical designs and development of the physical aspects of a specified design.
• Experience in Database Design, Normalization, Conceptual, Logical and Physical data modeling using Erwin.
• Data modelling experience for P&C Commercial / Specialty line products.
• Collaborate with Information Architecture and Business Analysis teams in the formulation of requirements for data across all product lines
• Have strong analytical skills with the ability to collect, organize, analyze and collect amounts of information with attention to detail and accuracy.
• Understand Business reporting data needs (Aggregated & Hierarchical data & etc ) and support reporting team needs.
• Review with Data architect, DBA to align on physical design
• Make sure Data Model changes are designed as per the Enterprise Data Standard with appropriate Naming standards.
• Effective communication and collaboration skills, with the ability to effectively interact with stakeholders at all levels.