Senior Data Analyst building trusted financial metrics, dbt models, and Looker dashboards for Jane’s clinic - management SaaS platform. Partnering with Finance and Payments to guide critical decisions.
About the role
- Data Analyst building AWS data platforms and pipelines for Sun Life, a financial services and insurance company. Delivering governed analytics, reporting, and insights across business functions.
Responsibilities
- Design, develop, maintain, and optimize enterprise-grade ETL/ELT pipelines
- Ingest, transform, and integrate data from multiple internal and external sources
- Build and manage scalable, reliable, and secure data platforms, databases, and data warehouses
- Develop data modeling, transformation frameworks, and semantic layers for analytics, reporting, and operational applications
- Own data integration processes, including quality monitoring, validation, reconciliation, lineage tracking, and error handling
- Translate data requirements into scalable data solutions with business and technical stakeholders
- Drive best practices in architecture, governance, and performance optimization
- Design and maintain database schemas, indexing strategies, partitioning approaches, and query optimization techniques
- Implement and support cloud-based data solutions using AWS services
- Improve the enterprise data ecosystem through automation, CI/CD, infrastructure-as-code, and operational monitoring
Requirements
- 3–5 years of Data Engineering experience developing and supporting enterprise ETL/ELT pipelines, data integration processes, and automated workflows
- Degree in Computer Science, Mathematics, Statistics, or Engineering
- Strong SQL and database expertise, including relational and non-relational database design, schema development, query optimization, indexing, and performance tuning
- Advanced data modeling skills, including semantic, dimensional, and transformation models
- Hands-on AWS and modern data warehouse experience such as Snowflake, Redshift, or similar platforms
- Python and data integration experience across internal and external sources
- Ability to ensure data quality, governance, and reliability
- Expertise in mutual funds and market-based insurance products
- Strong problem-solving skills and ability to communicate complex methodologies to non-technical audiences
- Experience with Financial Services, Mutual Funds, ETFs, Segregated Funds, or Investment Operations preferred
- Experience with Airflow, AWS Glue, Step Functions, or similar orchestration and automation tools preferred
- Experience with Salesforce or other CRM platforms preferred
- Experience supporting CI/CD and DevOps practices for data platforms preferred
- Some travel may be required
- Extra hours may be required during quarter-end reporting periods and periods with high mutual fund trading volumes
- Reliability Status Clearance required
- Must account for activities if lived or travelled outside Canada for 6 consecutive months during the last 5 years as part of the Government of Canada clearance process
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
- Incentive plans for eligible employees, subject to individual and company performance
- Accommodation in the application process for persons with disabilities
Job title
Job type
Experience level
Salary
Degree requirement
Tech skills
Location requirements
Report this job
Found something wrong with the page? Please let us know by submitting a report below.
Digital media specialist improving campaign tracking, reporting and analytics at a Toronto marketing technology lab. Automating insights with AI while maintaining data quality and measurement accuracy.
Data Analytics Intern analyzing new features and updates for Montreal - based mobile gaming studio Ludia. Building data modules, dashboards, and insights to optimize game operations.
Senior Data Analyst transforming Sun Life insurance and financial - services data into actionable marketing insights. Building SQL, Python, AWS, Adobe Analytics, reporting, and dashboard solutions.
Student Data Analyst supporting Sun Life’s financial security mission through stakeholder insights and Tableau KPI reporting. Building data analysis skills during a four - month hybrid campus placement.
Analyste de données principal modernisant les plateformes et pipelines de données d’EDC, société financière publique canadienne. Traduction des besoins opérationnels en modèles, règles de transformation et récits utilisateurs.
Senior Data Analyst modernizing enterprise data capabilities at Export Development Canada. Translating business requirements into data models, mappings, pipelines and Agile delivery artifacts.
Data Analyst improving Instacart’s online grocery fulfillment quality through operational analytics. Monitoring retailer performance, diagnosing issues, and delivering recommendations to cross - functional stakeholders.
Web Analyst owning GA4, GTM, pixel, and conversion tracking for an education and nonprofit marketing agency. Ensuring accurate, privacy - compliant data across client campaigns and CRM systems.
Data Analyst supporting client data migrations and corporate actions for Computershare, a global financial administration and transfer agency leader. Ensuring data quality, mapping, validation, and operational sign - off.