Reporting Data Analyst || 12 months || Hybrid

Hi,

Hope you are doing well!

I’m Shikha Dixit, Lead Recruiter at Siri Info. I’ve been reviewing your background in [Data Analytics, Reporting, Insurance, data warehousing, Guidewire], and your profile stands out as an excellent match for a “Reporting Data Analyst” opening I have in 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. This is a high-priority, Hybrid role with one of our key clients. Given your experience, I’d love to discuss the details and see if this aligns with your career goals. Are you open to a quick 5-minute chat?

Role: Reporting Data Analyst

Duration: 12 months

Location: 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)

Note: Strong in DW, Reporting, P&C Insurance, Guidewire Workers Comp – Lead experience

Job Description:-

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.

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 Qualification:

• 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 Qualification:

• 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:

• Bachelor’s degree in Computer Science, MIS, or related field (or equivalent experience).