Data Reporting Analyst

Note:
Final round is onsite at client office.

HYBRID - 3 days on-site

Location - 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

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.

• 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.

• 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 Micro Strategy), 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.

• Bachelor's degree in Computer Science, MIS, related field, or equivalent experience.