Reporting Data Analyst
Role summary
The Reporting Data Analyst will partner with business groups within the Property & Casualty (P&C) insurance domain to define and deliver reporting and data extract requirements. This role requires deep expertise in enterprise data warehouse content and key source systems, ensuring accurate interpretation of insurance data, consistent definitions, and reliable reporting outputs. Responsibilities include collaborating with stakeholders, translating business concepts into data logic, creating and validating SQL queries, and ensuring reports align with business definitions and governance standards. The ideal candidate will have 8+ years of IT reporting data analyst experience, with at least 4 years in P&C insurance, and proficiency in SQL and BI tools like Power BI or MicroStrategy.
ROLE TITLE: Reporting Data Analyst
ROLE LOCATION(S):
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 (Hybrid - 3 days onsite)
Job Description:
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.
