Data Modeler
About Us
Headquartered in New York City with offices throughout the U.S. and in Vancouver, Canada, Hudson is a market-leading specialty insurer that offers a wide range of property and casualty insurance products to corporations, professional firms and individuals through retailers, wholesalers and program administrators. Hudson underwrites specialty primary and excess insurance on an admitted basis through Hudson Insurance Company and on a non-admitted basis through Hudson Excess Insurance Company. Hudson Insurance Company is admitted in all U.S. jurisdictions. Hudson has surplus lines eligibility in all U.S. jurisdictions through Hudson Excess Insurance Company. Collectively known as Hudson Insurance Group, its companies are rated A+ (Superior) by A.M. Best, Financial Size Category XV. Hudson Insurance Group is the U.S. Insurance Division of OdysseyRe, a leading worldwide underwriter of reinsurance and specialty insurance and wholly-owned by Fairfax Financial Holdings Limited.
Position Description
Hudson Insurance Group is seeking a Data Modeler to design, develop, and maintain enterprise data models that support our evolving data ecosystem. This role is pivotal in establishing standardized, scalable, and well-governed data structures across our Azure data platform. The ideal candidate will bring a strong understanding of P&C insurance data domains, experience with Erwin Data Modeler, and familiarity with industry data standards such as ACORD. You’ll collaborate closely with data engineers, analysts, and business stakeholders to translate business requirements into logical and physical data models that enable analytics, data integration, and governance initiatives.
Skills, Knowledge And Abilities
- 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.
Qualifications
- Required Qualifications:
- 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 Qualifications:
- 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.
Pay Range
In New York City, NY the pay range for this role is $110,000-125,000. This role may also be eligible to participate in a discretionary annual incentive program. The specific offer will depend on an applicant’s skills and other factors.
Workplace Initiatives
We are committed to creating a diverse and inclusive workplace where everyone feels valued and respected. We strive to foster an environment where employees can thrive, grow, and achieve their full potential. Our workplace initiatives include:
- Flexible work arrangements to accommodate different lifestyles and needs.
- Continuous learning and development opportunities to enhance skills and knowledge.
- Employee resource groups to support underrepresented communities.
- Wellness programs to promote physical and mental health.
- Community engagement initiatives to give back to the local community.
Career Areas for Professionals
We offer a variety of career paths within Hudson Insurance Group, including:
- Data Management and Analytics
- Information Technology
- Claims and Underwriting
- Product Development
- Customer Service and Support
- Human Resources
- Finance and Accounting
- Legal and Compliance
A Rewarding Workplace
At Hudson Insurance Group, we believe that a positive work environment is essential for success. We strive to create a culture where employees feel supported, engaged, and motivated to contribute to our mission of providing exceptional insurance solutions to our clients. We offer competitive compensation and benefits packages, as well as opportunities for growth and development within the organization.