Business Systems Analyst (BSA) – Data Warehouse / SQL

Job Categories: Technology
Job Types: Full Time
Job Locations: Warren NJ

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.

Apply for this position

Allowed Type(s): .pdf, .doc, .docx