Senior Data Analyst, P&C Insurance & Data Transformation

Oncorreinc; Jersey City (NJ); On-site; USD 85,000 - 120,000; Full time

Job summary

Oncorreinc in New Jersey is seeking a Business Data Analyst to support enterprise data initiatives in the Property & Casualty Insurance domain. The role focuses on large-scale data applications, data analysis, mapping, and transformation to drive accuracy and business value.

The ideal candidate will partner with business stakeholders, SMEs, and technical teams to translate requirements into technical specs, optimize SQL queries, and help align policy and claims data with core processes.

Qualifications

• 5+ years of hands-on data analysis, mapping and transformation in enterprise environments.
• Strong SQL proficiency with analytics, optimization and performance tuning.
• Experience developing source-to-target mappings (STTM) and ETL/data flow docs.
• Experience with data consolidation, standardization across diverse sources.
• Deep knowledge of Property & Casualty Insurance domain and policy/claims data.
• Excellent communication and collaboration with business and technical teams.
• Strong documentation for technical and business artifacts.

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—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.]

Skills

SQL

Data analysis

Data mapping

Data transformation

Data profiling

Data quality

Job description

Oncorreinc in New Jersey is seeking a Business Data Analyst to support enterprise data initiatives in the Property & Casualty Insurance domain. The role focuses on large-scale data applications, data analysis, mapping, and transformation to drive accuracy and business value.

The ideal candidate will partner with business stakeholders, SMEs, and technical teams to translate requirements into technical specs, optimize SQL queries, and help align policy and claims data with core processes.