Reporting Data Analyst

Hi

Hope you are doing well!

Im Shikha Dixit Lead Recruiter at Siri Info. Ive 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 Id 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:

• Bachelors degree in Computer Science MIS or related field (or equivalent experience).