Back to job search
Datadot Software Solution logo

Senior Business Analyst (Insurance P&C/Reinsurance)

  • Canada
  • Remote
  • Posted Nov 18, 2026
  • 1 position

Opens LinkedIn

Employment type
Full-time
Experience level
Senior
Posting language
English
Location requirements
Country, Edmonton, Alberta, Canada
Application method
Apply on LinkedIn (LinkedIn sign-in required)

Job summary

Lead business and systems analysis for insurance portals and core platforms, translating insurance workflows and stakeholder needs into specifications, user stories, data mappings, and Figma designs. Validate and reconcile data with SQL, align requirements and designs with architecture, and support engineering, QA, testing, and UAT while managing delivery risks and milestones.

Job details

We're seeking a Senior/Lead Business Systems Analyst to support an Insurance Portal initiative. The ideal candidate will combine strong insurance domain knowledge with hands-on business analysis, systems analysis, data mapping, SQL, and Figma expertise. **Applicants must be authorized to work in Canada** Responsibilities Lead business and systems analysis across broker and client portals, core insurance systems, and data-intensive applications. Facilitate discovery workshops and drive decisions with senior executives, business stakeholders, architects, and engineering teams. Translate rating rules, underwriting workflows, and servicing needs into process flows, functional specifications, user stories, acceptance criteria, and data dictionaries. Own complex source-to-target mappings across relational databases and insurance platforms, often using Excel specifications with 500+ rows. Use advanced SQL to analyze schemas, relationships, and transformation rules and to profile, reconcile, and validate data across policy administration systems (PAS), rating engines, and other core platforms. Independently create detailed wireframes, interactive prototypes, and development-ready designs in Figma for workflows such as quote-to-bind, renewals, and FNOL. Align functional requirements, data models, UI designs, and integration specifications with the solution architecture. Support engineering and QA through implementation, functional testing, defect triage, and UAT. Use AI assistants and agentic workflows to accelerate requirements analysis, documentation, prototyping, data mapping, and validation. Own analysis deliverables and milestones. Resolve risks, gaps, and dependencies early, and communicate clearly with executives and technical teams under delivery pressure. Requirements 7+ years as a Senior or Lead Business Systems Analyst, Business Analyst, or Business Systems Architect on complex enterprise software, digital portals, or core insurance platforms. Strong experience in commercial P&C insurance, reinsurance, or core insurance platforms is mandatory. Deep understanding of rating, underwriting, PAS, broker portals, and facultative and treaty placement data structures. Experience with Guidewire, Duck Creek, or Majesco is highly valued. Advanced Excel is mandatory, with hands-on experience building and maintaining source-to-target mappings across hundreds of fields, multiple relational data sources, and complex transformation rules. Hands-on Figma expertise is mandatory, with the ability to independently produce detailed UI designs, interactive user journeys, and development-ready specifications. Figma Design experience is required. Figma Make is preferred. Strong understanding of relational data modeling, integration patterns, API data flows, and enterprise data architecture. Ability to turn ambiguous requirements into clear, structured, testable specifications. Technical depth to challenge assumptions and contribute to solution design with architects and senior engineers. Strong communication and facilitation skills with executives and technical teams. Hands-on familiarity with AI assistants and agentic workflows for business analysis, requirements engineering, documentation, and prototyping.

What you’ll do

Lead business and systems analysis for insurance portals and core platforms, translating insurance workflows and stakeholder needs into specifications, user stories, data mappings, and Figma designs. Validate and reconcile data with SQL, align requirements and designs with architecture, and support engineering, QA, testing, and UAT while managing delivery risks and milestones.

Requirements

Requires 7+ years of senior or lead business systems analysis experience and mandatory expertise in commercial P&C insurance, reinsurance, or core insurance platforms. Candidates must have advanced Excel and hands-on Figma Design skills, along with strong SQL, data mapping, relational data, integration, communication, and AI-assisted workflow experience.

Listed skills

  • Business analysis · Preferred
  • SQL · Preferred
  • Facilitation · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

  • Business Analysis
  • Systems Analysis
  • Commercial P&C Insurance
  • Reinsurance
  • SQL
  • Advanced Excel
  • Figma Design
  • Data Mapping
  • Relational Data Modeling
  • Requirements Engineering
  • Insurance Rating
  • Underwriting
  • Policy Administration Systems
  • API Integration
  • Facilitation
  • AI-Assisted Workflows

Job areas

  • Technology
  • Data & Analytics
  • Finance & Accounting
  • Management & Leadership
  • Consulting