Data Architect - Duck Creek/Guidewire

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.

•    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.

1. 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.

2. 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.

3. 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.

4. 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.

5. 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. 

Budgeted Salary Currency: INR