Reporting Data Analyst With P&C Insurance
Locations: Alpharetta, GA; Charlotte, NC; Chicago, IL; Conshohocken, PA; Dallas, TX; Garden City, NY; Houston, TX; Morristown, NJ; Mt. Juliet, TN; New York, NY; Purchase, NY โ Hybrid 03 days per week onsite from day 1
Duration: Long Term
Visa: Any
Experience: 08+ Years
Pay rate: $60/Hr on C2C inclusive all
Responsibilities:
- Act as a data and domain analyst 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 Skills:
- 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.