Technical Business Systems Analyst – P&C Insurance, Data Warehouse & SQL | Contract | Warren, NJ (Hybrid)
Technical Business Systems Analyst – P&C Insurance, Data Warehouse & SQL
Location: Warren, NJ (Hybrid – 3 days onsite per week preferred; remote consideration may be available)
Job Type: Contract (W2/1099)
Job Summary
We are seeking an experienced Technical Business Systems Analyst with a strong background in Property & Casualty (P&C) insurance, data warehousing, complex SQL, and ETL requirements analysis.
The ideal candidate will bridge business stakeholders and technical data teams, translating business requirements into detailed functional specifications and source-to-target mapping documents to support data warehouse and ETL development initiatives.
Key Responsibilities
Gather, analyze, and document business and functional requirements for data warehouse and ETL applications.
Develop Business Requirements Documents (BRDs), Functional Requirements Documents (FRDs), and detailed source-to-target mapping specifications.
Write and execute complex SQL queries across multiple tables to analyze, profile, reconcile, and validate data.
Define source-to-target mappings, transformation rules, data definitions, and business logic.
Collaborate with data architects, data modelers, developers, QA teams, and business stakeholders to finalize data requirements and table designs.
Perform data analysis to identify inconsistencies, gaps, data quality issues, and mapping discrepancies.
Translate business processes into functional specifications, process flows, and data models.
Support test planning, User Acceptance Testing (UAT), defect resolution, and data validation.
Coordinate with technical teams during ETL development, deployment, and production releases.
Track requirements, issues, and deliverables using Jira and maintain project documentation.
Required Qualifications
Proven experience as a Business Systems Analyst, Technical Business Analyst, or Data Business Analyst.
Mandatory experience in the Property & Casualty (P&C) insurance domain; reinsurance experience is highly desirable.
Strong hands-on SQL skills, including complex queries involving multiple tables, joins, subqueries, and data analysis.
Solid understanding of data warehousing concepts, data integration, and ETL processes.
Experience developing source-to-target mapping documents and transformation specifications.
Strong requirements gathering, business analysis, and technical documentation skills.
Experience preparing BRDs, FRDs, functional specifications, and business rules.
Experience supporting data testing, UAT, data reconciliation, and production releases.
Proficiency with Jira and Microsoft Office tools.
Preferred Qualifications
Experience with Visio, Power BI, SharePoint, and Python.
Familiarity with database design, data modeling, and data profiling.
Experience working with cross-functional business and technology teams.
Strong communication, analytical, problem-solving, and stakeholder management skills.
Ideal Candidate
The ideal candidate combines P&C insurance domain knowledge with hands-on SQL, data warehouse analysis, ETL mapping, and traditional business analysis skills. Candidates with strong documentation skills but limited SQL or data warehousing experience may not be suitable.
