Data Analyst

Sun LifeWaterloo, ON
CA$60,000 - CA$97,000Hybrid

About The Position

The Data Analyst is a strategic member of the Strategy & Analytics team, responsible for transforming data into actionable insights across multiple business functions. You will own the complete data lifecycle—from sourcing and ingesting data across systems to building robust data warehouses and delivering precision reporting solutions. This role combines data engineering expertise with analytical acumen, requiring you to work collaboratively with stakeholders while maintaining rigorous data governance standards. The ideal candidate brings 3-5 years of data analytics experience, holds a degree in Computer Science, Mathematics, Statistics, or Engineering, and demonstrates proven AWS proficiency. You'll need strong problem-solving skills, expertise in mutual fund and market-based insurance products, and the ability to communicate complex methodologies clearly to non-technical audiences. Success requires balancing technical depth with independent judgment and collaborative teamwork while managing multiple priorities simultaneously.

Requirements

  • 3-5 years of Data Engineering experience developing and supporting enterprise ETL/ELT pipelines, data integration processes, and automated workflows.
  • Strong SQL and Database Expertise, including relational and non-relational database design, schema development, query optimization, indexing, and performance tuning.
  • Advanced Data Modeling Skills, with demonstrated experience building semantic, dimensional, and transformation models that standardize data across systems and business domains.
  • Hands-on Cloud Data Platform Experience, including AWS and modern data warehouse technologies such as Snowflake, Redshift, or similar platforms.
  • Strong Programming and Data Integration Capabilities, including Python and experience integrating data from multiple internal and external sources while ensuring data quality, governance, and reliability.
  • Degree in Computer Science, Mathematics, Statistics, or Engineering.
  • Proven AWS proficiency.
  • Strong problem-solving skills.
  • Expertise in mutual fund and market-based insurance products.
  • Ability to communicate complex methodologies clearly to non-technical audiences.
  • Balancing technical depth with independent judgment and collaborative teamwork.
  • Managing multiple priorities simultaneously.

Nice To Haves

  • Experience in Financial Services, Mutual Funds, ETFs, Segregated Funds, or Investment Operations.
  • Experience with orchestration and automation tools (Airflow, AWS Glue, Step Functions, etc.).
  • Experience with Salesforce or other CRM platforms.
  • Experience supporting CI/CD and DevOps practices for data platforms.

Responsibilities

  • Design, develop, maintain, and optimize enterprise-grade ETL/ELT pipelines to ingest, transform, and integrate data from multiple internal and external sources.
  • Build and manage scalable, reliable, and secure data platforms, databases, and data warehouses, ensuring high availability, performance, and data integrity.
  • Develop and implement robust data modeling, transformation frameworks, and semantic layers to standardize business data and support downstream analytics, reporting, and operational applications.
  • Own data integration processes, including data quality monitoring, validation, reconciliation, lineage tracking, and error handling, ensuring completeness and accuracy across systems.
  • Collaborate with business and technical stakeholders to translate data requirements into scalable data solutions, while driving best practices in architecture, governance, and performance optimization.
  • Design and maintain database schemas, indexing strategies, partitioning approaches, and query optimization techniques to support growing data volumes and evolving business needs.
  • Implement and support cloud-based data solutions using AWS services, including data storage, orchestration, and automation capabilities.
  • Contribute to the continuous improvement of the enterprise data ecosystem through automation, CI/CD deployment practices, infrastructure-as-code, and operational monitoring.

Benefits

  • Hybrid work environment
  • A friendly, collaborative, and inclusive culture
  • 15 vacation days per year
  • Flexible Benefits from the day you join to meet the needs of you and your family
  • Pension, stock and savings programs to help build and enhance your future financial security
  • The opportunity to move along a variety of career paths with amazing networking potential
  • Access to our Global Learning Centre, available 24/7 for your learning needs
  • Wellness programs that support the three pillars of your health – mental, physical and financial
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service