Sr Data Modeler (Property and Casualty)

Must have Property and Casualty (P&C) Insurance Domain experience.

Role Summary:
Were seeking a handson Data Modeler to design and evolve enterprisegrade data models that make diverse source data consumptionready for reporting analytics and advanced insights. You will translate business requirements into conceptual logical and physical designs (3NF and dimensional) establish and enforce data standards and naming conventions and collaborate across Architecture BA Engineering and DBA teams to deliver performant governed and scalable models.

Responsibilities:

Model design & documentation: Create ERDs and data models (conceptual logical physical) for relational (3NF) and dimensional (star/snowflake) structures; maintain comprehensive documentation (data dictionaries entity/attribute catalogs glossaries).
Assist with the development and maturing of data modeling standards guidelines processes and procedure for P&C Insurance.

Multisource harmonization: Analyze and reverseengineer asis structures from varied source systems; design canonical and conformed models to unify and standardize data for enterprise use.

Requirements translation: Partner with Information Architecture and Business Analysis to convert business concepts into precise technical designs S2T (sourcetotarget) mappings and DDL with clear integrity rules.

Physical design alignment: Work with Data Architects and DBAs to validate physical design choices (partitioning indexing constraints) and ensure alignment to performance reliability and governance SLAs.

Analytics & reporting enablement: Model aggregated and hierarchical structures and define fact/dimension layers including SCD policies and conformed dimensions to power BI selfservice and operational reporting.

Standards & governance: Establish and enforce enterprise data standards (definitions naming keys relationships) embed data quality and lineage considerations and support stewardship and audit needs.

Reference/master data: Define approaches to unify identifiers and entities across systems (goldenrecord rules survivorship conformance strategies).
Collaboration & leadership: Guide onshore/offshore contributors on modeling deliverables review cycles and documentation; facilitate stakeholder reviews and signoffs.
Continuous improvement: Contribute to modeling standards templates and checklists; advocate reusable patterns across subject areas and lines of business.

Required Skills & Experience

Strong datamodeling expertise using ER diagrams and tools such as Erwin (or ER/Studio equivalent).

Proven delivery of conceptual logical and physical models at enterprise scale spanning 3NF and dimensional approaches.

Ability to gather and translate business requirements into clear technical designs S2T mappings and DDL (keys constraints indexes).

SQL proficiency and deep understanding of database design normalization referential integrity and performance considerations.

Experience designing for aggregated & hierarchical reporting SCD policies and conformed dimensions.

Effective collaboration with Architecture/BA/DBA/Engineering teams; excellent written and verbal communication skills.

High attention to detail consistency and data quality across large and complex datasets