Finance Data Transformation Lead

Capgemini • New York, NY

2d • $105,000 - $115,000 • Hybrid

About The Position

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.

Requirements

• 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

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.

Benefits

• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level