Data Architect, Duck Creek/Guidewire

Job Description

This individual will collaborate closely with other Verisk teams, customers, and implementation partners to establish best-in-class data modeling standards, guide data persistence practices, define canonical structures, and ensure seamless integration with policy administration systems and related downstream applications. The ideal candidate combines deep P&C industry knowledge with hands-on technical expertise across data modeling, databases, React-based UI integration, REST API design, and cloud-native architecture.

Responsibilities

• Data Architecture & Strategy
• Design, evolve, and maintain a canonical insurance data model (CIDM) that supports ISO ERC and proprietary carrier products, and custom extensions.
• Define and enforce standards for data capture, persistence, normalization, and extensibility, ensuring alignment with the FAST P&C Platform’s architecture.
• Architect and govern effective dating, versioning, and historical tracking strategies across coverages, forms, schedules, exposures, and hierarchies.
• Model complex insurance relationships including 1-1, 1-many, many-many, cross-product linkages, and multi-level policy structures.
• Establish and communicate best practices for product-agnostic and highly extensible model design.
• Hands-on Architecture & Solution Design
• Define end-to-end technical architecture for integration with downstream systems (rating, analytics, reporting).
• Design and optimize relational schemas in SQL Server and PostgreSQL, including indexing strategies, partitioning approaches, stored procedures, and performance tuning.
• Partner with developers to build and refine .NET-based services that implement business logic, data access patterns, and platform APIs.
• Define and maintain REST API contracts for consistent, secure, and scalable data interchange.
• Work with UI teams to align React components and workflows with underlying data structures.
• Contribute to end-to-end solution architecture including AWS cloud deployments, microservices, and integrations.
• Governance, Metadata, and Standards
• Establish and maintain data governance frameworks including data contracts, naming standards, lineage tracking, and data quality controls.
• Implement standards for extensibility (typed extension tables, JSON attributes) and enforce data quality rules.
• Drive compliance with ISO updates and carrier-specific filings through version-controlled mapping rules.
• Oversee management of product registries, mapping rules, configuration metadata, and product lineage.
• Platform, Implementation Partnership, and Stakeholder Collaboration
• Partner with business analysts, product managers, and insurance SMEs to translate business requirements into robust data structures.
• Serve as the data architecture authority for the FAST P&C Platform team.
• Represent data architecture in customer implementations, conduct workshops, and validate technical assumptions.
• Troubleshoot and resolve complex data issues during onboarding, testing, and internal and external deployments.
• Collaborate with Verisk product teams, enterprise architects, and data engineers to ensure seamless integration and operationalization of the data model.
• Communicate technical risks, trade-offs, and opportunities to leadership in clear business terms.
• Leadership & Mentoring
• Provide technical leadership to developers, modelers, DBAs, and data engineers.
• Mentor teams on data design principles, insurance concepts, API patterns, and cloud architecture.
• Communicate technical concepts clearly to business stakeholders, client partners, and executives.
• Foster a culture of innovation, scalability, accountability, and performance.

Qualifications

• 8+ years of experience in data architecture, modeling, and solution design within the P&C insurance domain.
• Deep understanding of policy, product, coverage, rating, and forms data structures.
• Proven expertise in canonical data models, handling complex hierarchies, and implementing effective dating/versioning.
• Experience working with or integrating major policy administration platforms (FAST, Guidewire, Duck Creek, etc.).
• Strong knowledge of SQL Server and PostgreSQL (schema design, indexing, performance tuning).
• Hands-on experience with .NET (C#, ASP.NET) for enterprise-grade services.
• Experience with React for building dynamic UI components.
• Expertise in REST API design, including security, versioning, and scalability.
• Practical experience with AWS cloud services for deployment and integration.

About Us

Our People, Our Culture

For more than 50 years, Verisk has helped property and casualty insurers make smarter decisions about risk through AI-powered risk modeling, advanced analytics, and technology solutions spanning the entire policy lifecycle. We are a leading strategic data, analytics, and technology partner to the global insurance industry, guided by core values of learning, caring, and results while maintaining the highest ethical standards as stewards of the industry's most comprehensive datasets. Learn more about Verisk and what we are doing within the insurance industry.

For the eighth consecutive year, Verisk is proudly recognized as a Great Place to Work® for outstanding workplace culture in the US, the fourth consecutive year in the UK, Spain, and India, and the second consecutive year in Poland. In addition, we’ve been recognized by The Wall Street Journal as one of the Best-Managed Companies and by Forbes as a World’s Best Employer, testaments to the value we place on workplace culture.

Our Culture : Explore our inclusive, people-first culture that fosters innovation, collaboration, and belonging.

Awards & Recognition : See why Verisk is consistently recognized as a Great Place to Work™ around the world.

Our Businesses : Learn about the diverse industries we serve — from insurance and energy to financial services and beyond.

Life at Verisk : Discover what it’s like to work at Verisk through employee stories, team highlights, and culture moments.

Careers at Verisk : Join a global team of problem-solvers and innovators doing meaningful work that’s shaping the future of industries. Whether you're just starting out or looking to take your career to the next level, Verisk offers growth, purpose, and a people-first culture

Let’s build something meaningful together!

Verisk Analytics is an equal opportunity employer.

All members of the Verisk Analytics family of companies are equal opportunity employers. We consider all qualified applicants for employment without regard to race, religion, color, national origin, citizenship, sex, gender identity and/or expression, sexual orientation, veteran's status, age or disability. Verisk’s minimum hiring age is 18 except in countries with a higher age limit subject to applicable law.

https://www.verisk.com/company/careers/

Unsolicited resumes sent to Verisk, including unsolicited resumes sent to a Verisk business mailing address, fax machine, or email address, or directly to Verisk employees, will be considered Verisk property. Verisk will NOT pay a fee for any placement resulting from the receipt of an unsolicited resume.

Verisk Employee Privacy Notice