Lead Data Modeler - BI Data Modernization

Who Are We?

Taking care of our customers, our communities and each other. That’s the Travelers Promise. By honoring this commitment, we have maintained our reputation as one of the best property casualty insurers in the industry for over 170 years. Join us to discover a culture that is rooted in innovation and thrives on collaboration. Imagine loving what you do and where you do it.

Technology

The annual base salary range provided for this position is a nationwide market range and represents a broad range of salaries for this role across the country. The actual salary for this position will be determined by a number of factors, including the scope, complexity and location of the role; the skills, education, training, credentials and experience of the candidate; and other conditions of employment.

As part of our comprehensive compensation and benefits program, employees are also eligible for performance-based cash incentive awards.

$ - $

1

We are seeking an experienced Lead Data Modeler with deep insurance industry knowledge to join our data management team. This role will be responsible for designing, developing, and maintaining enterprise data models specifically for Business Insurance operations while ensuring adherence to data governance standards and industry best practices.

• Design and develop data models that accurately represent complex business insurance concepts, processes, and relationships
• Model insurance-specific entities including policies, claims, underwriting, risk assessment, and regulatory reporting
• Collaborate with architects, business leaders and technical teams to ensure data models support critical insurance operations
• Ensure data models accommodate various business insurance product lines (commercial property, liability, workers' compensation, etc.)

• Create comprehensive logical and physical data models to support business insurance requirements
• Develop conceptual, logical, and physical data models for complex enterprise insurance systems
• Ensure data models align with insurance business processes and support both operational and analytical needs
• Design models that support regulatory compliance and industry reporting requirements

• Implement and maintain data governance frameworks specific to insurance operations
• Establish and enforce data standards, naming conventions, and modeling best practices for insurance data
• Ensure compliance with insurance regulatory requirements (state regulations, NAIC standards, etc.)
• Participate in data governance committees and provide insurance domain expertise

• Leverage industry standard models, with particular expertise in Object Management Group (OMG) standards
• Adapt and customize industry models to meet organizational insurance requirements
• Stay current with insurance industry modeling trends and emerging standards

• Utilize Erwin Data Modeler for all modeling activities, including:
• Complete model comparison and analysis for insurance data structures
• Generation of comprehensive modeling reports for stakeholder review
• DDL (Data Definition Language) creation and deployment for insurance databases
• Implementation of model naming conventions aligned with insurance standards
• Effective use of import functions for model integration and updates

• Bachelor’s Degree in STEM related field or equivalent.
• 5+ years of experience in data modeling and database design within the insurance industry.
• Deep understanding of commercial insurance products, underwriting processes, claims management, and regulatory requirements.
• Experience with insurance data concepts including policy administration, claims processing, and risk management.
• Familiarity with insurance industry standards and regulatory frameworks.
• Extensive experience in logical and physical data modeling with proven track record in insurance environments.
• Strong experience implementing data governance frameworks within insurance organizations.
• Deep knowledge of industry models, specifically Object Management Group (OMG) standards and methodologies.
• Advanced proficiency in Erwin Data Modeler, including:
• Complete compare functionality for insurance model analysis
• Report generation capabilities for business stakeholder communication.
• DDL creation and database deployment for insurance systems.
• Model naming conventions and standardization for insurance entities.
• Import function utilization for model integration and updates.
• Proven experience in enterprise-level insurance data modeling projects.
• Experience working with insurance business stakeholders, IT teams, and regulatory compliance groups.
• Strong analytical and problem-solving abilities with insurance domain context.
• Excellent communication skills with ability to explain technical concepts to insurance professionals.
• Experience with multiple database platforms supporting insurance…