Senior Systems Analyst - Onshore BA

Senior Systems Analyst - Onshore BA
Location - Chicago, IL (Fulltime)

Work Mode - Hybrid – 4 days a week

Role Summary 
We are seeking a Senior Insurance Business Analyst (10-12 Years Experience) with deep expertise in the Property & Casualty (P&C) Insurance domain and a proven track record of supporting enterprise data modernization and cloud migration initiatives. 
The ideal candidate should have strong knowledge of Insurance business processes, Guidewire ecosystem, data analysis, source-to-target mapping, data warehousing, and legacy-to-cloud migration programs. The role requires close collaboration with business stakeholders, architects, and data engineering teams to translate business needs into data solutions and drive successful transformation initiatives. 
Experience with Guidewire PolicyCenter, ClaimCenter, BillingCenter, enterprise data platforms, and modern cloud technologies such as Databricks will be highly valued. 

Required Skills & Experience 
1. Insurance Domain Expertise  
• 10-12 years of experience as a Business Analyst within the Insurance industry. 
• Strong understanding of Property & Casualty (P&C) Insurance business processes. 
• Deep knowledge of:  
o Policy Administration 
o Underwriting 
o Claims Management 
o Billing & Payments 
o Reinsurance 
o Regulatory & Compliance Reporting 
• Good understanding of Guidewire Policy, Billing and Claims processes.  
• Experience supporting Guidewire modernization, migration, integration, or data warehouse 
projects. 
• Experience working with business stakeholders across insurance operations and technology 
teams. 
• Ability to translate insurance business processes into scalable data and analytics solutions.

2. Business Analysis & Requirement Management 
• Expertise in requirement gathering, stakeholder management, workshop facilitation, and 
business process analysis. 
• Experience creating:  
o BRD 
o FRD 
o User Stories 
o Acceptance Criteria 
o Process Flows 
o Requirement Traceability Matrix 
• Ability to translate business requirements into functional, technical, and data requirements. 

3. Data Analysis & Data Mapping 
• Strong understanding of enterprise data structures and business data flows. 
• Hands-on experience performing:  
o Data Analysis 
o Data Profiling 
o Data Discovery 
o Data Reconciliation 
o Data Validation 
• Extensive experience creating and maintaining Source-to-Target Mapping (STTM) 
documents. 
• Ability to define transformation rules, business logic, derivations, and validation rules.

4. Data Engineering & Data Warehouse Knowledge 
• Working Knowledge of:  
o Data Warehousing Concepts 
o Data Modeling 
o ETL / ELT Frameworks 
o Metadata and Data Lineage 
• Experience working closely with Data Architects and Data Engineering teams. 

5. SQL & Technical Skills 
• Strong hands-on SQL skills for (Data Analysis, Data Validation, Data Profiling, Reconciliation, 
Root Cause Analysis) 
• Ability to understand complex databases, schemas, and relationships.

6. Legacy to Cloud Migration Experience (Highly Preferred) 
• Experience supporting large-scale legacy application, database, data warehouse, or ETL 
modernization programs. 
• Understanding of migration planning, data conversion, reconciliation, cutover, and post
migration validation. 
• Experience defining migration requirements and supporting cloud transformation initiatives.

7. Data Ingestion & Integration Experience (Highly Preferred) 
• Strong understanding of enterprise data ingestion patterns from legacy platforms. 
• Experience working with:  
o Batch Loads 
o Incremental Loads 
o CDC (Change Data Capture) 
o Replication Technologies 
o Near Real-Time Integration Patterns 
• Ability to identify source systems, table inventories, data ownership, and refresh strategies.

8. Modern Data Platform Experience 
Preferred 
• Azure Data Factory (ADF) 
• Azure Synapse Analytics 
Strong Plus 
• Databricks 
• Delta Lake 
• Modern Data Engineering Platforms