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

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
• Data Mapping & Data Lineage
• Pseudo Code Creation
• ETL/ELT Processes
• Source-to-Target Mapping
• Business Requirements Gathering
• Data Validation & Reconciliation
• Snowflake / Redshift / BigQuery
• Azure / AWS / GCP
• 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.

The base compensation range for this role in the posted location is: 82786- 95383

Capgemini provides compensation range information in accordance with applicable national, state, provincial, and local pay transparency laws. The base compensation range listed for this position reflects the minimum and maximum target compensation Capgemini, in good faith, believes it may pay for the role at the time of this posting. This range may be subject to change as permitted by law.

The actual compensation offered to any candidate may fall outside of the posted range and will be determined based on multiple factors legally permitted in the applicable jurisdiction.

These may include, but are not limited to: Geographic location, Education and qualifications, Certifications and licenses, Relevant experience and skills, Seniority and performance, Market and business consideration, Internal pay equity.

It is not typical for candidates to be hired at or near the top of the posted compensation range.

In addition to base salary, this role may be eligible for additional compensation such as variable incentives, bonuses, or commissions, depending on the position and applicable laws.

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