Reporting Data Analyst with P&C Insurance
Cerebra Consulting - Conshohocken, PA
Apply NowJob Description
Title: 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 Client: P&C Insurance Pay rate: $68/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.
Created: 2026-03-13