3-7 years in finance transformation or finance data within insurance or reinsurance.
Professional qualification (CA, CPA, ACCA, CFA, or MBA Finance).
Fluency in PC reinsurance finance concepts and terminology.
Knowledge of insurance reporting standards (US GAAP, IFRS 17, etc.).
Hands-on experience with data modeling and mapping concepts.
Proficient in SQL for data profiling and KPI validation.
Experience in running stakeholder workshops and producing BRDs.
Responsibilities
Lead discovery workshops with finance and IT stakeholders to document current data landscape.
Inventory and assess data availability from various source systems.
Build and define KPIs, report inventory, and business logic.
Map critical data elements across a medallion architecture.
Shape the future architecture with data architects and reporting layers.
Write functional specifications and maintain a phased roadmap.
Act as a functional product owner during the build phase, including UAT testing.
Benefits
Paid time off based on employee grade, including vacation, holidays, personal days, and sick leave.
Medical, dental, and vision coverage.
Retirement savings plans (e.g., 401(k) in the U.S.).
Life and disability insurance.
Employee assistance programs.
Full Job Description
Location: NYC, NY (3 days/week from office).
Description
We are starting discovery for a finance data modernization at a leading global PC reinsurer. The hub will consolidate finance actuarial claims policy and reinsurance data from multiple source systems into a governed financial data layer that feeds management and regulatory reporting FPA and in time conversational analytics. We are looking for a functional lead who speaks both finance and data.
Roles & Responsibilities
Lead discovery workshops with Finance Actuarial Reinsurance FPA and IT stakeholders to document the ASIS reporting and data landscape.
Inventory source systems GLERP EPM policy admin claims actuarial reserving ceded reinsurance investments and assess data availability, grain quality and ownership.
Build the KPI and report inventory business definitions calculation logic dimensions named business owners and signoff.
Define critical data elements and map KPIs to source and target fields across a medallion architecture of Bronze Silver Gold Semantic.
Shape the TOBE architecture with data architects financial data layer, semantic layer reporting and self-service layer.
Write the BRD functional specifications, assumptions and risks log and the phased roadmap.
Act as a functional product owner for the Gold and Semantic layers as the engagement moves into build, including UAT and self-service testing with business users.
Contribute to estimates of SOW inputs and follow-on proposals.
Required
3-7 years in finance transformation or finance data or FPA controllership within insurance or reinsurance in consulting or industry.
Professional qualification CA, CPA, ACCA, CFA or MBA Finance or equivalent depth
Working fluency in PC reinsurance finance GWPNWP earned premium UPR paid case IBNR and incurred losses ALAEULAE CAT vs non-CAT commissions and brokerage DAC loss expense combined ratios ceded reinsurance technical result
Knowledge of at least one insurance reporting basis US GAAP US STATNAIC IFRS 17 or Solvency II and the bridges between them
Handson experience with data modeling concepts star schemas conformed dimensions medallion Lakehouse layers semantic models source-to-target mapping
SQL proficiency sufficient to profile data and validate KPI logic independently
Proven ability to run stakeholder workshops and produce clientready BRDs KPI catalogs and architecture narratives
The base compensation range for this role in the posted location is: $105,000 - 115,000
Capgemini offers a comprehensive, non-negotiable benefits package to all regular, full-time employees. In the U.S. and Canada, available benefits are determined by local policy and eligibility and may include:
Paid time off based on employee grade (A-F), defined by policy: Vacation: 12-25 days, depending on grade, Company paid holidays, Personal Days, Sick Leave
Medical, dental, and vision coverage (or provincial healthcare coordination in Canada)
Retirement savings plans (e.g., 401(k) in the U.S., RRSP in Canada)
Life and disability insurance
Employee assistance programs
Other benefits as provided by local policy and eligibility
About Capgemini
Capgemini is a global leader in consulting, digital transformation, technology and engineering services. The company is headquartered in Paris, France and operates in over 50 countries. Capgemini provides a range of services including strategy and transformation, application services, technology services, and engineering services. The company serves clients in a variety of industries including automotive, consumer products, financial services, healthcare, and retail.
