Data Modeler

All locations Amelia, United States; Hartford, United States; Princeton, United States; 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. Apply Now Save job