Data Warehouse Business Systems Analyst

Polar IT Services; Jersey City (NJ); Hybrid; USD 90,000 - 120,000; Full time

Job summary

Polarits in Jersey City is seeking an experienced Data Warehouse Business Systems Analyst to support end-to-end data warehouse development, ETL design, and data analysis.

The role bridges business stakeholders and data engineering teams to translate P&C insurance requirements into robust data integration and reporting solutions.

Qualifications

• 6+ years as a Business Systems Analyst/Data Analyst in Data Warehousing/ETL environments.

Responsibilities

• Bridge business stakeholders and data engineering teams to translate requirements into data integration and reporting solutions.

Skills

SQL skills

Data profiling

Stakeholder management

Tools

Oracle

SQL Server

Snowflake

PostgreSQL

Job description

(Open to US Citizens, Green Card Holders, and EADs eligible for direct W2 employment)

Job Title: Data Warehouse Business Systems Analyst

Location: Jersey City, NJ (Hybrid)

Job Type: Contract (6 Months)

Domain: Property & Casualty (P&C) Insurance

Must be on our W2

Position Overview

We are seeking an experienced Data Warehouse Business Systems Analyst to support end-to-end data warehouse development, ETL application design, and comprehensive data analysis. The ideal candidate will bridge the gap between business stakeholders and technical data engineering teams, translating complex P&C insurance requirements into robust data integration and reporting solutions.

Required Qualifications & Skills

Experience: 6+ years as a Business Systems Analyst / Data Analyst specializing in Data Warehousing and ETL environments.

Domain Knowledge: Proven hands-on experience in the Property & Casualty (P&C) Insurance domain (claims, policy, underwriting, billing, or reinsurance).

Technical Proficiency: Strong SQL skills for data profiling, testing, and debugging across relational databases (e.g., Oracle, SQL Server, Snowflake, or PostgreSQL).

ETL & Data Warehousing Concepts: Solid understanding of dimensional modeling, data lineage, master data management, and ETL tools/processes.

Communication: Excellent stakeholder management, analytical problem-solving, and requirement documentation skills.