Data Reporting Analyst

Title: Reporting Data Analyst with P&C Insurance Locations: GA/NC/IL/PA/ TX/CO/ND/NY/KS/NJ/TN – Hybrid 03 days per week from day 1 Responsibilities: • Act as a data and domain Analyst for P&C insurance subject areas (e.g., policy, claims, financials). • Collaborate with business stakeholders to gather, clarify, and validate reporting and extract requirements. • Translate insurance business concepts into accurate data logic, metrics, and dimensional definitions. • Leverage knowledge of source applications (e.g., Guidewire, Genius, SAP) to ensure correct data interpretation and lineage. • Ensure reports and extracts align with approved business definitions, regulatory needs, and data governance standards. • Create and validate SQL queries, views, or semantic-layer objects against the enterprise data warehouse. • Review and certify reports for accuracy, reconciliation, and consistency across systems. • Document data definitions, business rules, and reporting assumptions. • Support UAT and investigate data discrepancies between source systems and the data warehouse. • Educate business users on proper interpretation and usage of insurance data. Technical Skills: • 8+ years as a hands-on IT Reporting data analyst. • 4+ years of experience in reporting or data analysis within the Property & Casualty insurance industry; reinsurance experience is preferred but not required. • 3+ years hands-on experience with Strategy (formerly MicroStrategy), Microsoft Power BI or similar product. • Working knowledge of insurance source systems such as Guidewire (Policy, Billing, Claims), Genius, and SAP. • Strong SQL skills and experience querying enterprise data warehouses. • Understanding of dimensional modelling and enterprise reporting concepts.