Data & Analytics Analyst: Dashboards, Insights & Reporting

TechAlliance of Southwestern Ontario, London Economic Development Corporation; Toronto; On-site; CAD 66,000 - 88,000; Full time

Benefits offered by this job

Career development programs

Health and dental benefits

Mental health benefit

Volunteer day

Company-matching pension plan

Share ownership program

Employee discounts

Job summary

Canada Life in Toronto is seeking a highly skilled Data Analyst to join the Insurance Solutions team. You will support data management, analysis, and reporting to inform decision-making and produce insights for diverse audiences.

This role collaborates with data scientists and SMEs, builds data models, dashboards, and data marts, and translates requirements into actionable solutions while ensuring data quality and governance.

Qualifications

• University or College education in a related field, or an equivalent combination of education and experience.
• Experience working with raw data and manipulating large datasets.
• Proficiency in Excel, Power BI, data modelling, and Databricks, with experience creating interactive dashboards.
• Ability to work with diverse data inputs and build data marts aligned with business requirements.
• Proven ability to learn quickly, work independently, and manage multiple priorities in a fast-paced environment.
• Ability to write complex SQL queries to extract and integrate data from multiple sources.
• Proficiency in scripting languages such as Python or R.
• Hands-on experience with Azure compute services and a good understanding of Azure Data Factory pipelines.

Responsibilities

• Build, implement, and maintain data models, custom reports, and dashboards, keeping in mind the needs of varied audiences.
• Create visually compelling presentations and use strong communication skills to present them to stakeholders (ability to build a narrative that outlines the background and highlights the impact of initiatives).
• Identify opportunities to ingest data, prioritize data needs, and build data marts to drive efficiencies in reporting functions.
• Leverage data expertise to support new initiatives through analysis and ongoing reporting across the entire analytics lifecycle.
• Communicate requirements to the Technology team for development and ensure smooth deployment of data projects after performing data quality testing.
• Collaborate with cross-functional teams to gather requirements and deliver data solutions that meet business needs.
• Support existing data owners in their data management practices, ensuring a single source of truth.
• Work with large datasets that may be inconsistent, unclean, or not fully modeled.
• Ensure best practices are followed with respect to data governance and structure.
• Communicate effectively while demonstrating critical thinking and business acumen.

Skills

Excel

Power BI

SQL

Python

R

Data modelling

Databricks

Azure Data Factory

Communication

Education

University or College degree in related field

Tools

Azure Data Factory

Job description

Canada Life in Toronto is seeking a highly skilled Data Analyst to join the Insurance Solutions team. You will support data management, analysis, and reporting to inform decision-making and produce insights for diverse audiences.

This role collaborates with data scientists and SMEs, builds data models, dashboards, and data marts, and translates requirements into actionable solutions while ensuring data quality and governance.