Job Description

Role: Business Data Analyst – P&C Insurance

Location: Jersey City

Domain: P&C Insurance domain

Mandatory Skill: SQL

NOTE:

· We require a Business Data Analyst (BDA) with strong technical expertise and hands-on experience in SQL. The candidate must have prior experience in the Insurance domain, specifically within Property & Casualty (P&C) Insurance.

· Please note that both technical SQL expertise and P&C Insurance domain experience are mandatory. Kindly do not submit any candidates who do not meet these requirements.

Role: Job Summary

We are seeking a senior Business Data Analyst with strong experience in enterprise data analysis, transformation, and large-scale data platforms within the Property & Casualty Insurance domain. This role operates as a lead-level liaison between Data Engineers, Actuaries, and Business Stakeholders, supporting data-driven initiatives with a focus on accuracy, consistency, and business alignment.

Key Responsibilities

· Perform end-to-end data analysis, including data profiling, validation, and transformation for enterprise data initiatives.

· Develop and maintain Source-to-Target Mapping (STTM), Business Requirements (BRD), and data analysis documentation.

· Act as a primary coordinator between data engineers and actuaries, supporting planning, prioritization, and delivery.

· Collaborate with data engineers to implement and validate data consolidation and transformation logic, primarily on Snowflake.

· Write and optimize complex SQL queries to support analytics and reporting on large datasets.

· Apply P&C insurance domain knowledge (policy and claims lifecycle) to ensure data aligns with business and actuarial needs.

· Participate in SDLC activities, including requirements gathering, design reviews, testing support, and production readiness.

Required Skills & Experience

· 5+ years of experience in business/data analysis within enterprise data environments.

· Strong proficiency in SQL and experience with Snowflake (required).

· Proven experience creating STTM, BRD, and data analysis documentation.

· Solid understanding of ETL/ELT processes and data transformation concepts.

· In-depth knowledge of Property & Casualty Insurance, including policy and claims data.

· Strong communication and coordination skills, with experience acting as a liaison between technical and business teams.

· Good understanding of SDLC and enterprise data delivery processes

Job Tags

Similar Jobs