Data Analyst
$60,000–$97,000 year
On-siteToronto, Ontario, Canada
Job Summary
Design, develop, and optimize enterprise-grade ETL/ELT pipelines to ingest, transform, and integrate data from multiple internal and external sources. Build and manage scalable, secure data platforms, databases, and warehouses while implementing robust data modeling, transformation frameworks, and semantic layers. Own data integration processes including quality monitoring, validation, reconciliation, and lineage tracking to ensure accuracy across systems. Collaborate with stakeholders to translate requirements into scalable solutions, driving best practices in architecture, governance, and performance optimization. Implement cloud-based data solutions using AWS services and contribute to continuous improvement through automation, CI/CD deployment, and infrastructure-as-code. Manage multiple priorities while balancing technical depth with independent judgment. Some travel may be required; extra hours may be needed during quarter-end reporting or high trading volumes. This role supports Sun Life's Strategy & Analytics team in transforming data into actionable insights for clients seeking financial security.
Required Qualifications
- 3-5 years of data analytics experience
- 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
- 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
- Some travel
- Extra hours during quarter-end reporting periods and during periods with high mutual fund trading volumes
- Reliability Status Clearance
- Account for all activities during the last 5 years for periods lived or travelled outside of Canada for 6 consecutive months
Desired Qualifications
- 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
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.