Job Title

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 (PolicyCenter, ClaimCenter, BillingCenter), 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: MicroStrategy, Power BI. • Hands-on experience with Guidewire (PolicyCenter, ClaimCenter, BillingCenter), 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).