BSA (P& C experience is a must // Technical BA role driven by Data warehousing and SQL WITH BA skills)

BSA (P& C experience is a must // Technical BA role driven by Data warehousing and SQL WITH BA skills)

Location: Warren, NJ – 3 days in the office is a must – (Remote option)

Duration: 6 months

Rate: DOE

Primary Skill –

P&C Insurance experience is a must.

Strong in Data warehousing

Requirements gathering and analysis, Data analysis and interpretation. Business process modeling, data modeling and database design, Documentation and report writing

Microsoft Office Suite, SQL, Visio, Power BI, Python, JIRA, SharePoint

Experience in Entity relationships, understanding of data architecture

This is a Technical BA role driven by data warehousing and SQL WITH BA skills.

The Business Systems Analyst role on the BTS - Data Warehouse team requires experience in creating Business Requirement Documents, Functional Requirement Documents, and Mapping documents for the development of ETL applications.

This role requires extensive SQL experience in writing complex queries across multiple tables, data analysis and profiling skills for the creation of the mapping documents, and further discussion with data modelers for the necessary table designs.

The Business Systems Analyst role will also be required to support testing and production releases.

Perform discovery analysis and data profiling to understand data

Source-to-target mapping transformations

Understanding of data modeling concepts (3NF, Star Schema, Snowflake).

Experience with data lakes and data warehouses (e.g., Databricks, Snowflake, Redshift, Big Query