Data Analyst

About the role

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. What will you do? Data engineering and pipeline management (Data ingestion, ETL management) Work with stakeholders to understand data needs and provide actionable solutions Design and build scalable databases and data warehouses to support business intelligence and analytics initiatives Source data from multiple internal and external systems, ensuring data quality and completeness Develop and implement semantic data models and transformation logic to standardize data across various business domains What do you need to succeed? 3 to 5 years of experience in ETL, data analytics and report building roles. Demonstrated experience in semantic data modeling and transformation, including the ability to design and implement data models that standardize business terminology, establish data relationships, and enable consistent interpretation across various domains and systems Successful completion of B.Sc. Computer Science, Mathematics, Stats, Engineering or applicable program. Proficiency in database design and implementation, including experience with relational and non-relational database systems, schema design, and optimization techniques for performance and scalability Proven application or utilization of AWS in a business environment Strong Mutual Fund and Market-Based Insurance product knowledge. Preferred Skills: Knowledge of the investment operations lifecycle, including trade processing, settlement, reconciliation, portfolio accounting, and compliance. Strong experience and knowledge of individual financial service industry on a greater scale (knowledge of mutual funds, segregated funds, exchange-traded funds (ETFs), SMAs, etc.) Experience with Python, R, Tableau, AWS, SQL, SnowFlake Experience with CRM tools or Salesforce specifically Unique Requirements: Some travel may be required. Extra hours may be required during the quarter-end reporting periods and during periods with high mutual fund trading volumes. What's in it for you? 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 Recent Awards: We are honoured to be recognized as a 2022, 2023, 2024 and 2025 Best Workplaces in Canada by Great Place to Work® Canada Great Place to Work® list for Best Workplaces for #HybridWork 2022 Great Place to Work® list for Best Workplaces for Professional Development in Canada 2022 Named " Best Places to Work " by Glassdoor, 2021 and 2023 The Base Pay range is for the primary location for which the job is posted. It may vary depending on the work location of the successful candidate or other factors. In addition to Base Pay, eligible Sun Life employees participate in various incentive plans, payment under which is discretionary and subject to individual and company performance. Certain sales focused roles have sales incentive plans based on individual or group sales results. Diversity and inclusion have al

Benefits

Additional Information

You are as unique as your background, experience and point of view. Here, you'll be encouraged, empowered and challenged to be your best self. You'll work with dynamic colleagues - experts in their fields - who are eager to share their knowledge with you. Your leaders will inspire and help you reach your potential and soar to new heights. Every day, you'll have new and exciting opportunities to make life brighter for our Clients - who are at the heart of everything we do. Discover how you can make a difference in the lives of individuals, families and communities around the world. Job Description:

Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at sunlife? Share your experience