Reporting Data Analyst

Reporting Data Analyst ROLE LOCATION(S) Onshore, SI Office: Alpharetta, GA; Charlotte, NC; Chicago, IL; Conshohocken, PA; Dallas, TX; Denver, CO; Fargo, ND; Garden City, NY; Houston, TX; Lenexa, KS; Lubbock, TX; Morristown, NJ; Mt. Juliet, TN; New York, NY; Purchase, NY; Topeka, KS 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). #J-18808-Ljbffr