Reporting Data Analyst || 12 Months || Hybrid

Dice is the leading career destination for tech experts at every stage of their careers. Our client, Siri Infosolutions Inc, is seeking the following. Apply via Dice today! 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). Best Regards, Shikha Dixit| Email: LinkedIn: Lead Recruiter Siri InfoSolutions Inc, 3 Ethel Rd, Suite # 302, Edison NJ 08817.