Job Overview
Client is seeking an experienced Lead/Senior Business Systems Analyst to support the development of its Fac Portal, a digital platform designed for brokers and primary insurance underwriters.
The platform will support facultative reinsurance, commercial P&C, and specialty insurance placements, covering the complete insurance lifecycle from quote and binding through certificate issuance, renewals, billing, payments, and claims servicing.
The initial MVP will focus on small, non-catastrophe (non-CAT) facultative property risks, supporting straight-through processing (STP), instant rating engine quotes, and underwriter referral workflows for submissions requiring manual review.
The ideal candidate will combine strong commercial P&C/reinsurance domain expertise with advanced business systems analysis, complex data mapping, SQL, and hands-on Figma design capabilities.
Key Responsibilities
Lead business and systems analysis across broker/client portals, core insurance systems, and data-intensive enterprise applications.
Facilitate discovery workshops and collaborate with senior executives, business stakeholders, architects, and engineering teams.
Translate insurance rating rules, underwriting workflows, and servicing requirements into detailed functional specifications, process flows, user stories, acceptance criteria, and data dictionaries.
Develop and maintain complex source-to-target data mapping documents across relational databases and insurance platforms, including Excel specifications containing 500+ fields.
Use advanced SQL/T-SQL to analyze database schemas, relationships, transformation rules, and validate data across policy administration systems (PAS), rating engines, and other core platforms.
Independently create detailed wireframes, interactive prototypes, user journeys, and development-ready UI designs using Figma.
Design workflows covering quote-to-bind, renewals, first notice of loss (FNOL), and other insurance servicing processes.
Align functional requirements, data models, UI designs, and integration specifications with enterprise solution architecture.
Support engineering and QA teams during implementation, functional testing, defect triage, and user acceptance testing (UAT).
Leverage AI assistants and agentic workflows to accelerate requirements analysis, documentation, prototyping, data mapping, and validation.
Own analysis deliverables, manage dependencies, identify risks, and communicate effectively with business and technical stakeholders.
Mandatory Qualifications & Technical Skills
7+ years of experience as a Senior/Lead Business Systems Analyst, Business Analyst, or Business Systems Architect on complex enterprise applications.
Strong hands-on experience in Commercial Property & Casualty (P&C) Insurance, Reinsurance, or core insurance platforms.
Deep understanding of insurance rating, underwriting, policy administration systems (PAS), broker portals, and facultative/treaty placement data structures.
Advanced Microsoft Excel skills, including complex source-to-target data mapping across hundreds of fields and multiple relational data sources.
Hands-on Figma Design expertise, including independent creation of detailed wireframes, interactive prototypes, and development-ready specifications.
Strong SQL/T-SQL skills and understanding of relational database structures, data profiling, reconciliation, and validation.
Knowledge of relational data modeling, integration patterns, API data flows, and enterprise data architecture.
Ability to translate ambiguous business requirements into structured, clear, and testable technical specifications.
Strong stakeholder management, communication, analytical, and workshop facilitation skills.
Hands-on familiarity with AI assistants and agentic workflows for business analysis, requirements engineering, documentation, and prototyping.
Preferred / Nice-to-Have Qualifications
Experience with Guidewire, Duck Creek, or Majesco insurance platforms.
Experience with Figma Make.
Experience working with insurance rating engines and automated underwriting workflows.
Exposure to digital insurance portals and straight-through processing (STP).
Experience supporting insurance integrations, functional testing, and UAT