Business Data Analyst with P&C Insurance

Capgemini; New Jersey; Hybrid; USD 90,000 - 130,000; Full time

Benefits offered by this job

Healthcare benefits

Paid time off

Parental leave

Learning & mentoring programs

Job summary

Capgemini is seeking an experienced Business Data Analyst with a strong background in data engineering and data warehousing within the Property & Casualty Insurance domain. You will bridge business stakeholders, data teams, and IT to deliver data-driven solutions that meet strategic goals.

The role requires hands-on data profiling, data mapping, and transformation logic development, with experience across Snowflake, Redshift, and BigQuery in cloud environments.

Qualifications

• 8+ years of experience as a Business Systems Analyst or Business Analyst with data warehousing experience.
• Mandatory experience in the Property & Casualty Insurance industry.
• Hands-on data profiling, data analysis, data mapping, validation, and reconciliation.
• Strong knowledge of P&C processes: policy administration, underwriting, claims, billing.
• Familiarity with Star/Snowflake data modelling concepts.

Responsibilities

• Gather, analyze, and document business and data requirements with stakeholders.
• Translate requirements into functional and technical specs for data teams.
• Define business rules, KPIs, data use cases, and acceptance criteria.
• Perform data profiling, analysis, and discovery to identify quality issues.
• Document pseudo code, transformation logic, and source-to-target mappings.
• Collaborate with Data Engineers on ETL/ELT and data warehousing initiatives.
• Lead requirements workshops and solution reviews.
• Act as liaison between business users, data teams, and IT stakeholders.
• Support data governance, quality, security, and regulatory initiatives.

Skills

P&C Insurance

Data Engineering

Data Warehousing

Advanced SQL

Data Profiling

Data Analysis

ETL/ELT

Source-to-Target Mapping

Requirements Gathering

Snowflake

Redshift

BigQuery

Agile Methodologies

Policy Administration

Education

Bachelor's degree in Computer Science / Information Systems / Business Analytics

Certifications in BA / Agile / Cloud / Data Management / Insurance (plus)

Tools

JIRA

Azure DevOps

Visio

Lucidchart

Power BI

Tableau

Excel

Snowflake

Redshift

BigQuery

Azure

AWS

GCP

Job description

Position Title : Business Data Analyst with P&C Insurance

Location : Jersey City, NJ (Onsite/Hybrid from Day 1)

Experience : 8+ Years

Employee Type : Full Time with Benefits

Job Description

We are seeking an experienced Business Analyst with a strong background in Data Engineering and Data Warehousing projects and proven expertise within the Property & Casualty (P&C) Insurance domain. The ideal candidate will act as a bridge between business stakeholders, data engineering teams, architects, and IT organizations to ensure data-driven solutions align with business objectives and deliver measurable value.

This role requires a highly hands-on Data Business Analyst who is comfortable working with complex datasets, performing data profiling, analyzing source systems, creating pseudo code, defining transformation logic, and supporting end-to-end data initiatives. The candidate must possess a strong understanding of insurance data, data warehousing concepts, ETL/ELT processes, and modern cloud-based data platforms.

Key Responsibilities:

• Collaborate with business stakeholders to gather, analyze, and document business and data requirements.
• Translate business requirements into functional and technical specifications for data engineering teams.
• Define business rules, KPIs, success criteria, and data use cases.
• Perform hands-on data profiling, data analysis, and data discovery to identify data quality issues, patterns, relationships, and business rules.
• Create and document pseudo code, transformation logic, source-to-target mappings, and data processing rules.
• Analyze and document data flows, data lineage, transformation logic, and integration requirements.
• Work closely with Data Engineers, Architects, and Developers on data integration, ETL/ELT, data pipeline, and data warehousing initiatives.
• Facilitate requirements workshops, stakeholder meetings, and solution review sessions.
• Act as the primary liaison between business users, data teams, and IT stakeholders.
• Define and validate test scenarios, test cases, acceptance criteria, and reconciliation requirements.
• Participate in UAT, data validation, defect triage, and issue resolution activities.
• Support data governance, data quality, security, compliance, and regulatory initiatives.
• Work closely with P&C Insurance business teams to support initiatives related to underwriting, claims, policy administration, billing, analytics, and reporting.

Required Skills & Experience:

• 8+ years of experience as a Business Systems Analyst or Business Analyst, with significant experience supporting Data Engineering or Data Warehousing projects.
• Mandatory experience in the Property & Casualty (P&C) Insurance industry.
• Proven hands-on experience performing Data profiling, Data Analysis, Data mapping, Data Validation, Data Reconciliation, creation of pseudo code & Transformation Logic.
• Strong understanding of P&C Insurance business processes, including Policy Administration, Underwriting, Claims, Billing, and Insurance Data Management.
• Strong understanding of Business Analysis methodologies, requirements management, and stakeholder engagement.
• Solid understanding of data modeling concepts, including Star Schema and Snowflake Schema.
• Experience working with data warehouses and data lake technologies such as Snowflake, Amazon Redshift, BigQuery, or similar platforms.
• Exposure to cloud platforms including Azure, AWS, or GCP.
• Experience with ETL/ELT tools such as Informatica, Talend, Azure Data Factory, AWS Glue, or similar technologies.
• Familiarity with reporting and visualization tools such as Power BI, Tableau, and Excel.
• Experience using JIRA, Azure DevOps, Visio, Lucidchart, or similar tools.

Must have Skills

• P&C Insurance Domain Expertise
• Data Engineering / Data Warehousing Projects
• Advanced SQL
• Data Profiling & Data Analysis
• ETL/ELT Processes
• Source-to-Target Mapping
• Business Requirements Gathering
• Snowflake / Redshift / BigQuery
• Agile Methodologies

Preferred Qualifications:

• Experience working in Agile/Scrum environments.
• Understanding of API integrations, web services, and data exchange mechanisms.
• Exposure to Big Data technologies such as Spark and Hadoop.
• Knowledge of data governance, data privacy, and regulatory compliance frameworks.
• Experience supporting P&C Insurance Data Modernization, Data Governance, Data Warehousing, or Analytics initiatives.
• Knowledge of insurance data models and regulatory reporting requirements.
• Bachelor's degree in Computer Science, Information Systems, Business Analytics, or a related field.
• Relevant certifications in Business Analysis, Agile, Cloud, Data Management, or Insurance are a plus.

Life At Capgemini

Capgemini supports all aspects of your well-being throughout the changing stages of your life and career. For eligible employees, we offer:

• Healthcare including dental, vision, mental health, and well-being programs
• Financial well-being programs such as 401(k) and Employee Share Ownership Plan
• Paid time off and paid holidays
• Paid parental leave
• Family building benefits like adoption assistance, surrogacy, and cryopreservation
• Social well-being benefits like subsidized back-up child/elder care and tutoring
• Mentoring, coaching and learning programs
• Employee Resource Groups
• Disaster Relief

Disclaimer

Capgemini is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity/expression, age, religion, disability, sexual orientation, genetics, veteran status, marital status or any other characteristic protected by law.

This is a general description of the Duties, Responsibilities and Qualifications required for this position. Physical, mental, sensory or environmental demands may be referenced in an attempt to communicate the manner in which this position traditionally is performed. Whenever necessary to provide individuals with disabilities an equal employment opportunity, Capgemini will consider reasonable accommodations that might involve varying job requirements and/or changing the way this job is performed, provided that such accommodations do not pose an undue hardship.

Capgemini is committed to providing reasonable accommodations during our recruitment process. If you need assistance or accommodation, please reach out to your recruiting contact.

Click the following link for more information on your rights as an Applicant http://www.capgemini.com/resources/equal-employment-opportunity-is-the-law