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

The Bsa
Warren County, NJ, United States
4 days ago
Apply on www.dice.com
Prepare application

Role details

Contract type
Contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Job source

Tech stack

Third Normal Form Data Analysis JIRA BigQuery Business Process Modeling Business Systems Profiling Data Architecture Extract Transform Load (ETL) Data Profiling Data Warehousing Database Design
+12 more
Database Queries Python (Programming Language) Microsoft Office Microsoft Visio Power BI Microsoft SharePoint SQL Databases Snowflake Data Lakes Star Schema Amazon Redshift Databricks

Requirements

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

  1. Strong in Data warehousing

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

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

Experience in Entity relationships, understanding of data architecture

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

  2. 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.

  3. 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.

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

  5. Perform discovery analysis and data profiling to understand data

  6. Source-to-target mapping transformations

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

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

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.dice.com
Prepare application

Good distractions

Loading talks and stories from around this role…