Design and maintain: Conceptual Data Models reflecting business entities and relationships Logical Data Models with normalized structures, attributes, and rules Physical Data Models optimized for Lakehouse (Client / Parquetbased) storage Ensure models support multisource integration, including: Legacy RQI systems Guidewire platform (PolicyCenter, ClaimCenter, BillingCenter as applicable) Lakehouse & Modern Data Platform Alignment Design models aligned with Lakehouse architecture principles, supporting both: Operational analytics and reporting Advanced analytics and downstream data products Work closely with data engineers to ensure models align with medallion architecture (Bronze/Silver/Gold) patterns. Data Modeler Tera data Expr with Cloud - (Unity) SQL Server Strong experience in Property & Casualty (P&C) Insurance, specifically: WC, CMP, General Liability, Umbrella Policy, premium, coverage, exposure, claims, and risk entities Hands-on experience working with OMG Insurance Industry Data Model (customization and extension).