<h3>Position Details</h3><ul><li>Role: Data Systems Analyst</li><li>Location: Markham, ON (Hybrid - 3 days onsite)</li></ul><h3>Key Responsibilities</h3><ul><li>Claims & Policy Data Analysis: Analyze structured/semi-structured data on claims, policies, underwriting, and customer interactions. Detect patterns in claims frequency, fraud indicators, and loss ratios.</li><li>Customer & Risk Insights: Segment customers, assess risk profiles, and identify cross-sell/up-sell opportunities. Support compliance teams with risk monitoring.</li><li>Regulatory & Compliance Reporting: Prepare accurate data extracts for regulators (OSFI, FSRA, NAIC) and ensure lineage and traceability for audits.</li><li>Data Wrangling & Preparation: Clean and transform raw data from multiple systems using lakehouse tools such as Delta Lake or Apache Iceberg.</li><li>Business Intelligence & Visualization: Build dashboards with Power BI, Tableau, or Qlik and enable self-service analytics.</li><li>Data Quality & Governance: Profile data, catalog datasets with metadata tools (Unity Catalog, Collibra), and support master/reference data initiatives.</li><li>Collaboration & Stakeholder Engagement: Work closely with actuaries, underwriters, product managers, and IT to translate business questions into analytical models.</li><li>Advanced Analytics Support: Assist data scientists with feature engineering, data extracts for model training, and integration of model outputs.</li></ul><h3>Qualifications</h3><ul><li>University degree in Computer Science/Engineering or related field.</li><li>8+ years as a Business/Data Analyst delivering enterprise data systems, including 5+ years leading Data Systems Analysis teams.</li><li>Expertise with Snowflake, Hadoop, PostgreSQL, Informatica, and large-scale enterprise data assets.</li><li>Strong ETL experience with the Informatica product suite.</li><li>Proven track record in data governance, metadata management, and documentation standards.</li><li>Excellent leadership, stakeholder management, and communication skills.</li><li>Insurance industry knowledge is an asset.</li></ul>
Position Details
Role: Data Systems Analyst
Location: Markham, ON (Hybrid - 3 days onsite)
Key Responsibilities
Claims & Policy Data Analysis: Analyze structured/semi-structured data on claims, policies, underwriting, and customer interactions. Detect patterns in claims frequency, fraud indicators, and loss ratios.
Customer & Risk Insights: Segment customers, assess risk profiles, and identify cross-sell/up-sell opportunities. Support compliance teams with risk monitoring.
Regulatory & Compliance Reporting: Prepare accurate data extracts for regulators (OSFI, FSRA, NAIC) and ensure lineage and traceability for audits.
Data Wrangling & Preparation: Clean and transform raw data from multiple systems using lakehouse tools such as Delta Lake or Apache Iceberg.
Business Intelligence & Visualization: Build dashboards with Power BI, Tableau, or Qlik and enable self-service analytics.
Data Quality & Governance: Profile data, catalog datasets with metadata tools (Unity Catalog, Collibra), and support master/reference data initiatives.
Collaboration & Stakeholder Engagement: Work closely with actuaries, underwriters, product managers, and IT to translate business questions into analytical models.
Advanced Analytics Support: Assist data scientists with feature engineering, data extracts for model training, and integration of model outputs.
Qualifications
University degree in Computer Science/Engineering or related field.
8+ years as a Business/Data Analyst delivering enterprise data systems, including 5+ years leading Data Systems Analysis teams.
Expertise with Snowflake, Hadoop, PostgreSQL, Informatica, and large-scale enterprise data assets.
Strong ETL experience with the Informatica product suite.
Proven track record in data governance, metadata management, and documentation standards.
Excellent leadership, stakeholder management, and communication skills.