Senior P&C Data Analyst | Data Warehousing & Cloud

Capgemini America, Inc.; United States; Hybrid; USD 83,000 - 95,000; Full time

Benefits offered by this job

Paid time off

Medical, dental, vision

Retirement savings plans

Life and disability insurance

Employee assistance programs

Other local benefits

Job summary

Capgemini America, Inc. is seeking an experienced Business Analyst with a strong focus on Data Engineering and Data Warehousing in the P&C Insurance domain.

The role bridges business stakeholders, data engineers, architects, and IT teams to deliver data-driven solutions and measurable value. The candidate will perform hands-on data profiling, data analysis, and transformation logic design, while supporting end-to-end data initiatives on modern cloud platforms like Snowflake, Redshift or

Qualifications

• / The candidate must have 8 years of experience as a Business Systems Analyst or Business Analyst with data engineering/warehousing background.
• / Mandatory experience in Property & Casualty Insurance industry.
• / Hands-on data profiling, data analysis, data mapping, data validation, reconciliation and pseudo code creation.

Responsibilities

• Collaborate with business stakeholders to gather, analyze, and document business and data requirements.

Skills

Data Warehousing

Data Profiling

Data Analysis

SQL

ETL/ELT

P&C Insurance

Data Mapping

Star Schema

Snowflake

Azure/AWS/GC

Power BI/Tableau

Education

Bachelor's degree

Tools

JIRA

Azure DevOps

Visio

Lucidchart

Power BI

Tableau

Excel

Job description

Capgemini America, Inc. is seeking an experienced Business Analyst with a strong focus on Data Engineering and Data Warehousing in the P&C Insurance domain.

The role bridges business stakeholders, data engineers, architects, and IT teams to deliver data-driven solutions and measurable value. The candidate will perform hands-on data profiling, data analysis, and transformation logic design, while supporting end-to-end data initiatives on modern cloud platforms like Snowflake, Redshift or