Business Data Analyst (P&C) Insurance Claims

Wise Skulls Corp.; Jersey City (NJ); Hybrid; USD 90,000 - 130,000; Full time

Job summary

Wise Skulls Corp. in Jersey City, NJ (Hybrid 3 a week) is seeking a Business Data Analyst with deep expertise in large-scale data applications, data analysis, and transformation to support enterprise initiatives in the Property & Casualty Insurance domain.

The role emphasizes SQL, data mapping, and business analysis, with close collaboration with stakeholders, SMEs, and technical teams. The ideal candidate will bring hands-on experience in policy and claims data, data accuracy, and data delivery

Qualifications

• 5+ years of hands-on data analysis, mapping, and transformation in enterprise environments.
• Strong SQL proficiency with analytics functions and performance tuning.
• Experience developing STTM documents and understanding ETL/data flows.

Responsibilities

• Perform end-to-end data analysis, including profiling, validation, and transformation for large-scale data projects.
• Develop source-to-target data mappings (STTM) and documentation from business requirements.
• Translate functional requirements into technical specifications with stakeholders.
• Collaborate with data engineers and developers to implement data consolidation and standardization.
• Optimize complex SQL queries for performance and accuracy on large databases.
• Participate in data quality assessments and propose cleansing or enrichment strategies.
• Apply P&C insurance domain knowledge to align data with business processes.

Skills

SQL

Data analysis

Data mapping

Data transformation

Business analysis

Job description

Title: Business Data Analyst (P&C) Insurance Claims

Location: Jersey City, NJ (Hybrid 3 a week)

Duration: 6 months

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

Total Experience: 8 Years

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