Reporting Data Analyst – Property & Casualty insurance industry – data lineage, transformations

Position: Reporting Data Analyst – Property & Casualty insurance industry – data lineage, transformations, and
Location: New York

ROLE SUMMARY The Senior Reporting Data Analyst brings 13+ years of experience in enterprise data warehousing and reporting, with deep expertise in the Property & Casualty (P&C) insurance domain, especially Workers’ Compensation. Acts as a Subject Matter Expert (SME) on enterprise data warehouse (EDW) content and insurance source systems, ensuring accurate data interpretation, strong data lineage, and reliable, business-aligned reporting outputs.

ROLE RESPONSIBILITIES
• Act as a Data & Domain SME across P&C insurance subject areas including policy, claims, billing, and financials.
• Demonstrate deep expertise in Commercial Lines:
Workers’ Compensation, General Liability, Commercial Auto, Property, Umbrella/Excess.
• Collaborate with business stakeholders to gather, analyze, and validate reporting and data extract requirements.
• Translate complex insurance business processes into data models, KPIs, metrics, and dimensional structures.
• Leverage strong knowledge of Guidewire (Policy Center, Claim Center, Billing Center), Genius, and SAP for accurate data interpretation and lineage.
• Explain and map policy lifecycle events (submission, quote, bind, issue, endorsements, renewal, cancellation, reinstatement) into warehouse models.
• Analyze claims lifecycle data including reserves, payments, recoveries, and claim financials.
• Perform data lineage, source-to-target mapping, and transformation analysis across ETL and EDW layers.
• Develop and validate complex SQL queries, views, and reporting datasets.
• Ensure data reconciliation and consistency between transactional systems and enterprise warehouse.
• Review and certify reports for accuracy, completeness, and regulatory compliance.
• Investigate and resolve data discrepancies across source systems, ETL pipelines, and reporting layers.
• Document data definitions, mappings, lineage, and business rules.
• Support UAT, defect resolution, and reporting enhancements.
• Educate stakeholders on data interpretation, reporting usage, and governance standards. TECHNICAL QUALIFICATIONS
• 13+ years of experience as a hands-on Reporting/Data Analyst in enterprise environments.
• 10+ years working with Enterprise Data Warehousing (EDW/DWH) solutions.
• 7+ years of experience in Property & Casualty Insurance (Commercial Lines).
• Strong domain expertise in Workers’ Compensation and claims analytics.
• 5+ years of experience with BI/reporting tools:
Micro Strategy, Power BI.
• Hands-on experience with Guidewire (Policy Center, Claim Center, Billing Center), Genius, SAP.
• Advanced SQL skills with extensive experience querying large-scale data warehouses.
• Strong understanding of:
• Data lineage and traceability
• Source-to-target mappings
• Dimensional modeling (facts, dimensions, aggregates)
• Enterprise reporting architecture
• Proven ability to reconcile data between source systems and warehouse environments. GENERAL QUALIFICATIONS
• Strong initiative with ability to self-manage in complex, ambiguous environments.
• Excellent communication and stakeholder management skills.
• Proven ability to work with senior business leaders and cross-functional teams.
• Ability to clearly explain complex data concepts to technical and non-technical audiences.
• Recognized as a trusted SME in Insurance Data & Data Warehousing. EDUCATION REQUIREMENTS
• Bachelor’s degree in Computer Science, MIS, or related field (or equivalent experience).