Title:  Reporting Data Analyst

Locations 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

Visa- EAD/GC/USC 

No H1b.

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.

GENERAL QUALIFICATIONS

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

EDUCATION REQUIREMENTS

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