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
- 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 concep