Property Casualty Insurance Data Analyst

Arthur Grand Technologies Inc; Jersey City (NJ); Hybrid; USD 80,000 - 113,000; Full time

Job summary

Arthur Grand Technologies Inc is seeking a Business Data Analyst with a strong background in data analysis, mapping and transformation for P&C insurance in Jersey City. The role is long‑term, hybrid (3-4 days onsite) and focused on enterprise data initiatives.

The ideal candidate has 5+ years of experience, hands‑on SQL skills, and expertise in STTM documentation, data consolidation, and domain knowledge to ensure data aligns with business processes.

Qualifications

• 5+ years of hands-on experience in data analysis, data mapping, and data transformation in enterprise data environments.
• Strong proficiency in SQL, including analytic functions, optimization and tuning.
• Proven experience developing STTM documents and understanding ETL/data flows.
• Exposure to data consolidation, standardization and transformation across heterogeneous sources.
• In-depth knowledge of the Property & Casualty Insurance domain.
• Excellent communication and interpersonal skills.
• Strong documentation skills for technical and business needs.

Responsibilities

• Perform end‑to‑end data analysis including profiling, validation and transformation.
• Develop source‑to‑target data mappings and related documentation.
• Gather, analyze and translate functional requirements into specs.
• Collaborate with data engineers to implement and validate data consolidation and transformation.
• Optimize SQL queries for large datasets and performance.
• Contribute to data quality assessments and enrichment strategies.
• Apply P&C insurance domain knowledge to ensure data aligns with business processes.
• Foster effective communication among business SMEs, data modelers and technical teams.

Skills

Years of experience

SQL

STTM

Data mapping

Data transformation

P&C Insurance domain

Communication

Documentation

Job description

Job Description

Position: Business Data Analyst (Property & Casualty Insurance)

Jersey City, NJ – Hybrid (3-4 days onsite)

Long Term Contract

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, analyze, 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 art

Thanks

Richard Tucker

Arthur Grand Technologies Inc

8(A) Certified Business | CMMI (L3) | ISO 9001:2015 Certified | ISO/IEC 27001:2022 Certified

NMSDC Minority Business Enterprise (MBE)

Arthur Grand is an Equal Opportunity Employer (Including disability/Vets)

Qualifications:

Additional Information

All your information will be kept confidential according to EEO guidelines.

Compensation:

$70-$70