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 –
1.P&C Insurance experience is a must.
2. Strong in Data warehousing
1. Requirements gathering and analysis, Data analysis and interpretation. Business process modeling, data modeling and database design, Documentation and report writing
2. Microsoft Office Suite, SQL, Visio, Power BI, Python, JIRA, SharePoint
Experience in Entity relationships, understanding of data architecture
4. This is a Technical BA role driven by data warehousing and SQL WITH BA skills.
5. 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.
6. 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.
8. The Business Systems Analyst role will also be required to support testing and production releases.
9. Perform discovery analysis and data profiling to understand data
10. Source-to-target mapping transformations
11. Understanding of data modeling concepts (3NF, Star Schema, Snowflake).
12. Experience with data lakes and data warehouses (e.g., Databricks, Snowflake, Redshift, Big Query
