P&C Data Warehouse BSA: SQL, ETL & BRD Expert

Intersoft Systems

New Jersey

Hybrid

USD 83,000 - 131,000

Full time

7 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Intersoft Systems, Inc. in Warren, NJ is seeking an experienced Business Systems Analyst (BSA) with a strong background in Property & Casualty insurance, data warehousing, and SQL.

You will gather business requirements, perform complex SQL queries, analyze data, and prepare source-to-target mapping documents for ETL initiatives. The role requires collaboration with data engineers, developers, and data modelers to translate business needs into technical specifications and support data warehouse

Qualifications

  • P&C Insurance experience is mandatory.
  • Strong requirements gathering and documentation.
  • Data warehousing concepts and ETL
  • Hands-on SQL across multiple tables.

Responsibilities

  • Gather, analyze, and document business and technical requirements for data warehouse initiatives.
  • Prepare BRDs, FRDs, and technical mapping specifications.
  • Write complex SQL queries for data validation and analysis.
  • Develop and maintain source-to-target mapping documents for ETL.
  • Perform data profiling and identify data quality gaps.
  • Collaborate with data architects on table structures and relationships.
  • Translate business requirements into technical data specifications.
  • Support ETL development and data integration activities.
  • Assist with testing, defect tracking, and release activities.
  • Maintain project documentation and requirement traceability.

Job description

Intersoft Systems, Inc. in Warren, NJ is seeking an experienced Business Systems Analyst (BSA) with a strong background in Property & Casualty insurance, data warehousing, and SQL.

You will gather business requirements, perform complex SQL queries, analyze data, and prepare source-to-target mapping documents for ETL initiatives. The role requires collaboration with data engineers, developers, and data modelers to translate business needs into technical specifications and support data warehouse

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Business Systems Analyst (BSA) – Data Warehouse / SQL
Business Systems Analyst (BSA) – Data Warehouse / SQL

Intersoft Systems • New Jersey

Hybrid
USD 83,000 - 131,000
Data Warehouse Business Systems Analyst
Data Warehouse Business Systems Analyst

Polarits • Jersey City (NJ)

Hybrid
USD 90,000 - 120,000
P&C Data Analyst - SQL, ETL & Data Mapping Expert
P&C Data Analyst - SQL, ETL & Data Mapping Expert

Compunnel Inc. • Jersey City (NJ)

On-site
USD 110,000 - 140,000
Business Data Analyst
Business Data Analyst

Compunnel Inc. • Jersey City (NJ)

On-site
USD 110,000 - 140,000
P&C Data Analyst — SQL, ETL & Data Mapping
P&C Data Analyst — SQL, ETL & Data Mapping

Arthur Grand Technologies Inc • Jersey City (NJ)

Hybrid
USD 80,000 - 113,000
Business Data Analyst PC Insurance
Business Data Analyst PC Insurance

iShare Inc • Jersey City (NJ)

Hybrid
USD 90,000 - 125,000
Business Data Analyst P&C Insurance
Business Data Analyst P&C Insurance

iShare Inc • Jersey City (NJ)

Hybrid
USD 90,000 - 120,000
Senior Data Analyst – P&C Enterprise Data & SQL
Senior Data Analyst – P&C Enterprise Data & SQL

EXL Talent Acquisition Team • Jersey City (NJ)

On-site
USD 100,000 - 140,000
P&C Insurance BI Analyst | Data-Driven & Impactful
P&C Insurance BI Analyst | Data-Driven & Impactful

Capgemini • New York (NY)

Hybrid
USD 105,000 - 115,000
Paid time off
Health insurance
401(k)
Data Analyst (Production Support)-P&C (Property and casualty insurance) - Hybrid
Data Analyst (Production Support)-P&C (Property and casualty insurance) - Hybrid

The Dignify Solutions, LLC • Houston (TX)

Hybrid
USD 80,000 - 100,000