Business Data Analyst – P&C Insurance

Business Data Analyst – P&C Insurance

Location: Jersey City, NJ (Onsite)

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 processe