Data Modeler Job at Confidential, Hartford, CT

MXZacWc0dXlQdzBUNjJ1Q0luOThmWWZBREE9PQ==
  • 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

Leidos

Short Term or As Needed Coverage - MFLC Counselor - Whidbey Island, Washington Job at Leidos

 ...for our Service Members mental health, and we need flexible, ready-to-serve counselors willing to jump in at a moments notice. Leidos seeks passionate licensed mental healthcare providers ready to embrace a flexible PRN-type schedule, stepping in where needed... 

DSV - Global Transport and Logistics

Forklift Driver Job at DSV - Global Transport and Logistics

 ...to our customers. Read more at Location: USA - Los Indios, Joaquin Cavazos Rd Division:Solutions Job Posting Title: Forklift Driver - 112451 Time Type: Full Time POSITION SUMMARY The Forklift Operator is responsible for operating power industrial trucks... 

Cintas Corporation

Accounts Receivable Representative Job at Cintas Corporation

 ...Requisition Number: 220643 Job Description Cintas is seeking an Accounts Receivable Representative. Responsibilities include all accounts receivable related functions, including keeping track of assigned accounts to identify outstanding debts; planning course... 

@Ease Family Solutions

On-Call & Temporary Nannies - Full-Time and Part-Time Care in San Jose & Surrounding Areas Needed Job at @Ease Family Solutions

Are you a childcare provider, daycare professional, or educator looking to make a meaningful impact through one-on-one care? Were hiring passionate individuals to provide reliable, nurturing, and high-quality support to families in San Jose and the surrounding areas.... 

Turning Point Action

Graphic Designer Job at Turning Point Action

 ...dimensions, etc.)WOW! SKILLS: Past/present involvement in conservative youth organizations Familiarity with AirTable, Slack, and other communication platforms Exceptional photography skills with an understanding of DSLR camera functionality and lighting...