Sr. Data Modeler – Remote/Hybrid Position Available In Philadelphia, Pennsylvania

Job summary:

Title:

Sr. Data Modeler

• Remote/Hybrid Location:

  Philadelphia, PA, USA Length and terms: Long term

• W2 or C2C Position created on 06/23/2025 07:05 pm Job description:
• Webcam interview
• Long term project
• Remote/Onsite

•

Description:

Note:

Remote is ok with limited travel once a month

• Philadelphia PA Primary/must 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. Contact the recruiter working on this position: The recruiter working on this position is Sowmya Pasarla His/her contact number is His/her contact email is sowmya.p@msysinc.com Our recruiters will be more than happy to help you to get this contract.