Business Data Analyst with P&C Insurance

Capgemini • New York, NY

13d • $82,786 - $95,383 • Hybrid

About The Position

We are seeking an experienced Business Analyst with a strong background in Data Engineering and Data Warehousing projects and proven experience within the Property & Casualty (P&C) Insurance domain. The ideal candidate will serve as a critical liaison between business stakeholders, data engineering teams, and IT organizations to ensure that data-driven solutions are aligned with business objectives and delivered effectively. This role requires a blend of business analysis expertise, data domain knowledge, stakeholder management, and technical understanding of modern data platforms, ETL/ELT processes, and reporting solutions. The candidate should possess strong analytical, communication, and problem-solving skills, with the ability to translate complex business requirements into scalable data solutions.

Requirements

• 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.
• 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 with data mapping, data lineage, metadata management, and transformation logic.
• 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.
• Strong stakeholder management skills with the ability to work across cross-functional teams.

Nice To Haves

• 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.

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, data use cases, KPIs, and success criteria.
• Work closely with Data Engineers, Architects, and Developers on data integration, ETL/ELT, data pipeline, and data warehousing initiatives.
• Analyze and document data flows, source-to-target mappings, transformation logic, and data lineage.
• Facilitate requirements workshops, stakeholder meetings, and solution review sessions.
• Act as the primary liaison between business users, data teams, and IT stakeholders.
• Create and maintain Business Requirement Documents (BRDs), Functional Specification Documents (FSDs), user stories, process flows, data dictionaries, and related documentation.
• Participate in User Acceptance Testing (UAT), data validation, and defect resolution activities.
• Collaborate with BI and Analytics teams to support dashboards, reporting, and data visualization requirements.
• Ensure data accuracy, consistency, and usability across reporting and analytical platforms.
• Work closely with P&C Insurance business teams to understand and document requirements related to underwriting, claims, policy administration, billing, and reporting processes.

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