Data System Analyst

Description:

Data System Analyst

Location: Markham, ON 

Job Description

This role will be part of and a member of our Information Technology Data Delivery Group. You will be responsible for creating the center of excellence for the data ecosystem artifacts creation, maintenance, and project requirements in a high-performing, and experienced team. You'll be required to apply your depth of knowledge and expertise to all many areas including requirements, infrastructure, and solution documentations.

What you ll do
 

• Claims & Policy Data Analysis
   

Analyze structured and semi-structured data related to claims, policies, underwriting, and customer interactions.

Identify patterns in claims frequency, fraud indicators, and loss ratios using lakehouse datasets.

Support actuarial teams with data extracts and trend analysis.
 

• Customer & Risk Insights
   

Segment customers based on behavior, risk profiles, and product usage.

Analyze customer lifetime value, churn risk, and cross-sell/up-sell opportunities.

Collaborate with risk and compliance teams to monitor exposure and regulatory thresholds.
 

• Regulatory & Compliance Reporting
   

Prepare data extracts and reports for regulatory bodies (e.g., OSFI, FSRA, NAIC).

Ensure data lineage and traceability for audit and compliance purposes.

Validate data accuracy and completeness for filings and disclosures.
 

• Data Wrangling & Preparation
   

Clean and transform raw data from diverse sources (e.g., policy admin systems, CRM, claims systems) into analytics-ready formats.

Leverage lakehouse tools (e.g., Delta Lake, Apache Iceberg) to manage versioned and time-travel datasets.

Collaborate with data engineers to ensure efficient ETL/ELT processes.
 

• Business Intelligence & Visualization
   

Build dashboards and visualizations for underwriting, claims, finance, and product teams.

Use tools like Power BI, Tableau, or Qlik to present insights from lakehouse data.

Enable self-service analytics by creating reusable datasets and semantic layers.
 

• Data Quality & Governance
   

Profile and validate data to ensure consistency across policy, claims, and financial domains.

Tag and catalog datasets using metadata tools (e.g., Unity Catalog, Collibra).

Support master data management and reference data initiatives.
 

• Collaboration & Stakeholder Engagement