Business Systems Analyst (BSA) – Data Warehouse / SQL

Intersoft Systems

New Jersey

Hybrid

USD 83,000 - 131,000

Full time

7 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

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

Job Title: Business Systems Analyst (BSA) – Data Warehouse / SQL

Location: Warren, NJ (Hybrid – 3 Days Onsite per Week)
Remote: Remote candidates may be considered; local candidates are preferred.
Duration: 6 Months
Visa: USC || GC || H4 EAD

Work Type: 1099 || W2 || Fulltime
Experience: Relevant experience in P&C Insurance and Technical Business Analysis.

Job Overview

We are looking for an experienced Business Systems Analyst (BSA) with a strong background in Property & Casualty (P&C) insurance, Data Warehousing, and SQL.

This is a highly technical Business Analyst position requiring a combination of business analysis capabilities and hands-on technical expertise. The ideal candidate should be proficient in gathering business requirements, performing complex SQL queries, analyzing data, and preparing source-to-target mapping documents for ETL development initiatives.

The candidate will work closely with business stakeholders, data engineers, developers, and data modelers to translate business requirements into technical specifications and support data warehouse implementations.

Key Responsibilities
  • Gather, analyze, and document business and technical requirements for data warehouse initiatives.
  • Prepare detailed Business Requirement Documents (BRDs), Functional Requirement Documents (FRDs), and technical mapping specifications.
  • Perform complex SQL queries involving multiple tables, joins, data validation, and data analysis.
  • Develop and maintain source-to-target mapping documents to support ETL development and data integration processes.
  • Conduct data profiling, data analysis, and interpretation to identify data gaps, inconsistencies, and transformation requirements.
  • Collaborate with data architects and data modelers to define appropriate table structures, data relationships, and database designs.
  • Analyze business processes and translate functional requirements into technical data specifications.
  • Support ETL application development by providing mapping documentation and clarifying business and technical requirements.
  • Participate in testing activities, including test case preparation, data validation, defect tracking, and issue resolution.
  • Provide support during production releases and post-deployment activities.
  • Maintain project documentation, reports, and requirement traceability throughout the development lifecycle.
Required Technical Skills
  • P&C Insurance: Strong and mandatory experience in Property & Casualty (P&C) insurance. Reinsurance domain experience is highly relevant.
  • Business Analysis: Strong experience in requirements gathering, business requirement analysis, functional documentation, and stakeholder communication.
  • Data Warehousing: Extensive understanding of data warehouse concepts, data integration, ETL processes, and data structures.
  • SQL: Hands-on expertise in writing complex SQL queries across multiple tables, including joins, data validation, and data analysis.
  • Source-to-Target Mapping: Experience preparing and maintaining source-to-target mapping documents for ETL applications.
  • Data Analysis: Strong data profiling, interpretation, reconciliation, and validation skills.
  • Data Modeling: Knowledge of data modeling, database design, table structures, and relationships.
  • JIRA: Experience using JIRA for requirements tracking, task management, and defect management.
Primary Skills & Tools
  • Requirements Gathering and Analysis
  • Data Analysis and Interpretation
  • Business Process Modeling
  • Data Modeling and Database Design
  • Business Requirement Documents (BRD)
  • Functional Requirement Documents (FRD)
  • Source-to-Target Mapping
  • Complex SQL Queries
  • Data Warehousing and ETL
  • Documentation and Report Writing
  • Microsoft Office Suite
  • SQL
  • Microsoft Visio
  • Power BI
  • Python
  • JIRA
  • SharePoint
Additional Responsibilities
  • Work with cross-functional teams to ensure business requirements are accurately translated into technical deliverables.
  • Support data warehouse development, testing, and implementation activities.
  • Assist with production deployment and release management.
  • Ensure data accuracy, consistency, and alignment with business requirements.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Warehouse Business Systems Analyst
Data Warehouse Business Systems Analyst

Polarits • Jersey City (NJ)

Hybrid
USD 90,000 - 120,000
Business Data Analyst
Business Data Analyst

Compunnel Inc. • Jersey City (NJ)

On-site
USD 110,000 - 140,000
Business Data Analyst P&C Insurance
Business Data Analyst P&C Insurance

iShare Inc • 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 PC Insurance
Business Data Analyst PC Insurance

iShare Inc • Jersey City (NJ)

Hybrid
USD 90,000 - 125,000
P&C Data Warehouse BSA: SQL, ETL & BRD Expert
P&C Data Warehouse BSA: SQL, ETL & BRD Expert

Intersoft Systems • New Jersey

Hybrid
USD 83,000 - 131,000
Business Analyst
Business Analyst

ExlService Holdings, Inc. • United States

Remote
USD 100,000 - 110,000
Sr. Data Analyst
Sr. Data Analyst

Accord Technologies Inc • Piscataway Township (NJ)

Hybrid
USD 110,000 - 160,000
Business Analyst with P&C Insurance domain
Business Analyst with P&C Insurance domain

ZENITH INFOTEK LLC • Warren Township (NJ)

Hybrid
USD 103,000 - 172,000
Free food & snacks
Health insurance
Competitive salary
Senior Insurance Data Business Analyst (Remote)
Senior Insurance Data Business Analyst (Remote)

ExlService Holdings, Inc. • United States

Remote
USD 100,000 - 110,000