Reporting Data Analyst (Hybrid)

About the role

As a Reporting/Data Analyst at Siritech Solutions Corp, you will be responsible for translating insurance business processes into dimensional models, KPIs, business metrics, and enterprise reporting structures. You will collaborate with business stakeholders to gather, analyze, validate, and document reporting requirements and data extract needs.

Responsibilities

• Act as a Data and Domain SME across Property & Casualty insurance subject areas including policy, claims, billing, and financial systems.
• Demonstrate expertise in Commercial Lines including Workers Compensation, General Liability, Commercial Auto, Property, and Umbrella/Excess insurance domains.
• Collaborate with business stakeholders to gather, analyze, validate, and document reporting requirements and data extract needs.
• Translate insurance business processes into dimensional models, KPIs, business metrics, and enterprise reporting structures.
• Leverage Guidewire platforms including PolicyCenter, ClaimCenter, BillingCenter, Genius, and SAP to interpret enterprise data and establish lineage.
• Map policy lifecycle activities including submission, quote, bind, issue, endorsements, renewals, cancellations, and reinstatements into EDW structures.
• Analyze claims lifecycle data including reserves, recoveries, payments, and financial reporting metrics.
• Perform source-to-target mapping, data lineage analysis, transformation validation, and reconciliation across ETL and EDW environments.
• Develop, validate, and optimize complex SQL queries, reporting datasets, and views across enterprise warehouse environments.
• Ensure consistency, reconciliation, and accuracy between source systems and enterprise warehouse reporting layers.
• Review, certify, and validate reports for business accuracy, completeness, and compliance requirements.
• Investigate and resolve data discrepancies across source systems, ETL pipelines, reporting environments, and warehouse layers.
• Document business rules, metadata, data lineage, mappings, and reporting definitions.
• Support User Acceptance Testing (UAT), defect analysis, reporting enhancements, and production reporting support.
• Education stakeholders on reporting interpretation, governance standards, and enterprise data usage best practices.

Requirements

• Minimum 13+ years of experience as a hands-on Reporting/Data Analyst in enterprise environments.
• Minimum 10+ years of experience working with Enterprise Data Warehousing (EDW/DWH) solutions.
• Minimum 7+ years of Property & Casualty (P&C) Insurance experience, preferably Commercial Lines.
• Strong domain expertise in Workers Compensation and claims analytics.
• Minimum 5+ years of experience with BI and reporting tools such as Power BI and MicroStrategy.
• Hands-on experience with Guidewire (PolicyCenter, ClaimCenter, BillingCenter), Genius, and SAP.
• Advanced SQL experience working with large-scale enterprise data warehouses.
• Strong understanding of data lineage, traceability, dimensional modeling, source-to-target mapping, and reporting architecture.
• Proven experience reconciling data between enterprise transactional systems and warehouse environments.
• Strong stakeholder communication, documentation, analytical, and problem-solving skills.

Qualifications

• Minimum 13+ years of experience as a hands-on Reporting/Data Analyst in enterprise environments.
• Minimum 10+ years of experience working with Enterprise Data Warehousing (EDW/DWH) solutions.
• Minimum 7+ years of Property & Casualty (P&C) Insurance experience, preferably Commercial Lines.
• Strong domain expertise in Workers Compensation and claims analytics.
• Minimum 5+ years of experience with BI and reporting tools such as Power BI and MicroStrategy.
• Hands-on experience with Guidewire (PolicyCenter, ClaimCenter, BillingCenter), Genius, and SAP.
• Advanced SQL experience working with large-scale enterprise data warehouses.
• Strong understanding of data lineage, traceability, dimensional modeling, source-to-target mapping, and reporting architecture.
• Proven experience reconciling data between enterprise transactional systems and warehouse environments.
• Strong stakeholder communication, documentation, analytical, and problem-solving skills.

Skills

• Strong experience working in enterprise insurance, data warehousing, and reporting environments.
• Recognized SME-level expertise in Insurance Data and Data Warehousing.
• Ability to work independently in complex and ambiguous environments.

Benefits

• Dynamic and innovative startup specializing in providing cutting-edge web, mobile, and software development solutions to clients worldwide.
• Comprehensive suite of services tailored to meet the diverse needs of businesses across various industries.

Pay

Not specified

Schedule

Not specified