P&C Data Analyst - SQL, STTM, Hybrid

iShare Inc.; Jersey City (NJ); Hybrid; USD 90,000 - 120,000; Full time

Job summary

We are seeking an experienced Business Data Analyst to support large-scale P&C Insurance data initiatives for iShare Inc. in Jersey City, NJ.

The role emphasizes SQL, data analysis, data mapping, transformation, and source-to-target mapping to ensure data accuracy and alignment with policy and claims processes. This position requires collaboration with business stakeholders, data engineers, developers, and data modelers to deliver high-quality data and documentation.

Qualifications

• 5+ years of experience in business data analysis, mapping, and transformation.
• Strong SQL skills with analytics functions, query optimization, and performance tuning.
• Hands-on experience creating STTM documents.
• Good understanding of ETL processes and enterprise data flows.
• Experience consolidating and standardizing data from multiple sources.
• Strong knowledge of the P&C Insurance domain, including policy and claims data.
• Excellent stakeholder-management, communication, analytical, and documentation skills.
• Ability to work onsite in Jersey City 3-4 days per week.

Responsibilities

• Perform data profiling, analysis, validation, and transformation for enterprise data integration and reporting projects.
• Create source-to-target mapping (STTM) documents based on business and technical requirements.
• Gather and translate business requirements into functional and technical specifications.
• Partner with data engineers to implement and validate data consolidation, standardization, and transformation rules.
• Develop and optimize complex SQL queries for large datasets.
• Conduct data-quality assessments and recommend cleansing and enrichment strategies.
• Apply P&C Insurance knowledge across policy administration and claims lifecycles.
• Coordinate with business SMEs, data modelers, and technical teams to support successful data delivery.
• Prepare clear business requirements, mapping documents, data dictionaries, and technical documentation.

Skills

SQL

Data analysis

STTM documents

ETL concepts

Data mapping

P&C domain knowledge

Education

Bachelor's degree in Computer Science / Information Systems / Engineering

Tools

STTM Documents

Job description

We are seeking an experienced Business Data Analyst to support large-scale P&C Insurance data initiatives for iShare Inc. in Jersey City, NJ.

The role emphasizes SQL, data analysis, data mapping, transformation, and source-to-target mapping to ensure data accuracy and alignment with policy and claims processes. This position requires collaboration with business stakeholders, data engineers, developers, and data modelers to deliver high-quality data and documentation.