Reporting Data Analyst (Hybrid)SIRITECH SOLUTIONS CORP • Charlotte, North Carolina, United States
Reporting Data Analyst (Hybrid)
SIRITECH SOLUTIONS CORP
- Charlotte, North Carolina, United States
- Charlotte, North Carolina, United States
About
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)
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
#J-18808-Ljbffr
Languages
- English
Notice for Users
This job comes from a TieTalent partner platform. Click "Apply Now" to submit your application directly on their site.