Reporting Data Analyst (Hybrid)

SIRITECH SOLUTIONS CORP; Charlotte (NC); Hybrid; USD 140,000 - 180,000; Full time

Job summary

SIRITECH SOLUTIONS CORP is seeking a highly experienced Reporting Data Analyst to support enterprise reporting, data warehousing, analytics, and insurance data initiatives in a P&C environment.

The role requires SME-level expertise in insurance data, data governance, and enterprise reporting architecture, with hands-on experience in Guidewire and SQL within large data warehouses. Hybrid work arrangement and senior stakeholder collaboration are essential.

Qualifications

• 13+ years hands-on experience in reporting/data analytics in enterprise environments.
• 10+ years with EDW/DWH solutions and 7+ years in P&C insurance contexts.
• Experience with Guidewire, SAP and large-scale SQL querying.

Responsibilities

• Serve as Data and Domain SME across P&C insurance domains including policy, claims and billing.
• Translate business processes into dimensional models, KPIs, and enterprise reporting structures.
• Collaborate with stakeholders to gather and document reporting requirements and data extracts.
• Develop, validate, and optimize SQL queries and reporting datasets in EDW environments.
• Ensure data lineage, accuracy, and reconciliation between source systems and warehouse layers.
• Review and certify reports for accuracy, completeness, and regulatory compliance.
• Support UAT, defect analysis, and production reporting, providing SME guidance.

Skills

EDW/DWH

P&C Insurance

Guidewire

SQL

Dimensional Modeling

Data Lineage

Power BI

MicroStrategy

Data Governance

Stakeholder Communication

Education

Bachelors degree in CS or MIS

Tools

Guidewire Platform

SAP

Job description

Total Required Experience in Years: Minimum 13+ Years Overall, 10+ Years EDW/DWH, 7+ Years P&C Insurance, 5+ Years BI/Reporting Tools

Visa: H1/GC/ USC

Mode of Work: Hybrid (3 Days Onsite)

Job Description: Seeking an experienced Reporting Data Analyst to support enterprise reporting, data warehousing, analytics, and insurance data initiatives within a Property & Casualty (P&C) insurance environment. The ideal candidate should possess deep expertise in enterprise data warehousing, reporting, Workers Compensation, insurance data interpretation, Guidewire systems, SQL, dimensional modeling, and reporting architecture. This role requires acting as a Subject Matter Expert (SME) for enterprise insurance data, translating complex business processes into reporting structures, ensuring accurate data lineage, validating enterprise reporting outputs, and supporting analytics initiatives aligned with business objectives and regulatory requirements. The candidate will collaborate with business leaders, technical teams, and stakeholders to ensure reliable reporting, accurate warehouse data interpretation, and strong enterprise data governance practices.

Key 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
• Educate stakeholders on reporting interpretation, governance standards, and enterprise data usage best practices

Additional Responsibilities

• Support enterprise reporting governance, insurance analytics, and business intelligence initiatives
• Collaborate with senior business leaders and cross-functional technical teams on strategic reporting efforts
• Provide SME-level guidance on insurance data interpretation and enterprise reporting architecture
• Facilitate stakeholder discussions and explain complex data concepts to technical and non-technical audiences
• Support continuous improvement efforts for reporting quality, data governance, and warehouse optimization

Required Skills

• 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

• Strong experience working in enterprise insurance, data warehousing, and reporting environments required
• Recognized SME-level expertise in Insurance Data and Data Warehousing preferred
• Ability to work independently in complex and ambiguous environments required
• Canada Citizen or Permanent Resident required

Education

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

Certifications

• Power BI certification preferred
• Data Warehousing or Business Intelligence certification preferred