Description

You will design and develop conceptual, logical, and physical data models to support operational and analytical requirements.

Responsibilities

• Design and develop conceptual, logical, and physical data models aligned with industry standards like ACORD.
• Translate complex business requirements from underwriting, claims, actuarial, and finance teams into scalable data structures.
• Optimize data models for performance, integrity, and scalability across source systems, data lakes, and data warehouses.
• Collaborate with data governance teams to define data standards, dictionaries, and metadata.
• Document data models, mappings, and lineage using tools such as ER/Studio, Erwin, or PowerDesigner.
• Mentor junior modelers and analysts on data design best practices.

Required Skills

• 7+ years of experience in data modeling.
• 3+ years of experience in the Property & Casualty Insurance domain.
• Deep knowledge of P&C insurance data, including policy, claims, billing, and customer data.
• Expertise in conceptual, logical, and physical data modeling techniques.
• Strong command of SQL.
• Experience with relational databases including Oracle and SQL Server.
• Experience with cloud platforms such as AWS, Azure, or GCP.
• Proficiency with data modeling tools like Erwin or ER/Studio.
• Knowledge of data governance, data quality, and metadata management.
• Experience with ETL processes and data pipeline collaboration.
• Bachelor's or Master's degree in Computer Science, Information Systems, Data Science, or a related field.

Preferred Skills

• Experience with Databricks cloud data platforms.
• Familiarity with ACORD or IBM Insurance Data Warehouse models.
• Understanding of data lake and lakehouse architecture.
• Experience working in Agile/Scrum environments.

Key Skills

Education

Bachelor's or Master's degrees