Business Analyst – Property & Casualty Insurance (Advanced SQL)

Coforge; Hyderabad; Hybrid; INR 900,000 - 1,500,000; Full time

Job summary

Coforge is seeking a Business Analyst with strong Property & Casualty (P&C) Insurance domain expertise and advanced SQL skills. The role bridges business requirements and technology solutions, collaborating with stakeholders, product owners, underwriting, claims, policy administration, and technical teams to analyze needs and support strategic initiatives across the insurance value chain.

The ideal candidate will gather requirements, perform data analysis, prepare FRDs/BRDs, user stories, and

Qualifications

• P&C insurance domain knowledge is essential.
• Advanced SQL skills for complex data analysis and validation.
• Experience gathering and documenting requirements, FRDs/BRDs, and user stories.
• Familiar with BRD/FRD, use cases, and acceptance criteria.
• Proficient in Agile/Scrum and Waterfall methodologies, with stakeholder collaboration.
• Strong stakeholder management and requirement validation abilities.
• Ability to analyze data trends, perform reconciliation, and support decisions.

Responsibilities

• Gather, analyze, document, and validate business requirements from stakeholders.
• Translate requirements into FRDs/BRDs, user stories, and acceptance criteria.
• Analyze end-to-end P&C insurance processes: policy administration, claims, billing, renewals.
• Perform data analysis using advanced SQL to identify trends and verify rules.
• Create dashboards, reports, and KPI metrics to improve operations.
• Collaborate across SDLC with development, QA, data engineering, and business teams.

Skills

P&C domain expertise

Advanced SQL

Requirements gathering

FRD/BRD/User stories

Agile/Scrum & Waterfall

Stakeholder management

Data analysis

Job description

Business Analyst – Property & Casualty Insurance (Advanced SQL)

Job Title: Business Analyst – Property & Casualty (P&C) Insurance

Location: India (Hybrid/Remote)

Experience: 5-10 Years

Employment Type: Full-Time

Role Overview

Coforge is seeking for a Business Analyst with strong Property & Casualty (P&C) Insurance domain expertise and advanced SQL skills to bridge business requirements and technology solutions. The ideal candidate will work closely with business stakeholders, product owners, underwriting, claims, policy administration, and technical teams to analyze business needs, gather requirements, perform data analysis, and support strategic initiatives across the insurance value chain.

Key Responsibilities

• Gather, analyze, document, and validate business requirements from stakeholders.
• Conduct requirement workshops, stakeholder interviews, and process walkthroughs.
• Translate business requirements into Functional Requirement Documents (FRDs), Business Requirement Documents (BRDs), user stories, and acceptance criteria.
• Analyze end-to-end P&C insurance processes including:
• Policy Administration
• Claims Management
• Billing & Collections
• Renewals and Endorsements
• Perform data analysis using advanced SQL queries to identify trends, validate business rules, reconcile data, and support decision-making.
• Prepare process flows, use cases, workflow diagrams, and gap analysis documents.
• Collaborate with development, QA, data engineering, and business teams throughout the SDLC.
• Support UAT planning, test scenario creation, defect triage, and production validation.
• Create dashboards, reports, and KPI metrics to improve operational efficiency.
• Conduct impact analysis for system enhancements and regulatory changes.
• Ensure data accuracy, completeness, and compliance with business rules.

Required Skills

Property & Casualty Domain Expertise

• Strong understanding of P&C insurance operations.
• Experience working in one or more functional areas:
• Policy Administration
• Claims
• Knowledge of insurance lifecycle and policy transactions.
• Understanding of insurance regulatory and compliance requirements.

Business Analysis Skills

• Requirement gathering and analysis.
• BRD, FRD, User Stories, Use Cases.
• Process Mapping and Gap Analysis.
• Agile/Scrum and Waterfall methodologies.
• Stakeholder Management.

Advanced SQL Skills (Mandatory)

• Complex joins and subqueries.
• Window Functions.
• Stored Procedures.
• Query Optimization and Performance Tuning.
• Data Validation and Reconciliation.
• Data Profiling and Root Cause Analysis.
• Experience with Oracle, SQL Server, PostgreSQL, or MySQL.