Data Analyst with P&C Insurance domain(Only w2)

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

Job Title: Data Analyst with P&C Insurance domain(Only w2)

Location: Jersey City, NJ(Onsite/Only Locals)

Experience required: 9+ years

Mode of Interview: Telephonic + Video Round Interview

Must-Have Skills:

• Snow Flake, AWS, Property & Casualty Insurance domain.
• 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.
• Strong documentation skills with the ability to create clear and concise technical and business artifacts.