Description

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

Key Skills
Education

Any Gradute

Back To Jobs