Talent.com
Siritech Solutions Corp
Reporting Data Analyst (Hybrid)Siritech Solutions Corp • Mississauga, ON, CAN
Reporting Data Analyst (Hybrid)

Reporting Data Analyst (Hybrid)

Siritech Solutions Corp • Mississauga, ON, CAN
4 days ago
Job type
  • Permanent
Job description

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

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%2B years of experience as a hands-on Reporting/Data Analyst in enterprise environments
  • Minimum 10%2B years of experience working with Enterprise Data Warehousing (EDW/DWH) solutions
  • Minimum 7%2B years of Property & Casualty (P&C) Insurance experience, preferably Commercial Lines
  • Strong domain expertise in Workers Compensation and claims analytics
  • Minimum 5%2B 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



Create a job alert for this search

Reporting Data Analyst (Hybrid) • Mississauga, ON, CAN

Similar jobs

Remote Growth Data Analyst for Crypto Analytics

P2PMississauga, Peel Region, CA
Remote
Full-time

A leading crypto company is seeking a Data Analyst, Growth to turn complex growth marketing data into actionable insights.This remote role requires 7+ years of data analysis experience with experti... Show more

 • Promoted

Oakville Fire Data Analyst

Oakville Enterprises CorporationOakville
Full-time +1

If you do not receive an email within 24 hours confirming receipt of your application, please contact Human Resources from 8:30 a.Save your resume and cover letter together in one document before y... Show more

 • Promoted

Fund Reporting Analyst

Mandeville Private Client Inc.Burlington, Halton Region, Canada
Full-time

For our affiliate, Portland Investment Counsel Inc.Portland Investment Counsel Inc.Portland) is a premier Canadian investment counsel firm based in Burlington, Ontario, specializing in high-convict... Show more

 • Promoted

Data Analyst - Pyramid Consulting, Inc

Pyramid Consulting, Incmississauga, on, ca
Temporary

Please review the job description below and contact me ASAP if you are interested.Pay Range: CAD 30 - CAD 36/hour.Collect, clean, and analyze structured datasets to support operational and strategi... Show more

 • Promoted

AI-Driven Accounting Analyst (Remote)

Crossing HurdlesMississauga, Peel Region, CA
Remote
Full-time

A Canadian financial services firm is seeking an Accounting Analyst to analyze complex financial data and support AI model training.The role requires a Bachelor’s degree in Accounting, with a minim... Show more

 • Promoted

Data Reporting Lead Analyst - VP

Citigroup Inc.Mississauga, Peel region, Canada
Full-time

We are seeking a highly analytical and technically proficient Data Reporting Lead Analyst to support the Markets Technology PMO organization.The successful candidate will be responsible for extract... Show more

 • Promoted

Reporting Analyst

CAA Club GroupVaughan, York Region, CA
Full-time

For over 50 years, our Property and Casualty insurance Company, CAA Insurance, has provided dependable and trustworthy service to protect Canadians and what matters to them.CAA Insurance Company of... Show more

 • Promoted

Mining Project Reporting Analyst — Power BI

Phase ConsultingMississauga, Peel Region, CA
Full-time

A leading consulting firm is seeking a Reporting Specialist to support major mining and construction projects.The role involves consolidating data, delivering actionable insights, and building dash... Show more

 • Promoted

Remote Senior Analyst Role Focused on Workforce Data Analytics

VictraysMississauga, Peel Region, CA
Remote
Full-time

Join a dynamic team as a Senior Analyst specializing in People Analytics.Harness workforce data to provide strategic insights and foster employee engagement in a remote capacity.In this influential... Show more

 • Promoted

Financial Data & Reporting Analyst

Magnotta Wine, Beer, and SpiritsVaughan
Full-time

The Financial Data and Reporting Analyst is responsible for collecting, validating, analyzing, and interpreting large volumes of financial and operational data.This role builds custom reports, auto... Show more

 • Promoted

Reporting Specialist

Trillium Guideway Partnersmississauga, on, ca
Full-time

The Primary Construction Team consists of ACCIONA Infrastructure Canada Inc.ACCIONA) and Amico Major Projects Inc.Amico), as Trillium Guideway Partners (TGP).The Ontario Line (“OL”) is a fully inte... Show more

 • Promoted

Senior Reporting and Operational Analyst

FinastraMississauga, Peel Region, CA
Full-time

At Finastra, we’re a global leader in financial services software, dedicated to expanding access to financial services and shaping what’s next for the industry.Our technology powers mission‑critica... Show more

 • Promoted

Fund Reporting Analyst

Mandeville Holdings Inc.Burlington, Halton Region, Canada
Full-time

For our affiliate, Portland Investment Counsel Inc.Portland Investment Counsel Inc.Portland) is a premier Canadian investment counsel firm based in Burlington, Ontario, specializing in high-convict... Show more

 • Promoted

HR Reporting Analyst

Echelon 56Vaughan
Full-time

At CAA Club Group, we are passionate about keeping our Members safe—whether they are on the road, at home, or travelling abroad.As a trusted Member-based organization, we provide products and servi... Show more

 • Promoted

Automotive Data Analyst — Remote, High-Impact Insights

ArsenaultMississauga, Peel Region, CA
Remote
Full-time

A leading technology firm in Montreal is seeking a Business Analyst to analyze automotive market data and deliver insights.The ideal candidate will have over 1 year of experience, strong analytical... Show more

 • Promoted

E‑commerce Finance Analyst: Close, Reporting & Analytics

American TallMississauga
Full-time

A prominent e-commerce clothing brand in Peel Region, Mississauga, seeks a detail-oriented Financial Analyst to enhance financial planning, operational finance, and accounting processes.The success... Show more

 • Promoted

Oakville Fire Data Analyst

Town of OakvilleOakville, ON, CA
Full-time

What gets measured, gets managed.The incumbent is a critical resource in our relentless pursuit of continuous improvement by ensuring the end‑to‑end journey is tracked, measured, and reported on.Ke... Show more

 • Promoted

Data Analyst - burlington

Quarry Consultingburlington, on, ca
Full-time

Must be Eligible for Reliability Status.Gather, document, and analyze data and information management requirements.Work with stakeholders to translate business needs into data solutions and product... Show more

 • Promoted

Analyst, Benchmarking & Data Analytics - Canadian Bankers Association

Canadian Bankers Associationmississauga, on, ca
Full-time

About the Canadian Bankers Association.The Canadian Bankers Association is the voice of more than 60 domestic and foreign banks that help drive Canada’s economic growth and prosperity.The CBA advoc... Show more

 • Promoted

JR Finance & Reporting Analyst (Mississauga)

ManpowerMississauga, Peel Region, CA
Full-time

JR Finance & Reporting Analyst.Monday to Friday | 9:00 AM – 5:00 PM.Support sales analytics and reporting activities to improve data accuracy and efficiency.Analyze customer rebate trends and assis... Show more