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).
...location. This role is also anticipated to be eligible to participate in an annual bonus and long term incentive plan. At The Cigna Group, youll enjoy a comprehensive range of benefits, with a focus on supporting your whole health. Starting on day one of your...
...assigned site, while working with youth in our public schools. The Engagement Specialist will work with the program participants and YMCA leadership, to provide after-school activities infusing youth-voice and inclusion through activities such sports, leadership, e-...
...We are seeking a reliable and hardworking Concrete Laborer for a job in Augusta ME. The ideal candidate will assist in various concrete construction tasks, including mixing, pouring, spreading, smoothing, and finishing concrete jobs. Pay is $23-26 an hour DOE Long...
...We have an immediate need for a Senior Structural Engineer for our Newton, MA Office. Come join our team! We are looking... ...a representative of the firm. Actively participate in local industry organizations and business development functions. Support the...
...best practices. 5+ years of experience in database architecture, data modeling, schema design, and executing large-scale data... ...experience implementing SQL Server high availability and disaster recovery solutions (Always On Availability Groups, Database Mirroring, Log...