Data BA P&C

Job Summary:
We are seeking a seasoned Technical Business/Data Analyst with deep domain knowledge in Property & Casualty (P&C) insurance to support the transformation of legacy reporting systems. This role involves working closely with business users to perform discovery, analyze Excel-based legacy reports, and help migrate and enhance reporting capabilities within a modern data framework.
Key Responsibilities:
Engage with business stakeholders to understand existing reporting needs, primarily driven by Excel-based legacy mechanisms.
Perform detailed discovery and gap analysis to identify reporting logic, data sources, and transformation rules.
Translate business requirements into functional and technical specifications for integration into the current reporting framework.
Collaborate with data engineers and developers to enhance and extend the reporting platform using tools like SSIS and MS SQL Server.
Support the design and validation of enriched data pipelines and reporting outputs aligned with business expectations.
Participate in Agile/Scrum ceremonies and contribute to sprint planning, backlog grooming, and user story creation.
Document data mappings, business rules, and reporting logic to ensure traceability and maintainability.
Required Skills & Qualifications:
8+ years of experience as a Business Analyst or Data Analyst in the P&C insurance domain.
Strong understanding of insurance data across lines of business such as General Liability, Property, Inland Marine, and Surety.
Experience working with Excel-based legacy reports and translating them into scalable, automated reporting solutions.
Proficiency in SSIS, MS SQL Server, and SQL for data analysis and ETL support.
Familiarity with Agile/Scrum methodologies and tools like Jira or Azure DevOps.
Excellent communication and stakeholder engagement skills, especially in ambiguous or evolving requirement scenarios.
Preferred Qualifications:
Experience with reporting modernization or data platform migration projects.
Exposure to data visualization tools (e.g., Power BI, Tableau) is desirable.
Understanding of data governance, quality, and lineage concepts.