Reporting Data Analyst
ROLE LOCATION(S)
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
ROLE SUMMARY
The Senior Reporting Data Analyst brings 13+ years of experience in enterprise data warehousing and reporting, with deep expertise in the Property & Casualty (P&C) insurance domain, especially Workers' Compensation. Acts as a Subject Matter Expert (SME) on enterprise data warehouse (EDW) content and insurance source systems, ensuring accurate data interpretation, strong data lineage, and reliable, business-aligned reporting outputs.
ROLE RESPONSIBILITIES
Act as a Data & Domain SME across P&C insurance subject areas including policy, claims, billing, and financials.
Demonstrate deep expertise in Commercial Lines: Workers' Compensation, General Liability, Commercial Auto, Property, Umbrella/Excess.
Collaborate with business stakeholders to gather, analyze, and validate reporting and data extract requirements.
Translate complex insurance business processes into data models, KPIs, metrics, and dimensional structures.
Leverage strong knowledge of Guidewire (PolicyCenter, ClaimCenter, BillingCenter), Genius, and SAP for accurate data interpretation and lineage.
Explain and map policy lifecycle events (submission, quote, bind, issue, endorsements, renewal, cancellation, reinstatement) into warehouse models.
Analyze claims lifecycle data including reserves, payments, recoveries, and claim financials.
Perform data lineage, source-to-target mapping, and transformation analysis across ETL and EDW layers.
Develop and validate complex SQL queries, views, and reporting datasets.
Ensure data reconciliation and consistency between transactional systems and enterprise warehouse.
Review and certify reports for accuracy, completeness, and regulatory compliance.
Investigate and resolve data discrepancies across source systems, ETL pipelines, and reporting layers.
Document data definitions, mappings, lineage, and business rules.
Support UAT, defect resolution, and reporting enhancements.
Educate stakeholders on data interpretation, reporting usage, and governance standards.
TECHNICAL QUALIFICATIONS
13+ years of experience as a hands-on Reporting/Data Analyst in enterprise environments.
10+ years working with Enterprise Data Warehousing (EDW/DWH) solutions.
7+ years of experience in Property & Casualty Insurance (Commercial Lines).
Strong domain expertise in Workers' Compensation and claims analytics.
5+ years of experience with BI/reporting tools: MicroStrategy, Power BI.
Hands-on experience with Guidewire (PolicyCenter, ClaimCenter, BillingCenter), Genius, SAP.
Advanced SQL skills with extensive experience querying large-scale data warehouses.
Strong understanding of:
Data lineage and traceability
Source-to-target mappings
Dimensional modeling (facts, dimensions, aggregates)
Enterprise reporting architecture
Proven ability to reconcile data between source systems and warehouse environments.
GENERAL QUALIFICATIONS
Strong initiative with ability to self-manage in complex, ambiguous environments.
Excellent communication and stakeholder management skills.
Proven ability to work with senior business leaders and cross-functional teams.
Ability to clearly explain complex data concepts to technical and non-technical audiences.
Recognized as a trusted SME in Insurance Data & Data Warehousing.
EDUCATION REQUIREMENTS
Bachelor's degree in Computer Science, MIS, or related field (or equivalent experience).
...Our client is a large Consumer Products | Retail| eCommerce Company with locations throughout the United States. They are growing and... ...high-paced and at times stressful environment Proficient with Google, Microsoft Office Suite or related software Experience...
...Educational Equality Institute (TEEI), in partnership with the Verkhovna Rada (Ukrainian Parliament), seeks passionate Volunteer English Teachers to deliver engaging online English language training sessions for Ukrainian parliamentary staff. Volunteers will play a...
...Others! We value each and every one of our employees. Whether you are looking to launch a new career in one of our many convenient Store locations, Distribution Centers, Store Support Center or with our Private Fleet Team, we are proud to provide a wide range of career...
...PURPOSE AND SCOPE: Functions as part of the dialysis health care team in providing safe and effective dialysis therapy for patients under the direct supervision of a licensed nurse in accordance with organization policies...
K12 International school in Huqiu, Suzhou, Jiangsu is hiring for Aug. Vacancy: 1 MYP English teacherBasic salary: Primary school: 26,000-28,000 rmb/m before tax); Middle school: 30,000-34,000RMB before tax , Housing allowance: 1,500 RMB /m, Air ticket: 10,000...