Description

You will design and implement relational and dimensional data modeling solutions to support enterprise requirements.

Responsibilities

• Design conceptual, logical, and physical data models in collaboration with Data Architects and DBAs.
• Conduct reverse engineering of existing data systems to construct as-is models and identify foundational structures.
• Lead offshore teams in creating source-to-target mappings based on established data model designs.
• Develop and mature data modeling standards, guidelines, and naming conventions for P&C Commercial/Specialty line products.
• Translate business requirements into technical designs and engineer DDL according to ACORD standards.

Required Skills

• 10+ years of experience in enterprise-level data modeling.
• Expertise in Conceptual, Logical, and Physical modeling, including 3NF and Dimensional modeling.
• Proficiency with Erwin for ER diagramming and database design.
• Strong experience in Database Design, Normalization, and Data Warehousing.
• Advanced SQL skills and experience with relational databases.
• Proven ability to gather and translate business requirements into technical physical designs.
• Experience with P&C Commercial/Specialty line products and ACORD standards.
• Strong analytical skills for collecting and organizing complex data sets.
• Ability to support business reporting needs, including aggregated and hierarchical data.

Key Skills

Education

Any Gradute