Total Required Experience in Years: Minimum 13+ Years Overall, 10+ Years EDW/DWH, 7+ Years P&C Insurance, 5+ Years BI/Reporting ToolsMode 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 robust enterprise data governance practices.Key ResponsibilitiesAct as a Data and Domain SME across Property & Casualty insurance subject areas including policy, claims, billing, and financial systemsDemonstrate expertise in Commercial Lines including Workers Compensation, General Liability, Commercial Auto, Property, and Umbrella/Excess insurance domainsCollaborate with business stakeholders to gather, analyze, validate, and document reporting requirements and data extract needsTranslate insurance business processes into dimensional models, KPIs, business metrics, and enterprise reporting structuresLeverage Guidewire platforms including Policy Center, Claim Center, Billing Center, Genius,



and SAP to interpret enterprise data and establish lineageMap policy lifecycle activities including submission, quote, bind, issue, endorsements, renewals, cancellations, and reinstatements into EDW structuresAnalyze claims lifecycle data including reserves, recoveries, payments, and financial reporting metricsPerform source-to-target mapping, data lineage analysis, transformation validation, and reconciliation across ETL and EDW environmentsDevelop, validate, and optimize complex SQL queries, reporting datasets, and views across enterprise warehouse environmentsEnsure consistency, reconciliation, and accuracy between source systems and enterprise warehouse reporting layersReview, certify, and validate reports for business accuracy, completeness, and compliance requirementsInvestigate and resolve data discrepancies across source systems, ETL pipelines, reporting environments, and warehouse layersDocument business rules, metadata, data lineage, mappings, and reporting definitionsSupport User Acceptance Testing (UAT), defect analysis, reporting enhancements, and production reporting supportEducate stakeholders on reporting interpretation, governance standards, and enterprise data usage best practicesAdditional ResponsibilitiesSupport enterprise reporting governance, insurance analytics,



and business intelligence initiativesCollaborate with senior business leaders and cross-functional technical teams on strategic reporting effortsProvide SME-level guidance on insurance data interpretation and enterprise reporting architectureFacilitate stakeholder discussions and explain complex data concepts to technical and non-technical audiencesSupport continuous improvement efforts for reporting quality, data governance, and warehouse optimizationRequired SkillsMinimum 13+ years of experience as a hands-on Reporting/Data Analyst in enterprise environmentsMinimum 10+ years of experience working with Enterprise Data Warehousing (EDW/DWH) solutionsMinimum 7+ years of Property & Casualty (P&C) Insurance experience, preferably Commercial LinesStrong domain expertise in Workers Compensation and claims analyticsMinimum 5+ years of experience with BI and reporting tools such as Power BI and Micro StrategyHands-on experience with Guidewire (Policy Center, Claim Center, Billing Center), Genius, and SAPAdvanced SQL experience working with large-scale enterprise data warehousesStrong understanding of data lineage, traceability, dimensional modeling, source-to-target mapping, and reporting architectureProven experience reconciling data between enterprise transactional systems and warehouse environmentsStrong stakeholder communication, documentation, analytical, and problem-solving skillsQualificationsStrong experience working in enterprise insurance, data warehousing, and reporting environments requiredRecognized SME-level expertise in Insurance Data and Data Warehousing preferredAbility to work independently in complex and ambiguous environments requiredCanada Citizen or Permanent Resident requiredEducationBachelors degree in Computer Science, MIS, or related field (or equivalent experience) requiredCertificationsPower BI certification preferredData Warehousing or Business Intelligence certification preferred#J-18808-Ljbffr

📌 Reporting Data Analyst (Hybrid) (Quebec City)
🏢 SIRITECH SOLUTIONS
📍 Quebec City