Data Modeler Job at Confidential, Hartford, CT

dXNEOXEyODN6ZFowNmxuUHNIK0F2NXJhTFE9PQ==
  • Confidential
  • Hartford, CT

Job Description

We are seeking an experienced Data Architect / Data Modeler with strong industry standards knowledge and a solid foundation in modern data modelling practices. The ideal candidate will have firsthand experience with modelling tools, data frameworks, and insurance industry data exchange standards. This role involves designing scalable, compliant, and high-quality data structures that support enterprise analytics, regulatory reporting, and operational data needs.

Responsibilities:

  • Design and maintain enterprise-wide data models (conceptual, logical, physical) to support analytics, operational reporting, regulatory compliance, and integration use cases
  • Own the design of canonical data models for delegated insurance covering Contract, Premium/Risk, and Claims, including full transaction and movement-based constructs (e.g., endorsements, cancellations, reinstatements, claim financial movements
  • Translate conceptual and logical models into implementation-ready artifacts including JSON/XML schemas and Excel bordereaux templates to support real-time API ingestion from MGA/TPA partner systems and monthly bordereaux submissions
  • Develop data models using Dimensional (Star/Snowflake), Data Vault, and 3NF methodologies.
  • Create and manage metadata and modelling artifacts using Erwin with traceability and governance
  • Support Medallion Architecture (Bronze, Silver, Gold) across ingestion and curation layers
  • Collaborate with engineering teams to implement models on Distributed big-data processing platforms and Unity Catalog
  • Participate in governance forums to drive standardization across data domains
  • Conduct model reviews and solution walkthroughs for architectural alignment
  • Define and govern integration patterns for third-party datasets including geocoding, hazard, valuation, and reference data
  • Ensure compliance with GDPR, Solvency II, and Lloyd’s reporting and oversight requirements, compliance with MAR/SOX controls through documentation and validation processes when applicable
  • Interpret and apply ACORD and CSIO data standards for global and Canadian insurance data exchange
  • Align modelling standards with the GSI Data Council and Partner Management & Data Intake workstreams acting as the architectural authority for delegated data standards. Supporting the creation of any required governance artifacts
  • Lead data modelling workshops and SME councils to drive stakeholder alignment
  • Provide architectural oversight during partner onboarding including mapping, validation, exception handling, and change control

Requirements:

  • Deep expertise in data architecture and enterprise data modelling across conceptual, logical, and physical layers
  • Experience designing insurance data models for delegated authority underwriting including policy, premium, exposure, claims, and financial transactions
  • Firsthand schema design experience (JSON Schema, XML/XSD) and API-based integrations with support for Excel/bordereaux submissions
  • Strong understanding of MAR/SOX, GDPR, Solvency II, and Lloyd’s regulatory, documentation and reporting requirements
  • Experience integrating and governing enrichment datasets with strong versioning and data quality controls
  • Excellent communication and stakeholder management skills with the ability to drive alignment and decision-making across senior stakeholders

The Company is open to considering candidates in Princeton, NJ. The salary range posted below applies to the Company’s Princeton location.

The base salary range anticipated for this position is $141,800 - $207,900  plus opportunity for company bonus based upon a percentage of eligible pay.  In addition, the company makes available a variety of benefits to employees, including health insurance coverage, an employee wellness program, life and disability insurance, 401k match, retirement savings plan, paid holidays and paid time off (PTO). 

The salary estimate displayed represents the typical salary range for candidates hired in this position in Princeton. Factors that may be used to determine your actual salary include your specific skills, how many years of experience you have and comparison to other employees already in this role. Most candidates will start in the bottom half of the range. 

At Munich Re, we see Diversity, Equity and Inclusion as a solution to the challenges and opportunities all around us. Our goal is to foster an inclusive culture and build a workforce that reflects the customers we serve and the communities in which we live and work. We strive to provide a workplace where all of our colleagues feel respected, valued and empowered to achieve their very best every day. We recruit and develop talent with a focus on providing our customers the most innovative products and services.  

We are an equal opportunity employer. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Job Tags

Contract work

Similar Jobs

Pain Consultants of East Tennessee

Billing and Charge Specialist Job at Pain Consultants of East Tennessee

 ...FULL TIME BILLING POSITION AVAILABLE Private multi-disciplinary pain management practice/ASC in Knoxville, TN currently hiring a...  ...oriented Competitive hourly wage depending on experience. Health/dental/vision/life/long term disability insurance paid for employee.... 

Biltmore Common Dental Care

Dental Assistant Job at Biltmore Common Dental Care

 ...A Private NON CORPORATE dental office is looking for a Full Time Dental Assistant. Our office is located in the beautiful Biltmore area which is accessible from...  ...averages between 20-28 per hour. Sick of being a Temp Worker? As one of our valued employees you receive... 

Integrated Real Estate Group

Shuttle Bus Driver - Watermere at Firewheel, Full Time Job at Integrated Real Estate Group

 ...committed to building thriving spaces and enhancing lives. Apply now to contribute to our legacy of success and innovation. Shuttle Bus Driver About the Role: The Shuttle Bus Driver provides safe and reliable transportation for residents to appointments and... 

24-MAG

Remote | Software Engineer (AI-Native Platform) — Open Application Job at 24-MAG

 ...sharing a specialised full-time W-2 opportunity for experienced software engineers with strong backgrounds in SaaS product development,...  ...launch execution, and next-generation operational tooling Contract Details Full-time W-2 role through Cincinnatus LLC Contingent... 

Everglades Equipment Group

Road Service Technician Job at Everglades Equipment Group

Job Title: Road Service Tech/Grade A- Mechanic Job Description: Technician is responsible for repair and maintenance of a variety of agricultural, lawn maintenance and construction equipment. This technician may be required to go out into the field and service equipment...