Contractor

HCL Technologies•New York, NY

1d•Hybrid

About The Position

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.

Requirements

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.
Strong initiative; able to self-manage. Comfortable with ambiguity and able to work through it to get the right things done.
Excellent Communication skills, both written and verbal, understanding communication channels and escalation paths.
Proven experience working directly with senior business stakeholders

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.