Data Analyst

•   . 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.
ROLE SUMMARY
The Reporting Data Analyst partners with business groups across the Property & Casualty (P&C) insurance domain to define and deliver reporting and data extracts requirements. This role serves as a subject matter expert (SME) on enterprise data warehouse content and key source systems, ensuring accurate interpretation of insurance data, consistent definitions, and reliable reporting outputs.

ROLE RESPONSIBILITIES
•   Act as a data and domain SME 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 QUALIFICATIONS
•   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.