> Markdown version of [/jobs/ext/4688789-bsa-p-c-experience-is-a-must-technical-ba-role-driven-by-data-warehousing-and-sql-with-ba-skills](https://www.wearedevelopers.com/jobs/ext/4688789-bsa-p-c-experience-is-a-must-technical-ba-role-driven-by-data-warehousing-and-sql-with-ba-skills). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # BSA (P& C experience is a must // Technical BA role driven by Data warehousing and SQL WITH BA skills) - **Company:** The Bsa - **Location:** Warren County, NJ, United States (Remote available) - **Contract:** Contract - **Skills:** 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, Database Queries, Python (Programming Language), Microsoft Office, Microsoft Visio, Power BI, Microsoft SharePoint, SQL Databases, Snowflake, Data Lakes, Star Schema, Amazon Redshift, Databricks - **Published:** November 12, 2026 - **Apply:** https://www.dice.com/job-detail/099d242b-4964-4544-bd72-8f105df81341 ## About the Role 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. 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