Odyssey Systems · 1 month ago
Data Modeler
New York, NY
Full-time
Onsite
Senior Level
$110K/yr - $125K/yr
5+ years expOdyssey Group is a market-leading specialty insurer headquartered in New York City, seeking a Data Modeler to design and maintain enterprise data models. This role is crucial for establishing standardized data structures across their Azure data platform and involves collaboration with data engineers and business stakeholders to meet data requirements.
ConsultingProject ManagementTechnical Support
Responsibilities
Design, develop, and maintain conceptual, logical, and physical data models for enterprise data assets
Partner with data engineers to ensure models are properly implemented within the Azure Data Platform (e.g., Azure SQL, Synapse, or Data Lake)
Define and manage data standards, naming conventions, and metadata to ensure consistency and reusability across data domains
Collaborate with business stakeholders to analyze data requirements and ensure alignment with industry models such as ACORD for P&C insurance
Use Erwin Data Modeler to maintain version control, lineage, and documentation of data models
Support data governance efforts by maintaining high-quality metadata and complying with organizational data policies
Review data structures and integration designs to ensure scalability, performance, and data integrity
Collaborate with ETL and pipeline developers to align data ingestion and transformation logic with established data models
Participate in peer reviews, design sessions, and model walkthroughs to validate design choices
Qualification
Required
Bachelor's degree in Computer Science, Information Systems, or a related field (or equivalent experience)
5+ years of experience in data modeling within a data warehouse or analytics environment
Proficiency in Erwin Data Modeler (or similar data modeling tools)
Strong SQL skills and hands-on experience designing data models for Azure (SQL Database, Synapse, Data Lake, or Databricks)
In-depth understanding of data modeling principles (3NF, dimensional modeling, data vault, etc.)
Experience with P&C insurance data domains, such as policy, claims, billing, and reinsurance
Familiarity with ACORD data models and standards
Excellent analytical and communication skills with the ability to bridge technical and business perspectives
Preferred
Experience supporting data governance and metadata management programs
Knowledge of data lineage, impact analysis, and data catalog solutions
Exposure to Power BI or other reporting/semantic layer tools
Familiarity with data modeling automation or reverse engineering from existing databases
Benefits
This role may also be eligible to participate in a discretionary annual incentive program.
Company
Odyssey Systems
Odyssey Systems is a consultancy that offers acquisition, project management, medical research, technical support and training.
1001-5000 employees
Funding
Current Stage
Late StageLeadership Team
Matthew Kasberg
Chief Executive Officer
Bobby King
Vice President Operations
Recent News
Washington Technology
2025-10-28
Washington Technology
2025-09-16
Company data provided by crunchbase