Sr. Data Modeler,

About the Role

We are looking for a skilled Data Modeler to design, develop, and maintain scalable enterprise data models that support business intelligence, analytics, and operational reporting. The ideal candidate will collaborate closely with business analysts, data engineers, architects, and stakeholders to translate business requirements into robust, scalable data models while ensuring adherence to enterprise data governance standards. Experience in the insurance industry, particularly underwriting or broker data, is highly preferred.

Responsibilities

• Design and maintain conceptual, logical, and physical data models for enterprise data platforms.
• Develop dimensional data models (Star Schema, Snowflake Schema) to support reporting, analytics, and business intelligence initiatives.
• Perform source system analysis and create comprehensive Source-to-Target Mapping (STTM) documentation.
• Collaborate with business analysts and stakeholders to understand business requirements and translate them into scalable data models.
• Work closely with Data Engineering teams to support data integration, ETL/ELT, and cloud data platform initiatives.
• Validate data models against business requirements and ensure consistency across enterprise systems.
• Define and maintain data dictionaries, metadata repositories, and business glossaries.
• Support enterprise data governance initiatives, including metadata management, data lineage, and data quality.
• Review and optimize existing data models for performance, scalability, and maintainability.
• Produce and maintain comprehensive documentation for data models, standards, and design decisions.
• Participate in data architecture reviews and recommend best practices for enterprise data management.

Requirements

• Bachelor's degree in Computer Science, Information Systems, Engineering, Mathematics, or a related field.
• 5+ years of experience in data modeling (12+ years for Senior Data Modeler roles).
• Strong experience with:
  • Dimensional Data Modeling
  • Logical Data Modeling
  • Physical Data Modeling
  • Enterprise Data Modeling
  • Source-to-Target Mapping (STTM)
  • SQL
• Experience designing data models for enterprise data warehouse environments.
• Strong understanding of relational databases and normalization/de-normalization techniques.
• Experience collaborating with business analysts, data engineers, architects, and business stakeholders.
• Excellent documentation and communication skills.

Preferred Qualifications

• Insurance industry experience, particularly in:
  • Underwriting
  • Broker data
  • Policy and Claims data
• Familiarity with Databricks and Microsoft Azure cloud platforms.
• Experience with enterprise metadata management and data governance initiatives.
• Hands-on experience with industry-standard data modeling tools such as:
  • ERwin Data Modeler
  • ER/Studio
  • SAP PowerDesigner
  • Oracle SQL Developer Data Modeler
  • IBM InfoSphere Data Architect
• Knowledge of modern data lake and lakehouse architectures.
• Experience supporting Agile/Scrum development environments.

Skills

• Logical Data Modeling
• Physical Data Modeling
• Conceptual Data Modeling
• Dimensional Modeling
• Enterprise Data Modeling
• Source-to-Target Mapping (STTM)
• SQL (Advanced)
• Data Warehouse Design
• Metadata Management
• Data Governance
• Data Lineage
• Databricks (Preferred)
• Microsoft Azure (Preferred)

Domain Expertise

• Insurance
• Underwriting
• Broker Data
• Policy Administration
• Claims Data
• Enterprise Data Warehousing

Position type: W2 contract