What are the responsibilities and job description for the Data Reporting Analyst position at Value Innovation Labs?
🚨 Hiring: Senior Reporting Data Analyst 🚨
📍 Locations: 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
We are seeking an experienced Senior Reporting Data Analyst with deep expertise in Enterprise Data Warehousing (EDW), Reporting & Analytics, and Property & Casualty (P&C) Insurance. This role will serve as a Subject Matter Expert (SME) for enterprise reporting, insurance data interpretation, data lineage, and business-aligned analytics solutions.
- Reporting, DWH, P&C Insurance SME, Workers Comp preferred
🔹 Key Responsibilities
• Serve as a Data & Domain SME across P&C Insurance subject areas including Policy, Claims, Billing, and Financials.
• Provide deep expertise in Commercial Lines including Workers’ Compensation, General Liability, Commercial Auto, Property, and Umbrella/Excess.
• Partner with business stakeholders to gather, analyze, and validate reporting and data requirements.
• Translate insurance business processes into dimensional models, KPIs, metrics, and reporting solutions.
• Leverage Guidewire (PolicyCenter, ClaimCenter, BillingCenter), Genius, and SAP for data analysis and lineage.
• Map policy lifecycle events including Submission, Quote, Bind, Issue, Endorsements, Renewal, Cancellation, and Reinstatement into warehouse structures.
• Analyze claims lifecycle data including reserves, payments, recoveries, and claim financials.
• Perform source-to-target mapping, data lineage analysis, and transformation validation across ETL and EDW environments.
• Develop, optimize, and validate complex SQL queries, views, and reporting datasets.
• Reconcile data between source systems and enterprise data warehouses to ensure consistency and accuracy.
• Review and certify reports for business accuracy, completeness, and regulatory compliance.
• Investigate and resolve data discrepancies across source systems, ETL processes, and reporting layers.
• Document business rules, mappings, lineage, and data definitions.
• Support UAT, reporting enhancements, and defect resolution activities.
• Guide stakeholders on data interpretation, reporting standards, and governance best practices.
🔹 Required Qualifications
• 13 years of experience as a Reporting/Data Analyst in enterprise environments.
• 10 years of experience working with Enterprise Data Warehousing (EDW/DWH) platforms.
• 7 years of Property & Casualty Insurance experience, specifically Commercial Lines.
• Strong expertise in Workers’ Compensation and Claims Analytics.
• 5 years of experience with BI and Reporting tools including MicroStrategy and Power BI.
• Hands-on experience with Guidewire (PolicyCenter, ClaimCenter, BillingCenter), Genius, and SAP.
• Advanced SQL skills with experience working on large-scale enterprise data warehouses.
• Strong understanding of:
- Data Lineage & Traceability
- Source-to-Target Mapping
- Dimensional Data Modeling
- Enterprise Reporting Architecture
- Data Reconciliation & Validation
🔹 Preferred Candidate Profile
✔ Strong stakeholder management and communication skills.
✔ Ability to explain complex data concepts to both technical and business audiences.
✔ Proven experience working with senior leadership and cross-functional teams.
✔ Recognized SME in Insurance Data, Reporting, and Data Warehousing.
✔ Self-driven and capable of working in highly complex enterprise environments.
🎓 Education
Bachelor’s Degree in Computer Science, MIS, Information Systems, or related field (or equivalent experience).
📩 If you have strong P&C Insurance, Workers’ Compensation, Guidewire, EDW, SQL, Power BI, and MicroStrategy experience, please share your updated resume and contact details.