Senior Data Analyst: P&C Insurance, ETL & Snowflake

Astir IT Solutions, Inc.; Jersey City (NJ); On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

Onsite work in Jersey City

Job summary

Astir IT Solutions, Inc. is seeking a Data Analyst with 9+ years of experience in the Jersey City, NJ area.

This onsite role requires deep expertise in property and casualty insurance data, strong SQL skills, and hands-on experience with Snow Flake and AWS data platforms. The candidate will perform data analysis, data mapping, and data transformation across enterprise environments, develop STTM documents, and contribute to data consolidation and standardization efforts.

Qualifications

• Must have deep experience with Snow Flake data environments and AWS cloud data platforms.
• Strong SQL skills including analytical functions, query optimization, and performance tuning.
• Proven experience developing source-to-target mapping (STTM) documents and understanding ETL/data flow processes.
• Experience in data analysis, data mapping, and data transformation within enterprise data environments.
• Exposure to data consolidation, standardization, and transformation across heterogeneous data sources.
• Excellent documentation skills for clear technical and business artifacts.

Skills

Snow Flake

AWS

Property & Casualty Insurance domain

Data analysis

Data mapping

Data transformation

SQL

Analytical SQL

ETL

STTM documents

Data flow processes

Data consolidation

Data standardization

Documentation skills

Job description

Astir IT Solutions, Inc. is seeking a Data Analyst with 9+ years of experience in the Jersey City, NJ area.

This onsite role requires deep expertise in property and casualty insurance data, strong SQL skills, and hands-on experience with Snow Flake and AWS data platforms. The candidate will perform data analysis, data mapping, and data transformation across enterprise environments, develop STTM documents, and contribute to data consolidation and standardization efforts.