Senior P&C Reporting & Data Warehouse SME (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

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.