Data Analyst

Job Title:

Senior Reporting Data Analyst

Location:

Toronto, Canada

Reporting, DWH, P&C;
Insurance (SME) Workers comp preferred

The Senior Reporting Data Analyst brings 15+ years of experience in enterprise data warehousing and reporting, with deep expertise in the Property & Casualty (P&C) insurance domain, especially Workers’ Compensation. Acts as a Subject Matter Expert (SME) on enterprise data warehouse (EDW) content and insurance source systems, ensuring accurate data interpretation, strong data lineage, and reliable, business-aligned reporting outputs.

• Act as a Data & Domain SME across P&C insurance subject areas including policy, claims, billing, and financials.
• Demonstrate deep expertise in Commercial Lines:
  Workers’ Compensation, General Liability, Commercial Auto, Property, Umbrella/Excess.
• Collaborate with business stakeholders to gather, analyze, and validate reporting and data extract requirements.
• Translate complex insurance business processes into data models, KPIs, metrics, and dimensional structures.
• Leverage robust knowledge of Guidewire (Policy Center, Claim Center, Billing Center), Genius, and SAP for accurate data interpretation and lineage.
• Explain and map policy lifecycle events (submission, quote, bind, issue, endorsements, renewal, cancellation, reinstatement) into warehouse models.
• Analyze claims lifecycle data including reserves, payments, recoveries, and claim financials.
• Perform data lineage, source-to-target mapping, and transformation analysis across ETL and EDW layers.
• Develop and validate complex SQL queries, views, and reporting datasets.
• Ensure data reconciliation and consistency between transactional systems and enterprise warehouse.
• Review and certify reports for accuracy, completeness, and regulatory compliance.
• Investigate and resolve data discrepancies across source systems, ETL pipelines, and reporting layers.
• Document data definitions, mappings, lineage, and business rules.
• Support UAT, defect resolution, and reporting enhancements.
• Educate stakeholders on data interpretation, reporting usage, and governance standards.

• 15+ years of experience as a hands-on Reporting/Data Analyst in enterprise environments.
• 10+ years working with Enterprise Data Warehousing (EDW/DWH) solutions.
• 7+ years of experience in Property & Casualty Insurance (Commercial Lines).
• Strong domain expertise in Workers’ Compensation and claims analytics.
• 5+ years of experience with BI/reporting tools:
  Micro Strategy, Power BI.
• Hands‑on experience with Guidewire (Policy Center, Claim Center, Billing Center), Genius, SAP.
• Advanced SQL skills with extensive experience querying large-scale data warehouses.
• Strong understanding of:
  • Data lineage and traceability
  • Source-to-target mappings
  • Dimensional modeling (facts, dimensions, aggregates)
  • Enterprise reporting architecture
  • Proven ability to reconcile data between source systems and warehouse environments

• Strong initiative with ability to self-manage in complex, ambiguous environments.
• Excellent communication and stakeholder management skills.
• Proven ability to work with senior business leaders and cross-functional teams.
• Ability to clearly explain complex data concepts to technical and non-technical audiences.
• Recognized as a trusted SME in Insurance Data & Data Warehousing.

• Bachelor’s degree in Computer Science, MIS, or related field (or equivalent experience).