Data Modeler jobs in United States
cer-icon
Apply on Employer Site
company-logo

Hudson Insurance Group · 4 hours ago

Data Modeler

positionNew York, NY
timeFull-time
remoteOnsite
senioritySenior Level
money$110K/yr - $125K/yr
date5+ years exp

Hudson Insurance Group is a market-leading specialty insurer headquartered in New York City, seeking a Data Modeler to design, develop, and maintain enterprise data models that support their evolving data ecosystem. The role involves collaborating with data engineers, analysts, and business stakeholders to translate business requirements into logical and physical data models while ensuring compliance with data standards and governance initiatives.

Financial ServicesInsurance
check
H1B Sponsor Likelynote

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

Data modelingErwin Data ModelerSQLAzure Data PlatformP&C insurance dataACORD standardsAnalytical skillsCommunication skills

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

Hudson Insurance Group

twittertwitter
company-logo
Headquartered in New York City with offices throughout the U.S.
dateFounded in 1918
location
New City, New York, USA
people-size201-500 employees
web-link
http://www.hudsoninsgroup.com

H1B Sponsorship

Hudson Insurance Group has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2023 (1)
2022 (1)

Funding

Current Stage
Growth Stage

Leadership Team

leader-logo
Christopher L. Gallagher
President & CEO
linkedin
leader-logo
John Verbich
CFO
linkedin
Company data provided by crunchbase