Business Analyst (P&C Insurance)
About The Position
Capgemini is seeking an experienced Property & Casualty (P&C) Business Analyst with strong data analysis and business intelligence capabilities to bridge business stakeholders and technology teams. The role is based in Warren, New Jersey, with work onsite three days per week. The analyst will use knowledge of P&C insurance processes, requirements gathering, data-driven decision-making, and analytical reporting to turn business requirements into insights and technology solutions. The position works with stakeholders across underwriting, claims, actuarial, and operations, as well as data engineers, developers, product owners, and QA teams. It supports analysis of insurance datasets, reporting and dashboards, data quality activities, user acceptance testing, and process optimization. The role also requires attention to insurance regulations and organizational governance standards.
Requirements
- Strong understanding of P&C insurance concepts, including policy administration, underwriting, claims management, billing and payments, reinsurance, and regulatory compliance.
- Experience working with Guidewire, Duck Creek, Majesco, or similar insurance platforms.
- Skills in requirements gathering and documentation, including BRDs, FRDs, user stories, and use cases.
- Process mapping skills using BPMN and Visio.
- Knowledge of Agile/Scrum methodology, stakeholder management, and UAT coordination.
- Advanced SQL skills and experience with data analysis and data validation.
- Knowledge of data modeling concepts.
- Advanced Excel skills, including functions and pivot tables.
- Experience with Power BI or Tableau, reporting, dashboard development, and KPI and trend analysis.
- Experience with SQL Server, Oracle, Snowflake, or PostgreSQL.
- Familiarity with Jira, Confluence, data warehousing concepts, and ETL/data pipelines.
Nice To Haves
- Experience working with cloud platforms such as Azure, AWS, or GCP.
Responsibilities
- Collaborate with business stakeholders and underwriting, claims, actuarial, and operations teams to gather, analyze, and document business requirements.
- Analyze P&C insurance data, including policy, claims, billing, underwriting, and customer datasets.
- Translate business requirements into functional specifications, user stories, process flows, and acceptance criteria.
- Conduct gap analysis, impact assessments, and root cause analysis to identify process improvement opportunities.
- Develop and maintain dashboards, reports, and KPIs to support business decisions.
- Analyze large datasets to identify trends, patterns, risks, and business opportunities.
- Support data validation, reconciliation, and quality assurance activities.
- Work with data engineers, developers, product owners, and QA teams throughout the project lifecycle.
- Facilitate UAT planning, execution, and defect resolution.
- Ensure compliance with insurance regulations and organizational governance standards.
- Recommend process optimization and automation initiatives.
Benefits
- Paid time off based on employee grade, including 12–25 vacation days depending on grade, company-paid holidays, personal days, and sick leave.
- Medical, dental, and vision coverage.
- Retirement savings plans, such as a 401(k) in the U.S.
- Life and disability insurance.
- Employee assistance programs.
- The role may be eligible for variable incentives, bonuses, or commissions, depending on position and applicable laws.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
No Education Listed
