Role: Business Data Analyst (P&C)
Location: Jersy City, NJ (3-4 days reporting
in office)
Job Description
Job Summary:
We are seeking a Business Data Analyst with
a strong background in large-scale data applications, data analysis, and
transformation to support enterprise-level initiatives in the Property
& Casualty (P&C) Insurance domain. The ideal candidate will
bring hands-on expertise in SQL, data mapping, and business analysis, along
with deep domain knowledge of policy and claims data. This role requires close
collaboration with business stakeholders, SMEs, and technical teams to drive
data accuracy, consistency, and value.
Key Responsibilities:
- Perform end-to-end data analysis,
including data profiling, validation, and transformation for
large-scale data integration and reporting projects.
- Develop source-to-target data mappings
(STTM) and documentation based on business requirements.
- Collaborate with business users and stakeholders
to gather, analyse, and translate functional requirements into
technical specifications.
- Work with data engineers and developers to
implement and validate data consolidation, standardization, and transformation
logic.
- Optimize complex SQL queries for performance and
accuracy in handling large datasets.
- Participate in data quality assessments and
recommend data cleansing or enrichment strategies.
- Leverage domain knowledge of Property
& Casualty Insurance—including policy administration and claims
lifecycle—to ensure data alignment with business processes.
- Facilitate communication between business SMEs,
data modelers, and technical teams for successful data delivery and adoption.
Required Skills & Experience:
- 5+ years of hands-on experience in
data analysis, data mapping, and data transformation within enterprise data
environments.
- Strong proficiency in SQL, including
analytical functions, query optimization, and performance tuning.
- Proven experience developing source-to-target
mapping (STTM) documents and understanding ETL/data flow processes.
- Exposure to data consolidation,
standardization, and transformation across heterogeneous data sources.
- In-depth knowledge of the Property &
Casualty Insurance domain,
- Exceptional communication and
interpersonal skills—able to work effectively with technical teams,
business stakeholders, and subject matter experts.
- Strong documentation skills with the ability to
create clear and concise technical and business artifacts.