Data Modeler

About the role

Design and maintain enterprise data models supporting P&C insurance business processes. Analyze business requirements and translate them into conceptual, logical, and physical data models. Develop and maintain data dictionaries, metadata repositories, and data lineage documentation. Work closely with Business Analysts, Product Owners, Data Architects, and Engineering teams. Create source-to-target mappings and ensure data model alignment with business requirements. Implement data modeling standards, governance, and best practices. Support data warehouse, data lake, lakehouse, and operational data store initiatives. Define and optimize dimensional models for reporting and analytics. Participate in data quality, master data management, and data governance initiatives. Collaborate with ETL/ELT teams to ensure efficient data integration and transformation. Assist in performance tuning and database optimization activities. Ensure compliance with regulatory and insurance reporting requirements.

Responsibilities

• Analyze business requirements and translate them into conceptual, logical, and physical data models.
• Create and maintain data dictionaries, metadata repositories, and data lineage documentation.
• Work closely with Business Analysts, Product Owners, Data Architects, and Engineering teams.
• Create source-to-target mappings and ensure data model alignment with business requirements.
• Implement data modeling standards, governance, and best practices.
• Support data warehouse, data lake, lakehouse, and operational data store initiatives.
• Define and optimize dimensional models for reporting and analytics.
• Participate in data quality, master data management, and data governance initiatives.
• Collaborate with ETL/ELT teams to ensure efficient data integration and transformation.
• Afford performance tuning and database optimization activities.
• Ensure compliance with regulatory and insurance reporting requirements.

Requirements

Commensurate with experience.

Qualifications

• 12+ years of experience in data modeling and design.
• Experience with P&C insurance industry preferred.
• Strong analytical skills and ability to translate business requirements into technical solutions.
• Proficiency in data modeling tools such as ERwin, TOAD, or similar.
• Knowledge of data warehousing, data lakes, and data governance principles.
• Experience with SQL and data query languages.
• Excellent communication and collaboration skills.

Skills

• Data modeling and design.
• Data warehousing and data lakes.
• Data governance and compliance.
• ETL/ELT development and optimization.
• SQL and data query languages.

Benefits

N/A

Pay

N/A

Schedule

N/A